Found some cool aerial shots of San Francisco and Los Angeles, please feel free to add other cities.....
San Francisco
flickr user: ATIS547 (obviously a pilot, first six photos)
You can almost see Sacramento
You can see all of the new construction, the photos are very recent.
Los Angeles
Great downtown shot
flickr user: Marshall Astor
Actually from the Getty, not aerial, but is elevated to show perspective. Shows Century City and DT in the distance.
flickr user: Maijau
Marina Del Rey inlet, can see Wilshire, Westwood, and Century City in distance
flickr user: ATIS547
Westwood, UCLA and Wilshire corridor West LA
flickr user: ATIS547
flickr user: ATIS547