Embry-Riddle Aeronautical University Inc
Registered aircraft · 137
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 = 'EMBRY-RIDDLE AERONAUTICAL UNIVERSITY INC' OR list_contains(g.other_registrant_names, 'EMBRY-RIDDLE AERONAUTICAL UNIVERSITY INC') 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 = 'EMBRY-RIDDLE AERONAUTICAL UNIVERSITY INC' OR list_contains(g.other_registrant_names, 'EMBRY-RIDDLE AERONAUTICAL UNIVERSITY INC') 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.
N305ERDiamond Aircraft Ind DA 42 NG · S/N 42.N205N306ERDiamond Aircraft Ind DA 42 NG · S/N 42.N206N308ERDiamond Aircraft Ind DA 42 NG · S/N 42.N210N309ERDiamond Aircraft Ind DA 42 NG · S/N 42.N211N311ERDiamond Aircraft Ind DA 42 NG · S/N 42.N212N312ERDiamond Aircraft Ind DA 42 NG · S/N 42.N213N314ERDiamond Aircraft Ind DA 42 NG · S/N 42.N536N316ERDiamond Aircraft Ind DA 42 NG · S/N 42.N224N318ERDiamond Aircraft Ind DA 42 NG · S/N 42.N539N319ERDiamond Aircraft Ind DA 42 NG · S/N 42.N547N320ERDiamond Aircraft Ind DA 42 NG · S/N 42.N548N323ERDiamond Aircraft Ind DA 42 NG · S/N 42.N550N328ERDiamond Aircraft Ind DA 42 NG · S/N 42.N556N329ERDiamond Aircraft Ind DA 42 NG · S/N 42.N537N350ERTextron 172S · S/N 172S13081N401ERTextron 172S · S/N 172S12535N403ERTextron 172S · S/N 172S12639N413ERTextron 172S · S/N 172S12640N428ERCessna 172S · S/N 172S11451N42ERCessna 150E · S/N 15061252N430ERCessna 172S · S/N 172S11453N433ERCessna 172S · S/N 172S11455N450ERTextron 172S · S/N 172S12955N459ERTextron 172S · S/N 172S12649N460ERTextron 172S · S/N 172S12650N470ERCessna 172S · S/N 172S11599N473ERCessna 172S · S/N 172S11600N479ERCessna 172S · S/N 172S11601N494ERCessna 172S · S/N 172S11602N498ERCessna 172S · S/N 172S11603N499ERCessna 172S · S/N 172S11604N506ERTextron 172S · S/N 172S12857N507ERTextron 172S · S/N 172S12858N509ERTextron 172S · S/N 172S12862N511ERTextron 172S · S/N 172S12863N513ERTextron 172S · S/N 172S13047N522ERTextron 172S · S/N 172S12868N531ERTextron 172S · S/N 172S13069N532ERTextron 172S · S/N 172S13159N535ERTextron 172S · S/N 172S13168N537ERTextron 172S · S/N 172S13305N538ERTextron 172S · S/N 172S13078N540ERTextron 172S · S/N 172S13308N541ERTextron 172S · S/N 172S13311N543ERTextron 172S · S/N 172S13314N544ERTextron 172S · S/N 172S13318N549ERTextron 172S · S/N 172S13547N554ERTextron 172S · S/N 172S12873N565ERTextron 172S · S/N 172S12877N566ERTextron 172S · S/N 172S12878
Back to Embry-Riddle Aeronautical University Inc