All Macs starting with the mid-2007 iMac and late-2007 Macbook have at least one high power USB port. The drive itself does work just fine on 500ma ports though.
Tell that to my 2006 Mac Mini that it can't use a SuperDrive...... Or my 2011 MacBook Pro for that matter. Both had internal opticals. Mac Minis is dead and the MacBook Pros was removed. Both work fine with a SuperDrive. The Mini was released well before the first Air. There is nothing special about a SuperDrive. It's just an external USB optical. All macs (okay intel anyway) can use these.