Gate 13

Tags MapsQGIS
Map of airports with or without a Gate 13
Image Credit: Created by Paul Bogard using Mapbox map tiles (© Mapbox © OpenStreetMap)

I’ve started to notice as I travel that a number of airports within the U.S. don’t have a gate 13, and instead skip straight from gate 12 to gate 14. Given that 13 is considered an unlucky enough number that many buildings skip the thirteenth floor, I’m not surprised that people may not want to board a flight through gate 13.

Curious about if there were any geographic trends as to where the airports that skipped gate 13 were, I decided to make a map of which U.S. airports did and did not have a 13th gate.

I started with the 2018 FAA Passenger Boarding Data to get a spreadsheet of all U.S. commercial service primary airports (airports with at least 10 000 annual passenger boardings). Since I already use the FlightXML API for Flight Historian, I was able to write a Ruby script to loop through the airport codes from the FAA spreadsheet, look up the FlightXML latitude and longitude for each airport, and save it all as a CSV file. I also included the hub type (large, medium, small, or nonhub) from the FAA data, as well as a column for Gate 13 status.

For each airport in the CSV file, I used terminal maps and aerial imagery to determine what gate numbers were present, and entered one of the following into my Gate 13 column:

Yes The airport has at least one gate numbered 13
No The airport has no gates numbered 13
Range The range of gates at the airport doesn’t include 13 (usually because the airport has less than 13 gates per concourse, but some airports started their gate numbers higher than 13 as well)

Once I had the CSV data file completed, I imported it into QGIS to plot all the airports as points. Point size was determined by whether it was a large, medium, small, or nonhub airport; point color was determined by whether or not the airport had a gate 13.

Tools and Data Sources

GIS Software
Map Tiles
Airport List and Hub Types
Airport Latitudes and Longitudes

Gate 13 Data File

License

Paul Bogard created this map, and has made it available for use under a CC BY-SA 4.0 License.