One Hundred Airports

While flights are the most visible aspect of the Flight Log, airports are equally important.

On my airports listing, I start out with some maps showing all airports I’ve been to, but the heart of the page is the list of airports.

This lists each airport I’ve been to, and the number of times I’ve visited it. The number of visits is automatically determined from the flight data in the database; every flight has an airport visit at either end of it.

My code also has to look at trip sections to determine if a flight arriving at an airport and the next flight departing from the same airport is a layover or not. If both flights are in separate sections (for example, I land in Dallas/Fort Worth, do some business there, and then depart from DFW later) it is not a layover and counts as two visits. However, if they’re in the same section, it’s a layover, and only counts as a single visit.

This visit calculation is how I determined when my 100th airside visit to the Dayton airport, allowing me to celebrate accordingly.

Clicking on any airport brings up its details, starting with a list of all flights involving the airport:

As always, the flight log’s code generates a list of flights and passes it on to the Great Circle Mapper to draw the maps.

The page also figures out which trip sections and trips involve the airport in question, and generates maps for those, too:

Finally, the page shows a listing of the frequency of all the airlines and aircraft families I’ve used at this airport:

Clicking on any airline or aircraft family will bring up details about each, which will be discussed in the next entry.