TUAW has an interesting article on how to mod your MacBook Air's SuperDrive so that it can be used with other computers.
Unfortunately, this is NOT a good idea, as the Apple drive has significantly higher power requirements than that provided by a standard powered USB port. Especially when used in the DVD-burning mode.
If you look at similar third party drives, you'll notice that nearly every one REQUIRES an external power supply, or REQUIRES a Y-connector designed to sip power from two USB ports.
In short, this could be a very good way to screw up your computer's USB controller. Don't try it.