The Blue Angels ("F/A 18 Hornets") are the main attraction and maneuver with eye-popping precision at ear-popping speeds!
You really can't miss this one, even if you want to - the aircraft practice during the preceding week. For the best views, move to the tops of things (hills, buildings, etc) with a bias towards the north side of the city.
Website: http://www.military.com/fleetweek
Wikipedia: http://en.wikipedia.org/wiki/Fleet_Week