Earlier this week, the USS Constitution was launched after two years of restoration work. Old Ironsides, as she is also known, was towed out of dry dock and returned to the waters of Boston Harbor. It's a long video so we would suggest starting to watch at about 15 minutes in.
This brief video shows the work that was done on her while in drydock.
And this short documentary shows why this ship is such a big deal.