Please forgive my "nutshell" account of the Constitutions beginnings, I am certainly NOT a historian but I do find it important to the review to explain WHY this would be a neat thing to see!
On March 27th, 1794 President George Washington approved "an act to provide a naval armament" which is what we now know to be the US Navy. Beginning that year the 6 ships including the USS Constitution were built and in 1797 they were put to sea. The ship got the nickname "Old Iron Sides" in a 1812 battle against the HMS Guerriere where after several shots simply bounced off the Constitution, one British solider claimed "her sides are made of iron!"
The USS Constitution is the oldest commissioned warship in the world and still has a captain, officers and crew. From war ship, to museum ship, to receiving ship over the last 200 hundred years, she can finally sail again under her own power due to an intensive restoration program in 1997 (a 200th birthday gift).
The ship is open to the public, but be aware that you need to pass through a metal detector (no lighters or pocket knives) and stand in a nice long outdoor line, so dress accordingly. I really suggest the guided tours, they are not only informative but the guides are so ready to answer questions and give great personal stories. Take pictures with cannons, get a feel for what "swabbing the deck" might have really been like on a ship that large and who eats "Grog" and what was in it?!?
Currently she is docked at the Boston Navy Yard which officially closed as a working naval station in 1974 and became "Boston National Historic Park". Tours are separated into Summer and Winter schedules, please check the web site for dates/times available. Tours are free, but donations are always welcome.
Also check out the picture I added of the historic war ship with the modern one in the background, pretty incredible evolution "function over form" evolution....