Und Aerospace Foundation
Registered aircraft · 101
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 = 'UND AEROSPACE FOUNDATION' OR list_contains(g.other_registrant_names, 'UND AEROSPACE FOUNDATION') 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 = 'UND AEROSPACE FOUNDATION' OR list_contains(g.other_registrant_names, 'UND AEROSPACE FOUNDATION') 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.
N137NDPiper PA-28-181 · S/N 28010008N1728QCessna 150K · S/N 15071920N179NDPiper PA-28-181 · S/N 28010009N18NDCub Crafters CC18-180 · S/N CC18-0004N1923RAmerican Champion 8KCAB · S/N 1217-2024N1997RAmerican Champion 8KCAB · S/N 1232-2026N210NDUav Factory USA PENGUIN C · S/N PNC 0052N211NDUav Factory USA PENGUIN C · S/N PNC 0053N212NDUav Factory USA PENGUIN C · S/N PNC 0054N23NDHawker Beechcraft C90GTI · S/N LJ-1944N26NDHawker Beechcraft C90GTI · S/N LJ-1956N317JRAmerican Champion 8KCAB · S/N 1105-2011N321NDPiper PA-28-181 · S/N 2881748N330PEHawker Beechcraft C90GTI · S/N LJ-1917N333NDPiper PA-28-181 · S/N 2881782N334NDPiper PA-28-181 · S/N 2881793N339NDPiper PA-28-181 · S/N 28010012N341NDPiper PA-28-181 · S/N 2881794N343NDPiper PA-28-181 · S/N 2881890N349NDPiper PA-28-181 · S/N 2881902N362NDPiper PA-28-181 · S/N 2881656N379NDPiper PA-28-181 · S/N 2881659N381NDPiper PA-28-181 · S/N 2881666N386NDPiper PA-28-181 · S/N 2881678N388NDPiper PA-28-181 · S/N 2881679N445NDPiper PA-28-181 · S/N 2881891N460NDPiper PA-28-181 · S/N 2881655N484NDPiper PA-28-181 · S/N 2881667N502NDPiper PA-28-181 · S/N 2881475N50405Cessna 150H · S/N 15069279N504NDPiper PA-28-181 · S/N 2881476N50989Cessna 150M · S/N 15077226N544NDPiper PA-28-181 · S/N 28010013N591NDPiper PA-44-180 · S/N 4496633N592NDPiper PA-44-180 · S/N 4496634N607NDPiper PA-28-181 · S/N 2881185N609NDPiper PA-28-181 · S/N 2881285N621NDPiper PA-28-181 · S/N 2881159N622NDPiper PA-28-181 · S/N 2881160N625NDPiper PA-28-181 · S/N 2881161N641NDTextron 172S · S/N 172S11615N646NDPiper PA-28-181 · S/N 2881143N659NDPiper PA-28-181 · S/N 2881286N661NDPiper PA-28-181 · S/N 2881287N662NDPiper PA-28-181 · S/N 2881149N663NDPiper PA-28-181 · S/N 2881288N678NDTextron 172S · S/N 172S11619N679NDPiper PA-28-181 · S/N 2881150N684NDPiper PA-28-181 · S/N 2881151N685NDPiper PA-28-181 · S/N 2881305
Back to Und Aerospace Foundation