I was wondering if I purchased the "Lightning to Micro USB Adapter" from Apple will I be able to use my USB Superdrive to play DVD movies on my iPad Air?


I'm pretty sure no. Where would you get the driver? Apple want you to buy your content from iTunes not Amazon prime.
I think it's cheaper and easier if you already have the movie disc (that's why you wanted a superdrive to work with the iPad), you can just rip to a format that you could play on your iPad.
The super drive has a full size usb and the lightning adapter is micro usb so it wouldn't even fit.
I already had the Superdrive when I purchased my MBA 3 years ago. I was wondering and curious to know if the Superdrive would work with the iPA since I have both, and I keep my iPA on a night stand where I can use it as a video player alongside the Superdrive.
I know I can rip the movies using HB, but the process of waiting for it to rip, then syncing the iPA to iTunes to do the transfer is much longer than simply plugging the Superdrive to the iPA and playing the movie.
----------
You are right! I just noticed that. The lightning adapter is a micro usb as described (and named) and the Superdrive is full size USB. Thanks.