ASOS Excel Data Base
This is an FAA database complete ASOS listing, and can be sorted by station ID, or city / state . This spreadsheet was created in in Excel. Other applications may not be able to open it. Right Click on the dowload link, and "save target" to disk.