This is my version of the Norway-class frigate. It was only seen in Star Trek First Contact, in the battle scene. It was only a CGI model, and not a real one. It was never seen again because the mesh for it was irretrievably lost in the ILM computers. It is an interesting design for a Federation ship, and has more of a combat emphasis to its design, rather than an exploration one. The trans-red brick in the nose of the craft is not its deflector dish, but the ships main forward phaser cannon.
I know the colour scheme looks a little like a Star Wars Rebel fighter, the Norway-class is pssibly the only 24th century vessel which doesn't have any blue on the engines. It also has a large amount of red stripes, as Starfleet pennants, and it really has tan plating on the nose, so the colours are more or less accurate.
The Norway class ship was only seen in the background, very blurry. Same for the Steamrunner class, and the Saber class is only seen for about 5 seconds in the upper left corner. The Akira class is seen about 3 times, always behind something (except when the cube explodes).
I think I've seen Star Trek: First Contact too many times.