Charlotte Aircraft Corp
Earlier aircraft under this name · 123
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 = 'CHARLOTTE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'CHARLOTTE 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 = 'CHARLOTTE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'CHARLOTTE 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.
N220PRMcdonnell-Douglas DC-10-30 · S/N 46577N602PRBoeing 747-151 · S/N 19779N228PRMcdonnell-Douglas DC-10-30 · S/N 46578N322XVBoeing 737-219 · S/N 19930N8148ADouglas DC-8-33 · S/N 45267N29922Douglas DC-8-55 · S/N 45754N7807MFairchild FH-227 · S/N 518N8110NBoeing 727-25 · S/N 18261N196CABoeing 707-124 · S/N 17610N90287Boeing 707-328 · S/N 17921N8027Douglas DC-8-33 · S/N 45255N30052Douglas C54B-DC · S/N 10497N90535Douglas DC-6B · S/N 43828N6299Douglas C-54G · S/N 36036N21175Convair 340 · S/N 175N1563MConsolidated Vultee PBY-5A · S/N 46539N41187Convair 240 · S/N 87N1638Boeing 727-95 · S/N 19596N1637Boeing 727-95 · S/N 19595N41VDouglas DC3A · S/N 2227N40448Martin 404 · S/N 14242N21467Convair 440 · S/N 467N21471Convair 440 · S/N 471N7289CNorth American T-28A · S/N 491674AN21118Convair 240 · S/N 18N45343Douglas C-54E · S/N 27264N4730SDouglas C-47 · S/N 14303N86442Douglas C-47D · S/N 45-1091N86449Douglas C-47D · S/N 43-49431N40444Martin 404 · S/N 14229N40VDouglas DC3 · S/N 3287N56VDouglas DC3A · S/N 4900N8220Douglas C54-D · S/N 10670N1026BNorth American T-28A · S/N 50-253N1111UNorth American T-6G · S/N 49-3238N1121UNorth American AT-6 · S/N 112249N1122UNorth American AT-6 · S/N 112047N1142UNorth American AT-6D · S/N 90914N1573MKaman Aerospace K-225 · S/N 10N21136Convair 240 · S/N 36N73861Douglas DC3 · S/N 4884N8204ENorth American SNJ-5 · S/N 90676N8784RDouglas DC-8F-54 · S/N 45769N88843Douglas DC-4 · S/N 3113N88912Douglas C54B-DC · S/N 27235N3652FNorth American AT-6 · S/N 112048N3704GDouglas B-26 · S/N 44-35921N37520Douglas DC-6 · S/N 43009N37529Douglas DC-6 · S/N 43018N3821Douglas C-54B · S/N 10356
Back to Charlotte Aircraft Corp