USS Aries NCC-45167
Commander Riker was offered command of the USS Aries in 2365. Part of the fleet to
rendezvous with the USS Enterprise
NCC-1701-E to intercept the Reman warship Scimitar.Named for the constellation of the same name, as well as the moon landing shuttle from
2001: A Space Odyssey.
"The Icarus Factor" - TNG. "Identity Crisis" - TNG. "Star Trek: Nemesis"

USS Hokkaido NCC-
Last vessel of this class to be constructed in 2337.The Next Generation Technical Manual.

USS Hornet NCC-45231
Served in Captain Picard's tachyon armada during the Klingon Civil War in 2368.Named for the American aircraft carrier that fought at the Battle of Midway in World War II.
"Redemption" - TNG.

USS Maryland NCC-45109
Lost some time prior to 2371 and was believed to be destroyed by the Dominion.Named for the several naval vessels that served the United States in the 20th century.
"In Purgatory's Shadow" - DS9.