# Cancelled registrations: St Charles, MO

A list on [St Charles, MO](https://openairdocs.org/faa-place/MO/St%20Charles.md).

Cancelled aircraft registrations in St Charles, MO.

- [N3068C](https://openairdocs.org/deregistered/N3068C-2023-02-04.md): Beech K35 · S/N D-5732 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1958 · Midwest Model & Supply Co Inc
- [N7500B](https://openairdocs.org/deregistered/N7500B-2019-05-15.md): Aeronca 7FC · S/N 7FC8 · Cancelled May 15, 2019 · Revoked, pending cancellation · Built 1957 · Blodgett Delmar G
- [N2667H](https://openairdocs.org/deregistered/N2667H-2017-05-22.md): Schweizer SGS 2-33A · S/N 457 · Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1976 · St Charles Flying Service Inc
- [N36DJ](https://openairdocs.org/deregistered/N36DJ-2017-04-04.md): Johnson Donald L REBEL 300 · S/N S20-880020 · Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1988 · Johnson Donald L
- [N67463](https://openairdocs.org/deregistered/N67463-2017-02-22.md): Cessna 152 · S/N 15281849 · Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Willbrand Douglas W
- [N1607V](https://openairdocs.org/deregistered/N1607V-2013-10-23.md): Cessna 140 · S/N 13779 · Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1947 · West Dale A
- [N30TT](https://openairdocs.org/deregistered/N30TT-2013-06-04.md): Bellanca 17-31ATC · S/N 31033 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Kohler David D
- [N9917T](https://openairdocs.org/deregistered/N9917T-2013-05-30.md): Piper PA-38-112 · S/N 38-78A0247 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1978 · Kiernan Richard E
- [N1002J](https://openairdocs.org/deregistered/N1002J-2013-04-10.md): Aero Commander 112 · S/N 8 · Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1972 · Blalock James L
- [N29D](https://openairdocs.org/deregistered/N29D-2013-02-21.md): Smith-Davenport BB 1 CHICKADEE · S/N GC-162 · Cancelled Feb 21, 2013 · Sale reported, pending cancellation
- [N2151P](https://openairdocs.org/deregistered/N2151P-2013-02-07.md): Piper PA-23 · S/N 23-753 · Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1956 · Munson David J
- [N2283W](https://openairdocs.org/deregistered/N2283W-2013-02-07.md): Counts-Robert BENSEN B8M · S/N RWC-1 · Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1978 · Barklag Allen
- [N2804](https://openairdocs.org/deregistered/N2804-2012-09-21.md): Carey VOLKSPLANE VP-1 · S/N MAC2134 · Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1973 · Burnside Jack W
- [N701PT](https://openairdocs.org/deregistered/N701PT-2009-10-01.md): Piper PA-31T1 · S/N 31T-8004008 · Cancelled Oct 1, 2009 · Triennial form not returned · Built 1979 · Natoli Engrg Co Inc
- [N77NC](https://openairdocs.org/deregistered/N77NC-2009-09-08.md): Skypower GBN-41-1000 · S/N 115 · Cancelled Sep 8, 2009 · Triennial form undeliverable · Buckles Lyndell G
- [N2578H](https://openairdocs.org/deregistered/N2578H-2008-02-15.md): Engineering & Research ERCOUPE 415-C · S/N 3203 · Cancelled Feb 15, 2008 · Second triennial form not returned · Built 1946 · Horstman William A
- [N5318R](https://openairdocs.org/deregistered/N5318R-2004-04-23.md): Cessna 172F · S/N 17252842 · Cancelled Apr 23, 2004 · Triennial form not returned · Built 1965 · Noah Richard D
- [N11458](https://openairdocs.org/deregistered/N11458-2003-05-21.md): Cessna 150L · S/N 15075437 · Cancelled May 21, 2003 · Second triennial mailing, no response · Built 1973 · Carpenter James L
- [N611AB](https://openairdocs.org/deregistered/N611AB-2000-04-14.md): Barklage Allen REVELUTION MINI 500 · S/N 0294 · Cancelled Apr 14, 2000 · Barklage Allen G
- [N2635U](https://openairdocs.org/deregistered/N2635U-1997-03-17.md): Cessna 172D · S/N 17250235 · Cancelled Mar 17, 1997 · Triennial form not returned · Kohler David D
- [N6236L](https://openairdocs.org/deregistered/N6236L-1996-07-19.md): American AA-1 · S/N AA10436 · Cancelled Jul 19, 1996 · Triennial form not returned · Carriker Millard D
- [N515D](https://openairdocs.org/deregistered/N515D-1996-03-12.md): Fallbeck Richard DYKE DELTA JD2 · S/N 1144 · Cancelled Mar 12, 1996 · Triennial form not returned · Fallbeck Richard E
- [N109DA](https://openairdocs.org/deregistered/N109DA-1995-02-27.md): Bell-Agri Helicopter OH-13H · S/N 2308 · Cancelled Feb 27, 1995 · Triennial form not returned · St Charles Co Dis Preparedness Offic
- [N109DP](https://openairdocs.org/deregistered/N109DP-1995-02-27.md): Bell-Agri Helicopter OH-13H · S/N 2343 · Cancelled Feb 27, 1995 · Triennial form not returned · St Charles Co Dis Preparedness Offic
- [N2256L](https://openairdocs.org/deregistered/N2256L-1994-02-09.md): Beech C24R · S/N MC456 · Cancelled Feb 9, 1994 · Triennial form not returned · Blanton Ben F
- [N5380U](https://openairdocs.org/deregistered/N5380U-1993-09-22.md): Rawlings James E RAND/ROBINSON KR 2 · S/N 102385 · Cancelled Sep 22, 1993 · Triennial form not returned · Rawlings James E
- [N49554](https://openairdocs.org/deregistered/N49554-1992-02-19.md): Cessna 152 · S/N 15281310 · Cancelled Feb 19, 1992 · Triennial form not returned · Klutenkamper Brian L
- [N8498W](https://openairdocs.org/deregistered/N8498W-1991-08-02.md): Piper PA-28-180 · S/N 282746 · Cancelled Aug 2, 1991 · Buehrle Raymond D
- [N430X](https://openairdocs.org/deregistered/N430X-1991-01-23.md): Ebert Randall Lee SONERAI IT · S/N 001 · Cancelled Jan 23, 1991 · Ebert Randall L
- [N7993C](https://openairdocs.org/deregistered/N7993C-1986-01-02.md): Piper PA-28-151 · S/N 28-7615070 · Cancelled Jan 2, 1986 · Alpha Aviation Ltd
- [N737FW](https://openairdocs.org/deregistered/N737FW-1984-11-07.md): Cessna 172N · S/N 17269392 · Cancelled Nov 7, 1984 · Exported to Australia · Kiernan Richard E
- [N39591](https://openairdocs.org/deregistered/N39591-1983-03-15.md): Piper PA-32RT-300T · S/N 32R7887115 · Cancelled Mar 15, 1983 · Built 1978 · Ellena Jim R
- [N8240S](https://openairdocs.org/deregistered/N8240S-1981-09-10.md): Cessna 150F · S/N 15061840 · Cancelled Sep 10, 1981 · Scauzzo Anthony J
- [N1610H](https://openairdocs.org/deregistered/N1610H-1981-03-12.md): Cessna 177RG · S/N 177RG0783 · Cancelled Mar 12, 1981 · Built 1975 · St Charles Flying Service Inc
- [N45559](https://openairdocs.org/deregistered/N45559-1977-07-07.md): Cessna 150M · S/N 15076970 · Cancelled Jul 7, 1977 · Built 1975 · Linberg Charles C
- [N7054D](https://openairdocs.org/deregistered/N7054D-1977-04-01.md): Piper PA-22-150 · S/N 22-4951 · Cancelled Apr 1, 1977 · Scauzzo Anthony J
- [N57000](https://openairdocs.org/deregistered/N57000-1976-04-13.md): Piper PA-28-140 · S/N 28-7425082 · Cancelled Apr 13, 1976 · Exported to Canada · Globe Aviation Inc
- [N3846Q](https://openairdocs.org/deregistered/N3846Q-1975-07-17.md): Cessna 172L · S/N 17259946 · Cancelled Jul 17, 1975 · Exported to Canada · St Charles Flying Service Inc
- [N42666](https://openairdocs.org/deregistered/N42666-1974-12-11.md): Piper PA-28-151 · S/N 28-7415395 · Cancelled Dec 11, 1974 · Built 1974 · Bruere John T
- [N8344M](https://openairdocs.org/deregistered/N8344M-1973-06-25.md): Cessna A150K · S/N A15000044 · Cancelled Jun 25, 1973 · St Charles Flying Service Inc
- [N4776T](https://openairdocs.org/deregistered/N4776T-1971-06-08.md): Osborne-Posey O-P COUGAR · S/N 1 · Cancelled Jun 8, 1971 · Osborne William H
- [N4128M](https://openairdocs.org/deregistered/N4128M-1971-02-08.md): Piper PA-12 · S/N 12-3025 · Cancelled Feb 8, 1971 · Built 1947 · Air Flite Flying Service Inc
- [N718C](https://openairdocs.org/deregistered/N718C-1971-01-06.md): Stinson 108-3 · S/N 1083718 · Cancelled Jan 6, 1971 · Caton Hugh
- [N22660](https://openairdocs.org/deregistered/N22660-1970-06-30.md): Taylorcraft BL · S/N 1307 · Cancelled Jun 30, 1970 · Built 1939 · Engel Donald Emir
- [N7091D](https://openairdocs.org/deregistered/N7091D-1965-05-21.md): Piper PA-18-150 · S/N 18-5579 · Cancelled May 21, 1965 · Air Flight Flying Service
- [N35151](https://openairdocs.org/deregistered/N35151-1965-05-20.md): Piper J3F-65 · S/N 6169 · Cancelled May 20, 1965 · Air Flite Flying Service Inc
- [N17018](https://openairdocs.org/deregistered/N17018-1955-10-18.md): Commonwealth REARWIN 7000 · S/N 509-S · Cancelled Oct 18, 1955 · Built 1936 · Hellmer Eugene A
- [N50153](https://openairdocs.org/deregistered/N50153-1951-11-15.md): Fairchild M-62A · S/N T42-1415 · Cancelled Nov 15, 1951 · Pierce Robert H And Pohlman Rudolph C
- [N50095](https://openairdocs.org/deregistered/N50095-1950-05-05.md): Piper J3F-65 · S/N 10747 · Cancelled May 5, 1950 · Doris L Worful

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-place/MO/St%20Charles/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
