Cape Girardeau, MO

Cancelled registrations · 88

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 = 'MO' AND d.registrant_city = 'CAPE GIRARDEAU'
  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.

N7429CBlazing Wings 50% ULTIMATE · S/N PWC 0001Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Clarke Paul WN126PJFarquhar John PJ-1000 · S/N 0001Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 2007 · Farquhar John MN5830VSchweizer SGS 1-26B · S/N 265Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1964 · Harmon RexN5647DBeech E18S · S/N BA-364Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1958 · Cape Central Airways IncN453SEEaa Chapter 453 BREEZY · S/N RLU-1Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1976 · Lost Hill Flying Club IncN45746Allen B-8M · S/N JBA-1Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1978 · Arnzen James JN9034MLangford Don TANDEM AIR BIKE · S/N AB209AMTCancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 2007 · Clubb Jerry DN7404ECessna 210 · S/N 57104Cancelled Sep 5, 2014 · Revoked, pending cancellation · Built 1959 · Auction Air IncN548BDCrowe John T BEDE 5B · S/N 548Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Crowe John TN114XXRockwell International 114A · S/N 14511Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1979 · Commander Aircraft CompanyN40TJWright-Thomas EAA BIPLANE P-2 · S/N 001Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Fowler RonaldN43043Taylorcraft BC12-D · S/N 6702Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1946 · Cape Central Airways IncN4596ECessna A185F · S/N 18503807Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1979N71482Luscombe 8A · S/N 2909Cancelled Sep 6, 2012 · Revoked, canceled · Built 1946 · Gremore JackN45726Sikorsky H-34J · S/N 56-4307Cancelled Sep 28, 2011 · First renewal notice · Built 1956 · Davis Shannon YorkN555ACBeech 58 · S/N TH-12Cancelled May 19, 2007 · Second triennial mailing, no response · Built 1970 · River City Aviation IncN4884VBellanca 17-30 · S/N 30149Cancelled Jul 18, 2006 · Expired dealer · Built 1968 · Weller Larry E DBAN8706HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1481Cancelled Feb 20, 2004 · Second triennial mailing, no response · Built 1975 · Hopwood Reggie SN4353YPiper PA-32-301 · S/N 32-8406010Cancelled Jun 16, 2003 · Built 1984 · Keemo LLCN4092LRaven S55A · S/N S55A-1016Cancelled Mar 7, 2003 · Triennial form not returned · Built 1983 · Friedrich Jon PN8042QCessna 421B · S/N 421B0042Cancelled Jun 21, 1994 · Triennial form not returned · Palen James E MdN571DDBeech H-18 · S/N BA714Cancelled Mar 17, 1994 · Administratively canceled · Cape Central Airways IncN6939HCessna 172M · S/N 17265655Cancelled Mar 2, 1992 · Exported to Netherlands · Mcclanahan Jerry WN48426Grumman Acft ENG Cor-Schweizer G-164A · S/N 1635Cancelled Aug 26, 1991 · Triennial form not returned · Hopwood Reggie SN759AFCessna 182Q · S/N 18265833Cancelled Feb 1, 1985 · Exported to Australia · Cape Central Airways IncN6346HCessna 182R · S/N 18267886Cancelled Jun 22, 1984 · Exported to Australia · Cape Central Airways IncN732NHCessna U206G · S/N U20604701Cancelled Dec 9, 1980 · Exported to Norway · Cape Central Airways IncN7038SCessna 150H · S/N 15067738Cancelled Nov 12, 1980 · Del-Taire IncN6461DCessna 172N · S/N 17272812Cancelled Jun 16, 1980 · Exported to Norway · Cape Central Airways IncN5349UCessna U206G · S/N U20605230Cancelled Apr 18, 1980 · Exported to Norway · Cape Central Airways IncN5557ECessna 172N · S/N 17271889Cancelled Apr 18, 1980 · Exported to Germany · Cape Central Airways IncN4824ECessna A185F · S/N 18503882Cancelled Mar 27, 1980 · Exported to Norway · Cape Central Airways IncN4951UCessna U206G · S/N U206-05175Cancelled Jan 18, 1980 · Exported to Norway · Cape Central Airways IncN5305UCessna U206G · S/N U20605186Cancelled Sep 21, 1979 · Exported to Norway · Built 1979 · Avicosouth Ltd Single Engine Zone OfficeN733EXCessna U206G · S/N U20604763Cancelled Aug 16, 1979 · Exported to Norway · Cape Central Airways IncN739HLCessna 172N · S/N 17270555Cancelled Jul 11, 1979 · Exported to Trinidad and Tobago · Cape Central Airways IncN48839Cessna 152 · S/N 15280995Cancelled Jun 18, 1979 · Exported to Germany · Cape Central Airways IncN732EGCessna U206G · S/N U20604664Cancelled Jun 15, 1979 · Exported to Norway · Cape Central Airways IncN8533QCessna A185F · S/N 18503727Cancelled May 23, 1979 · Exported to Norway · Cape Central Airways IncN1426ECessna 172N · S/N 17270994Cancelled May 22, 1979 · Exported to Germany · Cape Central Airways IncN739AACessna 172N · S/N 17270379Cancelled May 22, 1979 · Exported to Germany · Cape Central Airways IncN739UHCessna 172N · S/N 17270813Cancelled May 22, 1979 · Exported to Germany · Cape Central Airways IncN739YDCessna 172N · S/N 17270905Cancelled May 22, 1979 · Exported to Germany · Cape Central Airways IncN739EBCessna 172N · S/N 17270475Cancelled Apr 9, 1979 · Exported to Norway · Cape Central Airways IncN739PZCessna 172N · S/N 17270709Cancelled Mar 14, 1979 · Exported to Norway · Cape Central Airways IncN739AECessna 172N · S/N 17270383Cancelled Mar 2, 1979 · Exported to Germany · Cape Central Airways IncN49051Cessna 152 · S/N 15281123Cancelled Feb 20, 1979 · Exported to Germany · Cape Central Airways IncN738MDCessna 172N · S/N 17270077Cancelled Oct 6, 1978 · Exported to Germany · Cape Central Airways IncN738PZCessna 172N · S/N 17270143Cancelled Oct 6, 1978 · Exported to Germany · Cape Central Airways IncN69MPAmerican AA-1 · S/N AA1-0104Cancelled May 20, 1975 · Crowe John T
Back to Cape Girardeau, MO