Is it possible for an arduino, specifically it's sd card when it has one, to appear as a usb drive when plugged in to a pc?
How? The only software in the arduino is the minimal USB functionality in the translator, the bootloader and your sketch.
You would have to write a sketch to do it.
It is probably possible for a Leonardo (variant or Micro) to do so as the identity of the USB "device" can be manipulated (with corresponding firmware and not just a "sketch" loaded). All other versions appear only as a serial interface because they use a dedicated serial interface device - which also restricts the access speed.
Paul_B, you can reprogram the USB converter on a UNO, to make it look like a midi device, for example. I assume you can make it look like USB Mass Storage, too.
KeithRB:
Paul_B, you can reprogram the USB converter on a UNO, to make it look like a midi device, for example. I assume you can make it look like USB Mass Storage, too.
Yes, well the USB converter on a "late model" UNO is in fact, as it were, a Leonardo in itself. XD