Bellanca Aircraft Corp
Earlier aircraft under this name · 50
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'BELLANCA AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'BELLANCA AIRCRAFT CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'BELLANCA AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'BELLANCA AIRCRAFT CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N2991GBellanca 8KCAB · S/N 626-80N2977XBellanca 8KCAB · S/N 633-80N2978KBellanca 8KCAB · S/N 636-80N5069EBellanca 8KCAB · S/N 60580N2979YBellanca 8GCBC · S/N 358-80N2979GBellanca 8GCBC · S/N 356-80N5028NBellanca 7ECA · S/N 133480N5063GBellanca 8KCAB · S/N 59580N11655Bellanca 7GCBC · S/N 346-72N50605Bellanca 7GCBC · S/N 116579N9089EAeronca 11AC · S/N 11AC-722N76PDBellanca 8GCBC · S/N 220-76N8675VBellanca 8GCBC · S/N 173-75N8586VBellanca 7GCBC · S/N 798-75N8694VBellanca 7GCBC · S/N 832-75N8708VBellanca 7GCBC · S/N 835-75N8555VBellanca 8GCBC · S/N 138-75N4107BBellanca 17-30A · S/N 75-30744N14746Bellanca 17-30A · S/N 74-30687N14766Bellanca 17-31ATC · S/N 75-31109N88301Bellanca 7ECA · S/N 105574N88359Bellanca 8GCBC · S/N 771-74N88309Bellanca 7GCBC · S/N 764-74N87060Bellanca 8GCBC · S/N 58-74N86812Bellanca 7KCAB · S/N 430-74N57686Bellanca 8KCAB · S/N 131-74N93729Bellanca 17-30A · S/N 74-30621N8945Bellanca 7GCAA · S/N 281-74N39860Bellanca 17-31A · S/N 73-32-106N90970Bellanca 7GCBC · S/N 427-73N8725VBellanca 8GCBC · S/N 175-75N4929VBellanca 17-30 · S/N 30140N4879VBellanca 17-30 · S/N 30121N534ABellanca 14-19 · S/N 2087N19195Bellanca 14-9 · S/N 1002N190MBellanca 28-70 · S/N 902N10762Bellanca PACEMAKER E · S/N 202N13266Bellanca CH400 SKYROCKET · S/N 803N274EBellanca CH · S/N 122N2054Fairchildairplane Mfg 51-A · S/N 10N12655Bellanca LONG DISTANCE · S/N 3005N252MBellanca CH300 PACEMAKER · S/N 155N684WBellanca P-200 (AIRBUS) · S/N 701N694EBellanca CH300 PACEMAKER · S/N 144N870MBellanca CH300 PACEMAKER · S/N 162N223ESpirit Of Wenatchee BELLANCA CH 300 REPL · S/N 120N689EBellanca CH300 PACEMAKER · S/N 139N692EBellanca CH300 PACEMAKER · S/N 142N693EBellanca CH300 PACEMAKER · S/N 143N785WBellanca BELLANCA AIRBUS · S/N 702
Back to Bellanca Aircraft Corp