Trustees Of Purdue University
Registered aircraft · 25
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 = 'TRUSTEES OF PURDUE UNIVERSITY' OR list_contains(g.other_registrant_names, 'TRUSTEES OF PURDUE 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 = 'TRUSTEES OF PURDUE UNIVERSITY' OR list_contains(g.other_registrant_names, 'TRUSTEES OF PURDUE 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.
N448PUIniziative Industriali Italian SKY ARROW 600 SPORT · S/N LSA010N572PUPiper PA-44-180 · S/N 4496583N573PUPiper PA-44-180 · S/N 4496584N819GPCirrus Design SR22T · S/N 0253N850PUPiper PA-28-181 · S/N 2881323N851PUPiper PA-28-181 · S/N 2881324N852PUPiper PA-28-181 · S/N 2881325N853PUPiper PA-28-181 · S/N 2881326N854PUPiper PA-28-181 · S/N 2881327N855PUPiper PA-28-181 · S/N 2881328N856PUPiper PA-28-181 · S/N 2881329N857PUPiper PA-28-181 · S/N 2881330N858PUPiper PA-28-181 · S/N 2881331N859PUPiper PA-28-181 · S/N 2881332N860PUPiper PA-28-181 · S/N 2881333N861PUPiper PA-28-181 · S/N 2881334N862PUPiper PA-28-181 · S/N 2881335N863PUPiper PA-28-181 · S/N 2881477N864PUPiper PA-28-181 · S/N 2881498N865PUPiper PA-28-181 · S/N 2881490N866PUPiper PA-28-181 · S/N 2881491N867PUPiper PA-28-181 · S/N 2881497N881PUPiper PA-28-181 · S/N 2881965N90PUWindracers ULTRA UAS · S/N MK1-015N95PUAmerican Champion 8KCAB · S/N 1037-2007
Back to Trustees Of Purdue University