Registered aircraft · 29

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 = 'OKLAHOMA STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'OKLAHOMA STATE UNIVERSITY') 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 = 'OKLAHOMA STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'OKLAHOMA 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 = 'OKLAHOMA STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'OKLAHOMA 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.

N100MNAggieair Usu MINION · S/N AA100MNStillwater, OK N120SUTextron 172S · S/N 172S11674Built 2016 · Stillwater, OK N20KEMugin MUGIN 6 PRO · S/N M6000-OSU-01Stillwater, OK N250SUTextron 172S · S/N 172S11675Built 2016 · Stillwater, OK N300SUCirrus Design SR20 · S/N 2520Built 2019 · Stillwater, OK N310SUCirrus Design SR20 · S/N 2521Built 2019 · Stillwater, OK N320SUCirrus Design SR20 · S/N 2522Built 2019 · Stillwater, OK N330SUCirrus Design SR20 · S/N 2523Built 2019 · Stillwater, OK N360SUCirrus Design SR20 · S/N 2525Built 2019 · Stillwater, OK N370SUCirrus Design SR20 · S/N 2615Built 2020 · Stillwater, OK N4655PCessna 152 · S/N 15284794Stillwater, OK N48481Cessna 152 · S/N 15283342Built 1979 · Stillwater, OK N538UAOklahoma State University TURBO ELECTRIC MUGIN · S/N OSU-TE-001Stillwater, OK N5420PCessna 152 · S/N 15284942Built 1981 · Stillwater, OK N600SUCessna 150K · S/N 15071691Built 1969 · Stillwater, OK · Co-owner with Flying Aggies N69205Cessna 152 · S/N 15282553Built 1978 · Stillwater, OK N720SUPiper PA-44-180 · S/N 4496413Built 2017 · Stillwater, OK N739JRCessna 172N · S/N 17270584Built 1978 · Stillwater, OK N800SUPiper PA-44-180 · S/N 4496412Built 2017 · Stillwater, OK N80439Cessna 172M · S/N 17266586Built 1976 · Stillwater, OK N91936Cessna 172R · S/N 17281614Built 2012 · Stillwater, OK N9196WCessna 172R · S/N 17281615Built 2012 · Stillwater, OK N9198WCessna 172R · S/N 17281617Built 2012 · Stillwater, OK N91996Cessna 172R · S/N 17281619Built 2012 · Stillwater, OK N9199ZCessna 172R · S/N 17281618Built 2012 · Stillwater, OK N92004Cessna 172R · S/N 17281621Built 2012 · Stillwater, OK N9202UCessna 172R · S/N 17281622Built 2012 · Stillwater, OK N94532Cessna 152 · S/N 15285707Built 1983 · Stillwater, OK N94592Cessna 182Q · S/N 18266452Built 1978 · Stillwater, OK

Back to Oklahoma State University