The fictional submarine here is USS San Pedro (USS-780). No such ship exists in the real world of the US Navy. The real USS San Pedro (PF-37) was a patrol frigate of the Tacoma class, which served 1943-45; she also served in the Soviet Navy (1945-49) and the Japanese Maritime Self-defense Force (1953-78). The real SSN-780 is USS Missouri, a nuclear attack submarine of the Virginia class, which has served since 2010.
This is the first appearance of Nanci Chambers, playing Lt. Loren Singer, who is the wife of David James Elliott in real life.
The ship that the rogue submarine uses as cover when going in to the harbour is the "Denali". This is the same ship used by the crew in the 1996 film "Down Periscope" to the same effect.