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.

N220PRMcdonnell-Douglas DC-10-30 · S/N 46577Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1973 · Charlotte, NCN602PRBoeing 747-151 · S/N 19779Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1970 · Charlotte, NCN228PRMcdonnell-Douglas DC-10-30 · S/N 46578Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1973 · Charlotte, NCN322XVBoeing 737-219 · S/N 19930Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1968 · Charlotte, NCN8148ADouglas DC-8-33 · S/N 45267Cancelled Jan 22, 2004 · Triennial form not returned · Built 1960 · Charlotte, NCN29922Douglas DC-8-55 · S/N 45754Cancelled Aug 15, 1983 · Exported to Ecuador · Charlotte, NCN7807MFairchild FH-227 · S/N 518Cancelled Feb 3, 1983 · Charlotte, NCN8110NBoeing 727-25 · S/N 18261Cancelled Mar 16, 1982N196CABoeing 707-124 · S/N 17610Cancelled Sep 1, 1981 · Exported to Dominican Republic · Built 1959 · Charlotte, NCN90287Boeing 707-328 · S/N 17921Cancelled Mar 26, 1980 · Exported to Israel · Built 1960 · Charlotte, NCN8027Douglas DC-8-33 · S/N 45255Cancelled Jan 26, 1976 · Exported to Argentina · Charlotte, NCN30052Douglas C54B-DC · S/N 10497Cancelled May 8, 1975 · Built 1944 · Charlotte, NCN90535Douglas DC-6B · S/N 43828Cancelled Mar 21, 1975 · Exported to ColombiaN6299Douglas C-54G · S/N 36036Cancelled Jan 28, 1975 · Exported to Bolivia · Charlotte, NCN21175Convair 340 · S/N 175Cancelled Jul 19, 1974 · Charlotte, NCN1563MConsolidated Vultee PBY-5A · S/N 46539Cancelled Feb 7, 1974 · Exported to Canada · Charlotte, NCN41187Convair 240 · S/N 87Cancelled Dec 11, 1973 · Charlotte, NCN1638Boeing 727-95 · S/N 19596Cancelled May 25, 1973 · Exported to Brazil · Charlotte, NCN1637Boeing 727-95 · S/N 19595Cancelled May 11, 1973 · Exported to Brazil · Built 1967 · Charlotte, NCN41VDouglas DC3A · S/N 2227Cancelled Oct 16, 1972 · Built 1940 · Charlotte, NCN40448Martin 404 · S/N 14242Cancelled Jul 18, 1972 · Exported to Bahamas · Charlotte, NCN21467Convair 440 · S/N 467Cancelled Jan 17, 1972 · Exported to Bolivia · Charlotte, NCN21471Convair 440 · S/N 471Cancelled Oct 1, 1971 · Exported to Bolivia · Carlotte, NCN7289CNorth American T-28A · S/N 491674ACancelled Feb 5, 1971 · Exported to Mexico · Charlotte, NCN21118Convair 240 · S/N 18Cancelled Nov 17, 1970 · Exported to Argentina · Charlotte, NCN45343Douglas C-54E · S/N 27264Cancelled Oct 26, 1970 · Exported to Spain · Built 1945 · Charlotte, NCN4730SDouglas C-47 · S/N 14303Cancelled Oct 26, 1970 · Exported to Colombia · Charlotte, NCN86442Douglas C-47D · S/N 45-1091Cancelled Oct 26, 1970 · Exported to Spain · Built 1961 · Charlotte, NCN86449Douglas C-47D · S/N 43-49431Cancelled Oct 26, 1970 · Exported to Spain · Built 1961 · Charlotte, NCN40444Martin 404 · S/N 14229Cancelled Jul 1, 1970 · Charlotte, NCN40VDouglas DC3 · S/N 3287Cancelled Jul 1, 1970 · Built 1941 · Charlotte, NCN56VDouglas DC3A · S/N 4900Cancelled Jul 1, 1970 · Charlotte, NCN8220Douglas C54-D · S/N 10670Cancelled Jul 1, 1970 · Charlotte, NCN1026BNorth American T-28A · S/N 50-253Cancelled Jun 30, 1970 · Charlotte, NCN1111UNorth American T-6G · S/N 49-3238Cancelled Jun 30, 1970 · Charlotte, NCN1121UNorth American AT-6 · S/N 112249Cancelled Jun 30, 1970 · Charlotte, NCN1122UNorth American AT-6 · S/N 112047Cancelled Jun 30, 1970 · Charlotte, NCN1142UNorth American AT-6D · S/N 90914Cancelled Jun 30, 1970 · Charlotte, NCN1573MKaman Aerospace K-225 · S/N 10Cancelled Jun 30, 1970 · Built 1954 · Charlotte, NCN21136Convair 240 · S/N 36Cancelled Jun 30, 1970 · Charlotte, NCN73861Douglas DC3 · S/N 4884Cancelled Jun 30, 1970 · Charlotte, NCN8204ENorth American SNJ-5 · S/N 90676Cancelled Jun 30, 1970 · Charlotte, NCN8784RDouglas DC-8F-54 · S/N 45769Cancelled Jun 30, 1970 · Built 1965 · Charlotte, NCN88843Douglas DC-4 · S/N 3113Cancelled Jun 30, 1970 · Charlotte, NCN88912Douglas C54B-DC · S/N 27235Cancelled Jun 30, 1970N3652FNorth American AT-6 · S/N 112048Cancelled Jun 29, 1970 · Charlotte, NCN3704GDouglas B-26 · S/N 44-35921Cancelled Jun 29, 1970 · Charlotte, NCN37520Douglas DC-6 · S/N 43009Cancelled Jun 29, 1970 · Charlotte, NCN37529Douglas DC-6 · S/N 43018Cancelled Jun 29, 1970 · Charlotte, NCN3821Douglas C-54B · S/N 10356Cancelled Jun 29, 1970 · Built 1967 · Charlotte, NC
Back to Charlotte Aircraft Corp