Continental Copters Inc
Earlier aircraft under this name · 19
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 = 'CONTINENTAL COPTERS INC' OR list_contains(d.other_registrant_names, 'CONTINENTAL COPTERS INC') 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 = 'CONTINENTAL COPTERS INC' OR list_contains(d.other_registrant_names, 'CONTINENTAL COPTERS INC') 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.
N9084TContinental Copters TOMCAT MK6B · S/N CCI-77-2N9097TContinental Copters JET-CAT JC-1A · S/N 001N9094TContinental Copters TOMCAT MK6B · S/N CCI78-6N9095TContinental Copters TOMCAT MK6B · S/N CCI-78-7N9076TContinental Copters TOMCAT MK6B · S/N CCI-76-2N9071TContinental Copters TOMCAT MK5A · S/N CCI-75-6N9070TContinental Copters OH-13H · S/N CCI-75-5N9026TContinental Copters OH-13H · S/N CCI-74-8N9025TContinental Copters-Segerstrom TOMCAT MK-5A (OH-13) · S/N CCI74-7N6725DBell 47G-2 · S/N 2218N33628Bell 47G-3B · S/N 2606N6398XBell 47G-2 · S/N 738N74090Bell-Barnes 47D1 · S/N SA 2N73877Bell 47G · S/N CCI-164N3919ABell 47D1 · S/N A2N5192BBell 47J · S/N 1736N6358XContinental Copters 47-G2 · S/N CCI-663N9169RBell 47G · S/N 101-61N9174RBell-Continental Copters 47G-ELTOMCAT MKII · S/N 8
Back to Continental Copters Inc