Skip to content

Registered aircraft · 84

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 = 'MED-TRANS CORP' OR list_contains(g.other_registrant_names, 'MED-TRANS CORP') 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 = 'MED-TRANS CORP' OR list_contains(g.other_registrant_names, 'MED-TRANS CORP')
  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 = 'MED-TRANS CORP' OR list_contains(g.other_registrant_names, 'MED-TRANS CORP')
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.

N105NKAirbus Helicopters MBB-BK 117 C-2 · S/N 9860Built 2020 · Denton, TX N113MTEurocopter Deutschland EC 135 P2+ · S/N 1103Built 2013 · Denton, TX N119MTAirbus Helicopters Deutschland EC135 P3 · S/N 1197Built 2015 · Denton, TX N135LXEurocopter Deutschland EC 135 P2+ · S/N 1004Built 2011 · Denton, TX N135UTEurocopter Deutschland EC 135 P2+ · S/N 0776Built 2009 · Denton, TX N135WLEurocopter Deutschland EC 135 P2+ · S/N 1083Built 2012 · Denton, TX N136UTEurocopter Deutschland EC 135 P2+ · S/N 0841Built 2009 · Denton, TX N144CHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9574Built 2012 · Denton, TX N159MTAirbus Helicopters Deutschland EC135 P2+ · S/N 1199Built 2015 · Denton, TX N165GRAirbus Helicopters EC 130 T2 · S/N 9925Built 2026 · Denton, TX N166MTAirbus Helicopters Deutschland EC135 P2+ · S/N 1167Denton, TX N223MTAirbus Helicopters AS350B3 · S/N 8659Built 2019 · Denton, TX N223WLAirbus Helicopters EC135 P3 · S/N 2286Built 2024 · Denton, TX N224MTAirbus Helicopters AS350B3 · S/N 9221Built 2022 · Denton, TX N229MTAirbus Helicopters AS350B3 · S/N 9203Built 2022 · Denton, TX N241MTBell Helicopter Textron Canada 407 · S/N 54056Built 2011 · Denton, TX N253MTAirbus Helicopters Deutschland EC135 P2+ · S/N 1153Built 2014 · Denton, TX N254GRAirbus Helicopters EC 130 T2 · S/N 9742Built 2025 · Denton, TX N306LGAgustawestland Philadelphia AW119MKII · S/N 14839Built 2015 · Denton, TX N405EHEurocopter Deutschland EC 135 P2+ · S/N 0739Built 2008 · Denton, TX N406EHEurocopter Deutschland EC 135 P2+ · S/N 0726Built 2008 · Denton, TX N407ARBell Helicopter Textron Canada 407 · S/N 54092Built 2012 · Denton, TX N407CRBell 407 · S/N 53254Built 1998 · Denton, TX N407SMBell 407 · S/N 53289Built 1998 · Denton, TX N407WABell 407 · S/N 53222Built 1997 · Denton, TX N408UTBell Helicopter Textron Canada 407 · S/N 53808Built 2007 · Denton, TX N411UTAirbus Helicopters EC135 P3 · S/N 2318Denton, TX N424MTBell Helicopter Textron Canada 407 · S/N 54124Built 2012 · Denton, TX N429MTBell Helicopter Textron Canada 407 · S/N 54129Built 2013 · Denton, TX N450MTEurocopter Deutschland EC 135 P2+ · S/N 0950Built 2010 · Denton, TX N452MTEurocopter Deutschland EC 135 P2+ · S/N 0974Built 2011 · Denton, TX N456MTEurocopter Deutschland EC 135 P2+ · S/N 0854Built 2009 · Denton, TX N459MTEurocopter Deutschland EC 135 P2+ · S/N 0928Built 2010 · Denton, TX N470YBBell Helicopter Textron Canada 407 · S/N 54110Built 2012 · Denton, TX N505MTBell 407 · S/N 53307Built 1998 · Denton, TX N508MTBell 407 · S/N 53326Built 1998 · Denton, TX N511MTBell 407 · S/N 53563Built 2003 · Denton, TX N513MTBell Helicopter Textron Canada 407 · S/N 54741Built 2018 · Denton, TX N515MTBell 407 · S/N 53604Built 2004 · Denton, TX N516MTBell Helicopter Textron Canada 407 · S/N 53762Built 2007 · Denton, TX N517MTEurocopter Deutschland EC 135 P2+ · S/N 0666Denton, TX N519MTBell Helicopter Textron Canada 407 · S/N 53956Built 2009 · Denton, TX N520MTBell Helicopter Textron Canada 407 · S/N 53805Built 2007 · Denton, TX N521RCBell Helicopter Textron Canada 407 · S/N 54496Built 2014 · Denton, TX N523MTEurocopter Deutschland EC 135 P2+ · S/N 0821Built 2009 · Denton, TX N527MTBell Helicopter Textron Canada 407 · S/N 54828Built 2018 · Denton, TX N535MTAirbus Helicopters Deutschland EC135 P3 · S/N 2092Built 2019 · Lewisville, TX N559MTBell Textron Canada 407 · S/N 54999Denton, TX N601MTEurocopter Deutschland EC 135 P2+ · S/N 1040Built 2012 · Denton, TX N602MTEurocopter Deutschland EC 135 P2+ · S/N 1063Built 2012 · Denton, TX

Back to Med-Trans Corp