Kinboat
Conan the Librarian
This should make a pretty good upgrade to the Helicopter, for futuristic mods at least. I would design it almost exactly like the Helicopter, changing the defense and range if possible... There are attack animations included so you could also give it an attack.
http://www.civfanatics.net/uploads/Dropship.zip
And a preview...
http://www.civfanatics.net/uploads/Dropship.zip
And a preview...