Boeing Vertol Co
Earlier aircraft under this name · 56
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 = 'BOEING VERTOL CO' OR list_contains(d.other_registrant_names, 'BOEING VERTOL 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 = 'BOEING VERTOL CO' OR list_contains(d.other_registrant_names, 'BOEING VERTOL 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.
N7425HBoeing Co Vertol Div 414-100 · S/N MQ001N37059Boeing-Vertol CH-47(352) · S/N MA031N37015Boeing-Vertol CH-47(352) · S/N MA003N37052Boeing-Vertol CH-47(352) · S/N MA027N37056Boeing-Vertol CH-47(352) · S/N MA029N31787Boeing-Vertol CH47-309 · S/N CG102N37010Boeing-Vertol CH-47(352) · S/N MA001N31779Boeing-Vertol 219 CH47C · S/N D041N31786Boeing-Vertol CH47-309 · S/N CG101N37051Boeing-Vertol CH-47(352) · S/N MA026N37053Boeing-Vertol CH-47(352) · S/N MA028N37047Boeing-Vertol CH-47(352) · S/N MA024N37048Boeing-Vertol CH-47(352) · S/N MA025N37040Boeing-Vertol CH-47(352) · S/N MA019N37042Boeing-Vertol CH-47(352) · S/N MA020N37043Boeing-Vertol CH-47(352) · S/N MA021N37044Boeing-Vertol CH-47(352) · S/N MA022N37046Boeing-Vertol CH-47(352) · S/N MA023N37037Boeing-Vertol CH-47(352) · S/N MA018N37031Boeing-Vertol CH-47(352) · S/N MA015N37033Boeing-Vertol CH-47(352) · S/N MA016N37016Boeing-Vertol CH-47(352) · S/N MA004N37011Boeing-Vertol CH-47(352) · S/N MA002N37022Boeing-Vertol CH-47(352) · S/N MA008N37023Boeing-Vertol CH-47(352) · S/N MA009N37025Boeing-Vertol CH-47(352) · S/N MA010N37026Boeing-Vertol CH-47(352) · S/N MA011N37027Boeing-Vertol CH-47(352) · S/N MA012N37029Boeing-Vertol CH-47(352) · S/N MA013N237BVBoeing-Vertol 234 · S/N MJ004N37019Boeing-Vertol CH-47(352) · S/N MA005N37020Boeing-Vertol CH-47(352) · S/N MA006N37021Boeing-Vertol CH-47(352) · S/N MA007N37008Boeing-Vertol CH47-308 · S/N CG072N37009Boeing-Vertol CH47-308 · S/N CG073N37007Boeing-Vertol CH47-308 · S/N CG071N37002Boeing-Vertol 219 CH47C · S/N D045N31788Boeing-Vertol 219 CH47C · S/N D043N31785Boeing CH47C · S/N G009N31782Boeing-Vertol 176 · S/N F008N31783Boeing-Vertol 176 · S/N F009N31784Boeing-Vertol 176 · S/N F010N31762Boeing-Vertol 219 CH47C · S/N D031N6533RBoeing-Vertol 219 CH47C · S/N D024N6531RBoeing-Vertol 219 CH47C · S/N D022N6530RBoeing-Vertol 219 CH47C · S/N D021N6528RBoeing-Vertol 219 CH47C · S/N D019N6529RBoeing-Vertol 219 CH47C · S/N D020N6526RBoeing-Vertol 219 CH47C · S/N D017N6527RBoeing-Vertol 219 CH47C · S/N D018
Back to Boeing Vertol Co