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.

Screenshot of a table listing all airports I've visited

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.

Paul at the Dayton airport wearing a party hat with "100" written on it.

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

Screen Shot 2013-06-16 at 12.25.52

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:

Screen Shot 2013-06-16 at 12.33.19

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

Screenshot of airlines and aircraft listing

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

2 thoughts on “Airports

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s