There is no database containing information on all the dams in the United States. The single largest source is the
National Inventory of Dams (NID) from the US Army Corps of Engineers which claims to have more than 80,000 dams. I downloaded the entire data from NID and also cleaned it up.
I am in the process of creating an R package for this dataset and will shortly have a post on it.
Here are some graphics.