Bell Helicopter Co
Earlier aircraft under this name · 217
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 = 'BELL HELICOPTER CO' OR list_contains(d.other_registrant_names, 'BELL HELICOPTER CO') 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 = 'BELL HELICOPTER CO' OR list_contains(d.other_registrant_names, 'BELL HELICOPTER CO') 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.
N14820Bell 206B-I · S/N 44701N7952JBell 206A · S/N 672N8560FBell 206A · S/N 1N6264NBell 47G-3B-1 · S/N 6656N7921JBell 47G-4A · S/N 7752N4768RBell 206A-1 · S/N 40001N204LBell 204-B · S/N 1501N2774NBell 206B · S/N 2780N27731Bell 206B · S/N 2754N59417Bell 206B · S/N 1174N9942KBell 206L · S/N 45038N6295NBell 206A · S/N 155N58090Bell 206B · S/N 1032N90008Bell 212 · S/N 30703N59408Bell 206B · S/N 1493N8590FBell 206A · S/N 2N7075JBell 212 · S/N 30505N8550FBell 47J-2A · S/N 3707N15FDBell 206A · S/N 492N73951Bell 47G-2A-1 · S/N 2863N2990WBell 212 · S/N 30597N59501Bell 206B · S/N 1303N59503Bell 206B · S/N 1304N58152Bell 206B · S/N 1142N4707RBell 206B · S/N 265N59519Bell 206B · S/N 1263N577KBell 577 · S/N 2501N58080Bell 206B · S/N 1171N58159Bell 206B · S/N 1175N59458Bell 206B · S/N 1215N59432Bell 206B · S/N 1139N59407Bell 206B · S/N 1201N59431Bell 206B · S/N 1164N2911WBell 206B · S/N 732N59460Bell 206B · S/N 1183N58158Bell 212 · S/N 30593N58050Bell 212 · S/N 30585N58049Bell 212 · S/N 30582N58117Bell 206B · S/N 1098N58119Bell 206B · S/N 1099N58155Bell 206B · S/N 1056N83159Bell 206B · S/N 1073N58021Bell 206B · S/N 1071N58022Bell 206B · S/N 1075N83160Bell 206B · S/N 1074N58156Bell 206B · S/N 1051N58024Bell 212 · S/N 30572N58025Bell 212 · S/N 30574N58027Bell 212 · S/N 30577N58020Bell 206B · S/N 1043
Back to Bell Helicopter Co