The Historic Naval Ships website, which appears to have a fairly comprehensive listing of historic ships that are open for public tours has a section for Coast Guard ships.

Is this actually complete?

A post over on the discussions board (white on top thread) mentions a CG buoy tender in Duluth, MN which isn't listed on this site.

Are there other decommissioned CG vessels on display out there that should be on this list?

It looks like all the ones listed on that site are affiliated with that particular historical society. Loved the Artic Survey Boat:been underway on one.
The Lightship Columbia is open for tours at the Columbia River Maritime Museum in Astoria, OR. The 44300 is there also. It came over from the Lifeboat School at Cape D. It isn't open for tours as it is displayed at a slight angle.

MKC Jeffrey T. Wood

You are probably right about it being just for members of the association. My follow-up question would then be is there any other comprehensive listing of preserved naval ships out their on the internet?

Suison Bay used to have many preserved ships. But I'm going back a few years

Not complete. Plenty of other historical vessels out there.

Of note, it lists the USCGC EAGLE as one of only 5 sailing training vessels in the world - nope. I know of at least one other. The ESMERALDA, a four masted barquentine of the Chilean Navy which trains the Chilean (and other S.American cadets) Naval cadets. ESMERALDA is the second tallest and is the longest sailing vessel in the world. Known as 'La Blanca Dama' (the white lady), she is both the most beloved by Chileans and hated by 1973 coup detractors. There are probably other omissions.

A WHOLE lot different from when I put her out of commission over 20 years ago. What a transformation and unique saving of a historical vessel from the scrap heap.

www.nantucketlightship.com/

It's probably best to do a broad search for "USCG Museum Ships", "Coast Guard Museum Ships", or something similar. Wikipedia had a pretty good listing of most museum ships when I searchhed for "USCG Museum Ships"; but only listed the following 12 vessels:
Ambrose Lightship, NYC
Cutter Alert (125') Seattle
Bramble, Port Huron
USCGC Ingham, Charleston
LV101 Lightship Portsmouth
LV116 Lightship Chesapeake
USCGC Mackinaw, Mackinaw City
USCGC McLane, Muskegon
Nantucket LV112, NYC
USS Potomoc (ex-CGC Electra) Oakland
USCGC Sundew, Duluth
USCGC Taney, Baltimore

The Wikipedia listing for lightships had:
Relief WLV 605, Oakland
Overfalls, Delaware
Chesapeaake, Maryland
Nantucket, Massachusetts
Huron, Michigan
Ambrose, New York
Frying Pan, New York
Columbia WLV 604, Oregon (my 1st duty station)
Portsmouth LV101, Virginia
Swiftsure LS 83, Seattle

There are quite a few 36' MLBs, 30'& 40' UTBs, and 44' MLBs on display at various locations. There used to be a Patrol Boat group in California that had an old 82' WPB, and IIRC an 83' PB.

USCG EAGLE was a prize of war. When Germany surendered the Americans took her back to the US it is now a training ship for the CG

The Acacia is in Chicago? My husband was on that ship. Is she on display or taking tours of the ship?