I saw one night launch from the air before 9/11. Back then you could get as close as 15 miles, basically stay to the west of the inter-coastal. It was an amazing experience, I rented a C-172 with 3 other pilots and took off from Daytona, headed south and timed it so we would turn around right as it launched. THe scary part back then was the other 50 planes in the area trying to watch the launch.
The other cool thing you could do was called a shuttle tour, basically they let you overfly the runway at 500 feet and gave you other vectors when the shuttles were not at the pad.
After 9/11 you couldn't even go south of the Daytona Beach airport, not sure what has happened since 2004, but that was as close as you could get, still since it launched to the north east you could get a great view and the controllers were aweasome at giving you vectors to see the launch. Those pictures on airliners looks like before 9/11, it was def neat to see it take off from below you and watch it go by.