Here's a look at the F-302 Fighter I modeled and textured to be used in Stargate Atlantis season 2 and beyond, as well as the last few seasons of Stargate SG-1. 

Luxology's Modo was used for the geometry and texturing. The animation was done by co-workers of the inhouse VFX crew. 

There are a few still renders in my gallery:
Stargate - Portfolio