Registered aircraft · 23

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 = 'EASTERN KENTUCKY UNIVERSITY' OR list_contains(g.other_registrant_names, 'EASTERN KENTUCKY 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 = 'EASTERN KENTUCKY UNIVERSITY' OR list_contains(g.other_registrant_names, 'EASTERN KENTUCKY 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 = 'EASTERN KENTUCKY UNIVERSITY' OR list_contains(g.other_registrant_names, 'EASTERN KENTUCKY 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.

N112PFCessna 172R · S/N 17280400Built 1998 · Richmond, KY N258BWCessna 172P · S/N 17274811Built 1981 · Richmond, KY N302CFCessna 172R · S/N 17281137Built 2002 · Richmond, KY N3125GPiper PA-44-180 · S/N 4496214Richmond, KY N3547FCessna 172S · S/N 172S8887Richmond, KY N41912Cessna 172R · S/N 17280628Built 1998 · Richmond, KY N504MACessna 172P · S/N 17275917Built 1983 · Richmond, KY N5173VCessna 172S · S/N 172S9046Built 2002 · Richmond, KY N52208Cessna 172S · S/N 172S9208Built 2002 · Richmond, KY N5439KCessna 172P · S/N 17274110Built 1980 · Richmond, KY N565RBPiper PA-44-180 · S/N 4496307Built 2012 · Richmond, KY N63569Cessna 172P · S/N 17275452Built 1981 · Richmond, KY N70095Cessna 172M · S/N 17267192Built 1976 · Richmond, KY N741WBCessna 172S · S/N 172S11571Built 2015 · Richmond, KY N746DWCessna 172S · S/N 172S11569Built 2015 · Richmond, KY N7720YPiper PA-44-180 · S/N 4496132Built 2002 · Richmond, KY N91FSCessna 172R · S/N 17280302Built 1997 · Richmond, KY N92FSCessna 172R · S/N 17280308Built 1998 · Richmond, KY N92LCCessna 172R · S/N 17280153Built 1997 · Richmond, KY N934LEDJI AGRAS T20 · S/N 36RBHAM00100G0Richmond, KY N9516JCessna 172R · S/N 17280396Built 1998 · Richmond, KY N981WUCessna 172R · S/N 17280555Built 1998 · Richmond, KY N999WBCessna 172N · S/N 17273254Built 1979 · Richmond, KY

Back to Eastern Kentucky University