Embedded Dataset Excel:

Dataset Excel:

Notes:

Airports included in metropolitan areas:

Greater Boston: Boston, Manchester, Providence

Greater Chicago: Midway, O'Hare

Greater Dallas-Fort Worth: Dallas-Fort Worth, Love

Greater Houston: Hobby, Bush Intercontinental

Greater Los Angeles: Burbank/Glendale/Pasadena, Long Beach, Los Angeles Int'l, Ontario, Santa Ana (Orange County)

Greater New York: Islip (Long Island), La Guardia, JFK, Newark, Newburgh, White Plains

Greater San Francisco: Oakland, San Francisco, San Jose

Greater Washington DC: Baltimore, Reagan National, Dulles

Source:

Bureau of Transportation Statistics, https://www.bts.gov/explore-topics-and-geography/topics/air-fares

*Not including Alaska, Hawaii or Puerto Rico