OpenAirDocs.org
St Charles, MO

Cancelled registrations · 49

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 = 'ST CHARLES'
  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.

N3068CBeech K35 · S/N D-5732Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1958 · Midwest Model & Supply Co IncN7500BAeronca 7FC · S/N 7FC8Cancelled May 15, 2019 · Revoked, pending cancellation · Built 1957 · Blodgett Delmar GN2667HSchweizer SGS 2-33A · S/N 457Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1976 · St Charles Flying Service IncN36DJJohnson Donald L REBEL 300 · S/N S20-880020Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1988 · Johnson Donald LN67463Cessna 152 · S/N 15281849Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Willbrand Douglas WN1607VCessna 140 · S/N 13779Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1947 · West Dale AN30TTBellanca 17-31ATC · S/N 31033Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Kohler David DN9917TPiper PA-38-112 · S/N 38-78A0247Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1978 · Kiernan Richard EN1002JAero Commander 112 · S/N 8Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1972 · Blalock James LN29DSmith-Davenport BB 1 CHICKADEE · S/N GC-162Cancelled Feb 21, 2013 · Sale reported, pending cancellationN2151PPiper PA-23 · S/N 23-753Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1956 · Munson David JN2283WCounts-Robert BENSEN B8M · S/N RWC-1Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1978 · Barklag AllenN2804Carey VOLKSPLANE VP-1 · S/N MAC2134Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1973 · Burnside Jack WN701PTPiper PA-31T1 · S/N 31T-8004008Cancelled Oct 1, 2009 · Triennial form not returned · Built 1979 · Natoli Engrg Co IncN77NCSkypower GBN-41-1000 · S/N 115Cancelled Sep 8, 2009 · Triennial form undeliverable · Buckles Lyndell GN2578HEngineering & Research ERCOUPE 415-C · S/N 3203Cancelled Feb 15, 2008 · Second triennial form not returned · Built 1946 · Horstman William AN5318RCessna 172F · S/N 17252842Cancelled Apr 23, 2004 · Triennial form not returned · Built 1965 · Noah Richard DN11458Cessna 150L · S/N 15075437Cancelled May 21, 2003 · Second triennial mailing, no response · Built 1973 · Carpenter James LN611ABBarklage Allen REVELUTION MINI 500 · S/N 0294Cancelled Apr 14, 2000 · Barklage Allen GN2635UCessna 172D · S/N 17250235Cancelled Mar 17, 1997 · Triennial form not returned · Kohler David DN6236LAmerican AA-1 · S/N AA10436Cancelled Jul 19, 1996 · Triennial form not returned · Carriker Millard DN515DFallbeck Richard DYKE DELTA JD2 · S/N 1144Cancelled Mar 12, 1996 · Triennial form not returned · Fallbeck Richard EN109DABell-Agri Helicopter OH-13H · S/N 2308Cancelled Feb 27, 1995 · Triennial form not returned · St Charles Co Dis Preparedness OfficN109DPBell-Agri Helicopter OH-13H · S/N 2343Cancelled Feb 27, 1995 · Triennial form not returned · St Charles Co Dis Preparedness OfficN2256LBeech C24R · S/N MC456Cancelled Feb 9, 1994 · Triennial form not returned · Blanton Ben FN5380URawlings James E RAND/ROBINSON KR 2 · S/N 102385Cancelled Sep 22, 1993 · Triennial form not returned · Rawlings James EN49554Cessna 152 · S/N 15281310Cancelled Feb 19, 1992 · Triennial form not returned · Klutenkamper Brian LN8498WPiper PA-28-180 · S/N 282746Cancelled Aug 2, 1991 · Buehrle Raymond DN430XEbert Randall Lee SONERAI IT · S/N 001Cancelled Jan 23, 1991 · Ebert Randall LN7993CPiper PA-28-151 · S/N 28-7615070Cancelled Jan 2, 1986 · Alpha Aviation LtdN737FWCessna 172N · S/N 17269392Cancelled Nov 7, 1984 · Exported to Australia · Kiernan Richard EN39591Piper PA-32RT-300T · S/N 32R7887115Cancelled Mar 15, 1983 · Built 1978 · Ellena Jim RN8240SCessna 150F · S/N 15061840Cancelled Sep 10, 1981 · Scauzzo Anthony JN1610HCessna 177RG · S/N 177RG0783Cancelled Mar 12, 1981 · Built 1975 · St Charles Flying Service IncN45559Cessna 150M · S/N 15076970Cancelled Jul 7, 1977 · Built 1975 · Linberg Charles CN7054DPiper PA-22-150 · S/N 22-4951Cancelled Apr 1, 1977 · Scauzzo Anthony JN57000Piper PA-28-140 · S/N 28-7425082Cancelled Apr 13, 1976 · Exported to Canada · Globe Aviation IncN3846QCessna 172L · S/N 17259946Cancelled Jul 17, 1975 · Exported to Canada · St Charles Flying Service IncN42666Piper PA-28-151 · S/N 28-7415395Cancelled Dec 11, 1974 · Built 1974 · Bruere John TN8344MCessna A150K · S/N A15000044Cancelled Jun 25, 1973 · St Charles Flying Service IncN4776TOsborne-Posey O-P COUGAR · S/N 1Cancelled Jun 8, 1971 · Osborne William HN4128MPiper PA-12 · S/N 12-3025Cancelled Feb 8, 1971 · Built 1947 · Air Flite Flying Service IncN718CStinson 108-3 · S/N 1083718Cancelled Jan 6, 1971 · Caton HughN22660Taylorcraft BL · S/N 1307Cancelled Jun 30, 1970 · Built 1939 · Engel Donald EmirN7091DPiper PA-18-150 · S/N 18-5579Cancelled May 21, 1965 · Air Flight Flying ServiceN35151Piper J3F-65 · S/N 6169Cancelled May 20, 1965 · Air Flite Flying Service IncN17018Commonwealth REARWIN 7000 · S/N 509-SCancelled Oct 18, 1955 · Built 1936 · Hellmer Eugene AN50153Fairchild M-62A · S/N T42-1415Cancelled Nov 15, 1951 · Pierce Robert H And Pohlman Rudolph CN50095Piper J3F-65 · S/N 10747Cancelled May 5, 1950 · Doris L Worful
Back to St Charles, MO