Skip to content

Metro Aviation Inc

Registered aircraft · 69

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'METRO AVIATION INC' OR list_contains(g.other_registrant_names, 'METRO AVIATION INC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'METRO AVIATION INC' OR list_contains(g.other_registrant_names, 'METRO AVIATION INC')
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'METRO AVIATION INC' OR list_contains(g.other_registrant_names, 'METRO AVIATION INC')
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N117CHMesserschmitt BK 117 B-1 · S/N 7123Built 1987 · Shreveport, LA N117UPEurocopter Deutschland MBB-BK 117 C-1 · S/N 7508Built 1994 · Shreveport, LA N135BUEurocopter Deutschland EC135P1 · S/N 0015Built 1997 · Shreveport, LA N135DHEurocopter Deutschland EC135P1 · S/N 0133Built 1999 · Shreveport, LA N135GFEurocopter Deutschland EC 135 P2+ · S/N 0249Built 2002 · Shreveport, LA N137MHEurocopter Deutschland EC135P1 · S/N 0179Built 2002 · Shreveport, LA N139MHEurocopter Deutschland EC135T2 · S/N 0330Built 2004 · Shreveport, LA N143MHEurocopter Deutschland EC 135 P2+ · S/N 0613Built 2007 · Shreveport, LA N145BUAirbus Helicopters MBB-BK 117 C-2 · S/N 9867Built 2021 · Shreveport, LA N145CLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9188Built 2008 · Shreveport, LA N145GFEurocopter Deutschland MBB-BK 117 C-2 · S/N 9209Built 2008 · Shreveport, LA N158BCEurocopter Deutschland EC135P1 · S/N 0134Built 1999 · Shreveport, LA N198LLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9158Built 2008 · Shreveport, LA N198LSEurocopter Deutschland MBB-BK 117 C-1 · S/N 7537Built 2001 · Shreveport, LA N222LNBell Textron Canada 407 · S/N 54808Shreveport, LA N235DHEurocopter Deutschland EC135P1 · S/N 0058Built 1999 · Shreveport, LA N257BCEurocopter Deutschland EC 135 T2+ · S/N 1043Built 2012 · Shreveport, LA N266MHAirbus Helicopters MBB-BK 117 C-2 · S/N 9877Built 2023 · Shreveport, LA N267MHAirbus Helicopters MBB-BK 117 C-2 · S/N 9879Built 2023 · Shreveport, LA N273NEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9586Built 2013 · Shreveport, LA N282CHEurocopter Deutschland EC 135 T2+ · S/N 0735Built 2008 · Shreveport, LA N325MWPilatus PC-12/45 · S/N 325Built 2000 · Shreveport, LA N33JAPilatus PC-12/45 · S/N 261Built 1999 · Shreveport, LA N406BCAirbus Helicopters MBB-BK 117 C-2 · S/N 9863Built 2020 · Shreveport, LA N406GFAirbus Helicopters MBB-BK 117 C-2 · S/N 9880Built 2023 · Shreveport, LA N407MABell Helicopter Textron Canada 407 · S/N 54446Built 2013 · Shreveport, LA N412UHBell Helicopter Textron Canada 407 · S/N 54305Built 2011 · Shreveport, LA N413UHBell Helicopter Textron Canada 407 · S/N 54341Built 2012 · Shreveport, LA N414UHBell Helicopter Textron Canada 407 · S/N 54458Built 2013 · Shreveport, LA N416PBeech F90 · S/N LA-67Built 1980 · Shreveport, LA N445DUAirbus Helicopters MBB-BK 117 C-2 · S/N 9827Built 2019 · Shreveport, LA N448CHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9448Built 2011 · Shreveport, LA N512WFEurocopter Deutschland EC 135 P2+ · S/N 0946Built 2010 · Shreveport, LA N545DUAirbus Helicopters MBB-BK 117 C-2 · S/N 9832Built 2019 · Shreveport, LA N550DSCessna S550 · S/N S550-0154Built 1988 · Shreveport, LA N580SUCessna 172RG · S/N 172RG0877Built 1981 · Shreveport, LA N586WHEurocopter Deutschland EC 135 P2+ · S/N 1096Built 2013 · Shreveport, LA N592ACAirbus Helicopters Deutschland MBB-BK 117 C-2 · S/N 9739Built 2016 · Shreveport, LA N608UWAirbus Helicopters MBB-BK 117 C-2 · S/N 9850Built 2020 · Shreveport, LA N635DHEurocopter Deutschland EC 135 P2+ · S/N 0414Built 2005 · Shreveport, LA N640ECEurocopter Deutschland EC135P1 · S/N 0064Built 1998 · Shreveport, LA N641ECEurocopter Deutschland EC 135 P2+ · S/N 0641Built 2008 · Shreveport, LA N740MHEurocopter Deutschland EC 135 T2+ · S/N 0740Built 2008 · Shreveport, LA N753MGEurocopter Deutschland EC 135 T2+ · S/N 0753Shreveport, LA N770WSEurocopter Deutschland MBB-BK 117 C-2 · S/N 9607Built 2013 · Shreveport, LA N810WFEurocopter Deutschland EC 135 P2+ · S/N 1093Built 2012 · Shreveport, LA N824EHAirbus Helicopters MBB-BK 117 C-2 · S/N 9884Built 2024 · Shreveport, LA N84AKBeech A36 · S/N E-1167Built 1977 · Shreveport, LA N850UWAirbus Helicopters MBB-BK 117 C-2 · S/N 9837Built 2019 · Shreveport, LA N852ALPilatus PC-12/45 · S/N 213Built 1998 · Shreveport, LA

Back to Metro Aviation Inc