This brings to mind
a thread I did:
The 37 U.S. metros (CSA or single MSAs) over 2 million ranked by per-capita commercial air boardings in 2019 (to avoid covid):
City........Enplanements........PSA........Ratio
Las Vegas........24,890,213........2,317,052........10.742
Denver........33,592,945........3,623,560........9.271
Charlotte........24,379,675........2,822,352........8.638
Atlanta........53,505,795........6,930,423........7.720
Miami........43,345,189........6,868,652........6.311
Orlando........26,504,700........4,222,422........6.277
Dallas........43,859,079........8,121,108........5.401
Seattle........25,422,108........4,953,421........5.132
Chicago........50,953,004........9,986,960........5.102
Salt Lake City........12,967,284........2,701,129........4.801
Phoenix........23,315,407........4,899,104........4.759
Minneapolis........19,214,684........4,078,788........4.711
SF Bay Area........42,380,512........9,714,023........4.363
Nashville........8,935,654........2,118,233........4.218
Houston........28,974,923........7,312,270........3.963
San Diego........12,648,692........3,298,634........3.835
Tampa Bay........12,122,239........3,175,275........3.818
Austin........8,507,410........2,283,371........3.726
DC-Baltimore......36,793,363........9,973,383........3.689
Detroit........18,445,646........5,424,742........3.400
Raleigh........6,919,429........2,106,463........3.285
New York........72,016,532........23,582,649........3.054
Los Angeles........56,868,962........18,644,680........3.050
Portland, OR........9,797,408........3,280,736........2.986
Boston...........23,810,043........8,466,186........2.812
St. Louis........7,927,512........2,924,904........2.710
Sacramento........6,454,413........2,680,831........2.408
Kansas City........5,759,419........2,528,644........2.278
Philadelphia........16,536,162........7,379,700........2.241
San Juan........4,630,554........2,358,201........1.964
San Antonio........5,022,980........2,576,528........1.950
Cincinnati........4,413,457........2,316,022........1.906
Indianapolis........4,709,183........2,492,514........1.889
Pittsburgh........4,874,200........2,657,149........1.834
Columbus........4,325,917........2,544,048........1.700
Milwaukee........3,374,073........2,053,232........1.643
Cleveland........5,302,187........3,633,962........1.459
Isolated/tourist magnets on top, the Midwest "fallen hubs" at the bottom.
Smaller metros that stay above a ratio of 3.
City........Enplanements........PSA........Ratio
Honolulu........9,988,678........1,016,508........9.826
Anchorage........2,758,507........398,328........6.925
New Orleans........6,874,111........1,506,610........4.563
Fort Myers........5,044,024........1,176,193........4.288
Reno........2,162,250........657,958........3.286