OpenAirDocs.org
Columbia, SC

Cancelled registrations · 148

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 = 'COLUMBIA'
  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.

N710Cessna 185A · S/N 185-0494Cancelled Jan 30, 2009 · Triennial form not returned · Built 1962 · South Carolina Forestry CommissionN981CABombardier CL-600-2B19 · S/N 7163Cancelled Oct 28, 2008 · Exported to Canada · Built 1997 · World Aircraft Trading IncN521PGCirrus Design SR20 · S/N 1983Cancelled Sep 25, 2008 · Exported to India · Built 2008 · World Aircraft Trading IncN498ACBeech 200 · S/N BB-287Cancelled Feb 14, 2008 · Exported to Canada · Built 1977 · Pollard Aircraft Sales IncN6168FCessna 172N · S/N 17273159Cancelled May 24, 2007 · Exported to Romania · Built 1979 · Jim Hamilton Aircraft IncN1556HCessna 177RG · S/N 177RG0730Cancelled Mar 19, 2007 · Triennial form not returned · Built 1975 · Aircraft Holding Co LLCN55YSCessna 182P · S/N 18265169Cancelled Mar 7, 2007 · Built 1976 · M B Kahn Construction Co IncN550KRCessna 550 · S/N 550-0727Cancelled Sep 13, 2006 · Exported to India · Built 1994 · World Aircraft Trading IncN550RMCessna 550 · S/N 550-0698Cancelled Sep 13, 2006 · Exported to India · Built 1992 · World Aircraft Trading IncN19WLAero Commander 500 S · S/N 3160Cancelled Oct 8, 2004 · Triennial form not returned · Built 1973 · South Carolina Department Of Natural ResourcesN123CVIsrael Aircraft Industries 1123 · S/N 178Cancelled Oct 1, 2004 · Built 1974 · Richland LLCN57HTBeech B100 · S/N BE-7Cancelled May 11, 2004 · Exported to Canada · Built 1976 · Univ Of South Carolina Development FoundationN75CFBeech E-90 · S/N LW-212Cancelled Jun 26, 2001 · Triennial form not returned · University Of South Carolina Athletic DeptN714PUCessna 150M · S/N 15079334Cancelled Jun 5, 2001 · Second triennial mailing, no response · Dipretoro Richard SN2095SSteve Culp CULPS SPECIAL · S/N 004Cancelled Jan 29, 2001 · Russell Robert R JrN502SLHughes 369A · S/N 980765Cancelled Jan 29, 2001 · Triennial form not returned · State Of South CarolinaN6363BCessna 152 · S/N 15283925Cancelled Mar 30, 2000 · Triennial form not returned · Jim Hamilton Aircraft IncN3000VBeech B35 · S/N D-2533Cancelled Dec 7, 1999 · Triennial form not returned · Mcfarland Douglas CN3517JCessna 150E · S/N 15061217Cancelled Feb 1, 1999 · Triennial form not returned · Martin DorothyN3750HMooney M20J · S/N 240922Cancelled Jun 2, 1998 · Triennial form not returned · Lagatore Thomas PN5530UBell TH-1L · S/N 157848Cancelled Sep 19, 1997 · Triennial form not returned · South Carolina Forestry CommissionN58205Bell TH-1L · S/N 157849Cancelled Sep 19, 1997 · Triennial form not returned · South Carolina Forestry CommissionN68RFBell 204 · S/N 659521Cancelled Sep 19, 1997 · Triennial form not returned · South Carolina Forestry CommissionN3963NBeech 35 · S/N D-1224Cancelled May 20, 1996 · Built 1948 · Buchanan AriN72MCulver LCA · S/N 207Cancelled Jun 27, 1994 · Triennial form not returned · Thomas HalN31187Myers Ralph David AVID FLYER D · S/N 767Cancelled Jul 28, 1993 · Myers Ralph DN1976NCessna 140 · S/N 12212Cancelled Jan 19, 1993 · Watkins Thomas MN734JZCessna 172N · S/N 17268902Cancelled Jun 12, 1992 · Exported to Ireland · Piercy Charles CN2WPCessna 401B · S/N 401B0104Cancelled Nov 2, 1988 · Built 1969 · Peeler William BN733KWCessna 172N · S/N 17268361Cancelled Jul 31, 1985 · Midlands Avation CorpN67SCChrysostomides SHARK BI-PLANE · S/N NSBP-1Cancelled Apr 12, 1985 · Chrysostomides Staros AN1CJSmith MINIPLANE · S/N LN1Cancelled Nov 24, 1982 · Administratively canceled · Moyer Kenneth GN78744Cessna 182P · S/N 18261779Cancelled Oct 15, 1981 · Congaree Construction CoN7896Siai-Marchetti F.260 · S/N 124Cancelled Oct 14, 1980 · Bob Russell Realty IncN48336Cessna T-41B · S/N R172-0188Cancelled Jan 12, 1980 · Fort Jackson Aero ClubN130SCBell 47G-3B-1 · S/N 3744Cancelled Jun 28, 1978 · Exported to Panama · South Carolina Aeronautics CommissionN7842RBeech E33 · S/N CD-1204Cancelled Sep 21, 1977 · Aroneck Charles MN97481Beech UC-45J · S/N 023813Cancelled Jul 25, 1977 · South Carolina Committee For Technical EducationN87778Lockheed T-33 · S/N 58497Cancelled Jul 18, 1977 · Built 1973 · State Board For Technical & Comprehensive EducatioN8991DPiper PA-18A 150 · S/N 18-6395Cancelled Jul 18, 1977 · Paschal James TN68399Bell H-13E · S/N 438Cancelled Jul 12, 1977 · South Carolina Committe For Technical EducationN3822MPiper PA-12 · S/N 122565Cancelled Jul 6, 1977 · Built 1947 · Paschal James TN8242ERyan NAVION A · S/N NAV4-1663Cancelled May 27, 1976 · S C Committee For Technical EducationN67033Bell TH-13T · S/N 3767Cancelled Jan 22, 1976 · Sale reportedN67170Bell TH-13T · S/N 67-17035Cancelled Jan 21, 1976 · South Carolina Disaster Preparedness AgencyN5WPCessna 310J · S/N 310J0060Cancelled May 8, 1975 · Morris James WN90946Dehavilland DHC 2 MK III · S/N 57-2567Cancelled Sep 5, 1974 · Fort Jackson Aero ClubN2860SCessna 150G · S/N 15066760Cancelled Jul 31, 1974 · Williams Ross O JrN6449WPiper PA-28-140 · S/N 28-20521Cancelled Apr 23, 1974 · Lagatore Thomas PN711FCBeech C90 · S/N LJ-516Cancelled Apr 10, 1974 · Built 1971 · Federal Land Bank Of Columbia Et Al
Back to Columbia, SC