United Aviate Academy
Registered aircraft · 67
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 = 'UNITED AVIATE ACADEMY' OR list_contains(g.other_registrant_names, 'UNITED AVIATE ACADEMY') 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 = 'UNITED AVIATE ACADEMY' OR list_contains(g.other_registrant_names, 'UNITED AVIATE ACADEMY') 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.
N233AVDiamond Aircraft Ind DA 42 NG · S/N 42.N498N320AVDiamond Aircraft Ind DA 42 NG · S/N 42.N502N386AVPiper PA-44-180 · S/N 4496614N402AVCirrus Design SR20 · S/N 8673N403AVCirrus Design SR20 · S/N 8741N405AVCirrus Design SR20 · S/N 8756N407AVCirrus Design SR20 · S/N 8771N408AVCirrus Design SR20 · S/N 8778N409AVCirrus Design SR20 · S/N 8794N410AVCirrus Design SR20 · S/N 8808N413AVCirrus Design SR20 · S/N 8815N425AVCirrus Design SR20 · S/N 8877N447AVCirrus Design SR20 · S/N 8882N448AVCirrus Design SR20 · S/N 8902N450AVCirrus Design SR20 · S/N 8951N453AVCirrus Design SR20 · S/N 8952N455AVCirrus Design SR20 · S/N 8954N466AVCirrus Design SR20 · S/N 8959N468AVCirrus Design SR20 · S/N 9083N469AVCirrus Design SR20 · S/N 9084N470AVCirrus Design SR20 · S/N 9085N471AVCirrus Design SR20 · S/N 9086N473AVCirrus Design SR20 · S/N 9095N474AVCirrus Design SR20 · S/N 9100N475AVCirrus Design SR20 · S/N 9118N476AVCirrus Design SR20 · S/N 9128N478AVCirrus Design SR20 · S/N 9175N479AVCirrus Design SR20 · S/N 9180N483AVCirrus Design SR20 · S/N 9325N485AVCirrus Design SR20 · S/N 9311N486AVCirrus Design SR20 · S/N 9315N488AVCirrus Design SR20 · S/N 9305N489AVCirrus Design SR20 · S/N 9329N491AVCirrus Design SR20 · S/N 9333N492AVCirrus Design SR20 · S/N 9361N493AVCirrus Design SR20 · S/N 9367N494AVCirrus Design SR20 · S/N 9375N502AVCirrus Design SR20 · S/N 9459N507AVCirrus Design SR20 · S/N 9519N512AVCirrus Design SR20 · S/N 9521N513AVCirrus Design SR20 · S/N 9523N515AVCirrus Design SR20 · S/N 9560N517AVCirrus Design SR20 · S/N 9564N518AVCirrus Design SR20 · S/N 9568N520AVCirrus Design SR20 · S/N 9574N526AVCirrus Design SR20 · S/N 9578N527AVCirrus Design SR20 · S/N 9582N528AVCirrus Design SR20 · S/N 9586N619AVCirrus Design SR20 · S/N 10884N624AVCirrus Design SR20 · S/N 10887
Back to United Aviate Academy