A Cheyenne-class Federation starship with four warp nacelles, wrecked in the battle against the Borg at Wolf 359 and later listed among the ships of Picard's blockade fleet.
The USS Ahwahnee was a Cheyenne-class starship, a compact design carrying four warp nacelles. It formed part of the fleet that faced the Borg cube at Wolf 359 in 2367, and its wreck is among the hulks the Enterprise-D passes in The Best of Both Worlds, Part II.
The ship evidently survived or was salvaged, because its name appears a year later on the tactical display of the fleet Captain Picard gathers to blockade the Klingon-Romulan border in Redemption II.
The name comes from the historic hotel in Yosemite National Park. The registry NCC-71620 comes from the studio model and display graphics rather than from dialogue.