Middle Tennessee State University
Registered aircraft · 64
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
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 = 'MIDDLE TENNESSEE STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'MIDDLE TENNESSEE STATE UNIVERSITY') 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 = 'MIDDLE TENNESSEE STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'MIDDLE TENNESSEE STATE UNIVERSITY') 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.
N110MTCirrus Design SR22T · S/N 10677N1244TDiamond Aircraft Ind DA 40 · S/N 40.1191N124MTPiper PA-28R-201 · S/N 2844092N128MTPiper PA-44-180 · S/N 4496171N129MTPiper PA-44-180 · S/N 4496172N130MTPiper PA-44-180 · S/N 4496477N132MTPiper PA-44-180 · S/N 4496540N134MTPiper PA-44-180 · S/N 4496593N135MTPiper PA-44-180 · S/N 4496594N139MTPiper PA-44-180 · S/N 4496541N147MTPiper PA-18-150 · S/N 18-7409136N215TPBeech 400 · S/N RJ-64N247CDDiamond Aircraft Ind DA 40 · S/N 40.1193N283MT3D Robotics SX-X8 · S/N MT3DRX8001N288MTDJI INSPIRE 2 · S/N MTDJIX4011N292MTDJI PHANTOM 2 · S/N MTDJIX4001N295MTDJI S1000+ · S/N MTDJIX8002N299MTBirdseyeview Aerobotics FIREFLY 6 PRO · S/N MTBEVAV6002N3278YPiper PA-23-250 · S/N 27-3714N349DSDiamond Aircraft Ind DA 40 · S/N 40.1081N4601RCessna 172RG · S/N 172RG0003N51578Maule M-5-210C · S/N 6020CN52749Cessna 172P · S/N 17274599N563MTDiamond Aircraft Ind DA 40 · S/N 40.1257N564MTDiamond Aircraft Ind DA 40 · S/N 40.300N565MTDiamond Aircraft Ind DA 40 · S/N 40.301N566MTDiamond Aircraft Ind DA 40 · S/N 40.304N567MTDiamond Aircraft Ind DA 40 · S/N 40.308N568MTDiamond Aircraft Ind DA 40 · S/N 40.312N569MTDiamond Aircraft Ind DA 40 · S/N 40.314N570MTDiamond Aircraft Ind DA 40 · S/N 40.363N571MTDiamond Aircraft Ind DA 40 · S/N 40.396N572MTDiamond Aircraft Ind DA 40 · S/N 40.577N573MTDiamond Aircraft Ind DA20-C1 · S/N C0219N581MTDiamond Aircraft Ind DA 40 · S/N 40.397N582MTDiamond Aircraft Ind DA 40 · S/N 40.398N583MTDiamond Aircraft Ind DA 40 · S/N 40.399N585MTDiamond Aircraft Ind DA 40 · S/N 40.958N586MTDiamond Aircraft Ind DA 40 · S/N 40.962N587MTDiamond Aircraft Ind DA 40 · S/N 40.971N588MTDiamond Aircraft Ind DA 40 · S/N 40.974N589MTDiamond Aircraft Ind DA 40 · S/N 40.978N590MTDiamond Aircraft Ind DA 40 · S/N 40.980N592MTDiamond Aircraft Ind DA 40 · S/N 40.981N593MTDiamond Aircraft Ind DA 40 · S/N 40.1258N594MTDiamond Aircraft Ind DA 40 · S/N 40.1211N595MTDiamond Aircraft Ind DA 40 · S/N 40.1212N596MTDiamond Aircraft Ind DA 40 · S/N 40.1213N597MTDiamond Aircraft Ind DA 40 · S/N 40.1215N598MTDiamond Aircraft Ind DA 40 · S/N 40.1226
Back to Middle Tennessee State University