OpenAirDocs.org
Charleston, SC

Cancelled registrations · 136

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_state = 'SC' AND d.registrant_city = 'CHARLESTON'
  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.

N756TECessna U206G · S/N U20604337Cancelled May 14, 1998 · Exported to Mexico · Hanger Aviation IncN56698Piper PA-32-260 · S/N 327400005Cancelled Mar 12, 1998 · Triennial form not returned · Frw Aviation & Maritime IncN225SHCessna 421B · S/N 421B0883Cancelled May 9, 1996 · Exported to India · Exchange Investment CorporationN9646VCessna R172K · S/N R1722342Cancelled Feb 15, 1996 · Exported to Turkey · Hanger Aviation IncN1151SMooney M20J · S/N 241229Cancelled Dec 4, 1995 · Exported to Israel · Hanger Aviation IncN7020LCessna 310K · S/N 310K0120Cancelled Oct 12, 1995 · Triennial form not returned · United States Air Force-OwnerN55234Piper PA-28-140 · S/N 287325348Cancelled Jul 12, 1995 · Hangar Aviation IncN6548YCessna T210N · S/N 21064431Cancelled Mar 22, 1995 · Exported to Argentina · Hanger Aviation IncN21633Piper PA-28-181 · S/N 287990055Cancelled Feb 23, 1995 · Exported to Chile · Hanger Aviation IncN7564YCessna R182 · S/N R18200136Cancelled Dec 13, 1994 · Exported to South Africa · Hanger Aviation IncN260JSPitts Aerobatics S-2B · S/N 5020Cancelled Jun 9, 1994 · Exported to Canada · Hardwick Steven FN8352CPiper PA-32R-300 · S/N 32R7680107Cancelled Feb 18, 1993 · Exported to Germany · Hanger Aviation IncN1279FCessna 172N · S/N 17272983Cancelled Jan 20, 1993 · Exported to Germany · Hanger Aviation IncN758MFCessna R172K · S/N R1723199Cancelled Jan 13, 1993 · Exported to CanadaN756NUCessna U206G · S/N U20604231Cancelled Nov 30, 1992 · Exported to Costa Rica · Hanger Aviation IncN5110FCessna 172F · S/N 17252741Cancelled Oct 21, 1992 · Second triennial mailing, no response · UsafN9178YPiper PA-28-181 · S/N 288690044Cancelled Aug 26, 1992 · Exported to Germany · Hanger Aviation IncN16933Bell 206B-III · S/N 2338Cancelled Oct 25, 1991 · Triennial form not returned · Omniflight Aircraft CorporationN1556ECessna 172N · S/N 17271045Cancelled Jul 12, 1991 · Exported to Germany · Hangar Aviation IncN5384MCessna 152 · S/N 15284573Cancelled Mar 20, 1991 · Exported to Spain · Hanger Aviation IncN8648BCessna 172 · S/N 36348Cancelled Jan 28, 1991 · Triennial form not returned · Watt Norman CN756HWCessna TU206G · S/N U20604113Cancelled Dec 12, 1990 · Exported to Mexico · Hanger Aviation IncN6234LCessna 152 · S/N 15284380Cancelled Jan 19, 1983 · Wcsc IncN776SWPiper PA-31P · S/N 31P-7730009Cancelled Mar 3, 1982 · Aircraft Finance And Leasing Co IncN65492Cessna 152 · S/N 15281585Cancelled Mar 1, 1982 · Aero Aviation IncN97521Byrd SCORPION TOO · S/N 10735Cancelled Jan 14, 1982 · Administratively canceled · Byrd Ira F JrN3557WPiper PA-31-325 · S/N 31-8012024Cancelled Apr 3, 1981 · Exported to Mexico · Built 1980 · Hawthorne AviationN3633EPiper PA-36-300 · S/N 36-7960046Cancelled Jul 30, 1979 · Exported to Guatemala · Hawthorne AviationN63893Piper PA-23-250 · S/N 27-7854037Cancelled Oct 24, 1978 · Exported to Canada · Hawthorne AviationN7924LBeech A23-24 · S/N MA-137Cancelled Oct 20, 1978 · Exported to Mexico · Willis Arthur AN62814Piper PA-23-250 (6PCLM) · S/N 27-7754046Cancelled Sep 26, 1978 · Exported to Canada · Hawthorne AviationN422Blackstock BANTAM W-3 · S/N RRCCC03171Cancelled Jul 7, 1977 · Built 1975 · Blackstock RalphN3682HErcoupe 415-C · S/N 4307Cancelled Jun 22, 1977 · Bishop Tedd LN3813PPiper PA-22-150 · S/N 22-3503Cancelled Jul 23, 1976 · Built 1962 · Gurley Raymond JN1916GCessna T310R · S/N 310R0060Cancelled Jun 10, 1976 · Chapman Howard RN32016Piper PA-28-140 · S/N 28-7525011Cancelled Jun 3, 1976 · Built 1974 · Hawthorne AviationN33314Piper PA-28R-200 · S/N 28R7535132Cancelled Apr 20, 1976 · Built 1975 · Hawthorne AviationN8888BCessna 172 · S/N 36588Cancelled Sep 10, 1974 · Potts Edward RN6364SCessna 150G · S/N 15067164Cancelled Jul 18, 1974 · Coastal Patrol Cap Aero Club IncN3059SCessna 150G · S/N 15066959Cancelled Jun 21, 1973 · Charleston Afb Aero ClubN15696Buecker-Jungmeister 133 · S/N 42Cancelled Nov 30, 1971 · Built 1936 · Howard BeverlyN5464DBeech H35 · S/N D-4972Cancelled Feb 1, 1971 · Truluck Construction CoN35329Piper J3C-65 · S/N 6296Cancelled Jan 15, 1971 · Hawthorne Flying ServiceN3206VBeech 35 · S/N D-643Cancelled Jan 14, 1971 · Wooten Roland F JrN9715FCessna 170A · S/N 18969Cancelled Jan 4, 1971 · Elsey Hubert LN5190HPiper PA-14 · S/N 14-508Cancelled Dec 10, 1970 · Pinckney Warren ON8142Blackstock JAY TEE RCB-1 · S/N CRC-873Cancelled Jun 29, 1970 · Blackstock RalphN2329JBeech 23 · S/N M-274Cancelled Jan 16, 1970 · Kegley Ben LN9006WPiper PA-23-235 · S/N 28-10587Cancelled Nov 30, 1967 · Built 1964 · Coburg Dairy IncN4126VCessna 170 · S/N 18458Cancelled May 22, 1965 · Wehman Ernest A
Back to Charleston, SC