Bell Helicopter Textron
Earlier aircraft under this name · 71
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 TEXTRON' OR list_contains(d.other_registrant_names, 'BELL HELICOPTER TEXTRON') 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 TEXTRON' OR list_contains(d.other_registrant_names, 'BELL HELICOPTER TEXTRON') 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.
N5736XBell 214ST · S/N 18402N412BHBell 212 · S/N 30963N50137Bell 206B · S/N 2551N427DLBell 427 · S/N 56035N51335Bell 430 · S/N 49094N2269SCessna 172R · S/N 17280955N2464DCessna 172R · S/N 17280961N2464XCessna 172R · S/N 17280964N2472JCessna 172R · S/N 17280965N2472ZCessna 172R · S/N 17280966N2473DCessna 172R · S/N 17280967N3203WBell 206L-3 · S/N 51197N3205KBell 214ST · S/N 28179N3210QBell 206L-3 · S/N 51190N1209WBell 206B · S/N 4444N206BSBell 206B · S/N 4201N5128NBell 206L-3 · S/N 51601N206NWBell 206-L4 · S/N 52018N5129GBell 206L-3 · S/N 51602N4196GBell 206L-3 · S/N 51484N3120YBell 206L-3 · S/N 51503N5746ZBell Helicopter Textron 212 · S/N 31121N3899UBell 206L-3 · S/N 51016N3889ABell Helicopter Textron 212 · S/N 31215N2289RBell 206B · S/N 3650N5018FBell 206B · S/N 2614N2235RBell 206L-3 · S/N 51005N83110Bell 212 · S/N 30559N22306Bell Helicopter Textron Canada 412EP · S/N 33039N2160LBell Helicopter Textron 206B · S/N 3500N2079DBell 412 · S/N 33016N2135JBell Helicopter Textron 206L-1 · S/N 45645N2141BBell 412 · S/N 33034N2058SBell 206B · S/N 3108N16756Bell 206L · S/N 45059N83118Bell 206B · S/N 954N3891PBell 214B · S/N 28059N5016QBell 206B · S/N 2628N38892Bell 214B · S/N 28057N3902DBell 206B · S/N 3181N1085ABell 206B · S/N 3015N5741SBell Helicopter Textron 206B · S/N 2980N5740TBell Helicopter Textron 206L-1 · S/N 45462N2777FBell Helicopter Textron 212 · S/N 30927N8164JBell 206B · S/N 554N1082YBell 222 · S/N 47017N1481WBell 206B · S/N 424N6285NBell 206B · S/N 321N9969KBell 206L · S/N 45057N2779NBell 206B · S/N 2820
Back to Bell Helicopter Textron