If you found that interesting, UCSB has a huge free database that covers California and a few areas outside of CA, mostly on the west coast: https://mil.library.ucsb.edu/ap_indexes/FrameFinder/