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.

A table of airports, showing the city, IATA code, and number of visits for each.

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 my 100th airside visit to the Dayton airport, allowing me to celebrate accordingly.

Paul, in the lobby of the Dayton airport, wearing a party hat labeled with the number 100.

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

A map and table of Paul's flights through Chicago O'Hare.

Flight map generated using the Great Circle Mapper—copyright © Karl L. Swartz

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:

A map and table of Paul's trip sections with a flight through Chicago O'Hare.

Flight map generated using the Great Circle Mapper—copyright © Karl L. Swartz

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

Tables of all airlines and aircraft Paul has flown through Chicago O'Hare. Each table shows the number of O'Hare flights for each airline or aircraft family, and the tables are each sorted by number of flights.

Note: I later discovered that the flight shown here as Continental was actually on American Airlines. This has been corrected in the Flight Log.

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