# Cancelled registrations: East St Louis, IL

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

Cancelled aircraft registrations in East St Louis, IL.

- [N24074](https://openairdocs.org/deregistered/N24074-2019-11-15.md): Taylorcraft BF · S/N 1609 · Cancelled Nov 15, 2019 · Revoked, canceled · Built 1940 · Greene Charles H
- [N22493](https://openairdocs.org/deregistered/N22493-2017-10-28.md): Aeronca 65-C · S/N C4419 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Midyett Omar
- [N59975](https://openairdocs.org/deregistered/N59975-2012-08-30.md): Consolidated Vultee BT-13A · S/N 2398 · Cancelled Aug 30, 2012 · Revoked, canceled · Built 1941 · Lakeside Airport Inc
- [N421SC](https://openairdocs.org/deregistered/N421SC-2012-06-12.md): Cessna 421B · S/N 421B-0225 · Cancelled Jun 12, 2012 · Revoked, canceled · Built 1971 · Corporate Air Inc
- [N8294R](https://openairdocs.org/deregistered/N8294R-2011-03-24.md): Bellanca 17-30A · S/N 30462 · Cancelled Mar 24, 2011 · Expired dealer · Built 1972 · Gordon Aviation Sales Inc
- [N64582](https://openairdocs.org/deregistered/N64582-2011-03-15.md): Fairchild M-62C(PT-23A) · S/N FC-196 · Cancelled Mar 15, 2011 · Expired dealer · Built 1944 · Lakeside Airport Inc
- [N9949T](https://openairdocs.org/deregistered/N9949T-1980-04-07.md): Piper PA-38-112 · S/N 3878A0257 · Cancelled Apr 7, 1980 · Exported to Canada · Bergmann D L
- [N76KS](https://openairdocs.org/deregistered/N76KS-1978-09-12.md): Cessna 421 · S/N 421-0121 · Cancelled Sep 12, 1978 · Gordon Aviation Sales Inc
- [N3537S](https://openairdocs.org/deregistered/N3537S-1976-09-03.md): Bell 47J-2A · S/N 3132 · Cancelled Sep 3, 1976 · Williams Helicopter Inc
- [N6085D](https://openairdocs.org/deregistered/N6085D-1975-06-23.md): Piper PA-22-150 · S/N 22-4739 · Cancelled Jun 23, 1975 · Exported to Canada · Ragany Paul A
- [N29099](https://openairdocs.org/deregistered/N29099-1974-06-07.md): Cessna U206C · S/N U206-1071 · Cancelled Jun 7, 1974 · Exported to Bolivia · Sisk Aviation Activities
- [N7076G](https://openairdocs.org/deregistered/N7076G-1974-05-03.md): Cessna 172K · S/N 17258776 · Cancelled May 3, 1974 · Exported to Canada · Sisk Aviation Activities Inc
- [N18698](https://openairdocs.org/deregistered/N18698-1974-03-28.md): Cessna 150L · S/N 15074050 · Cancelled Mar 28, 1974 · Exported to Canada · Built 1972 · Sisk Aviation Activities Inc
- [N1407K](https://openairdocs.org/deregistered/N1407K-1971-08-04.md): Luscombe 8A · S/N 4134 · Cancelled Aug 4, 1971 · Wings Aero Inc
- [N9091C](https://openairdocs.org/deregistered/N9091C-1965-05-22.md): Beech AT-7 · S/N 43-33332 · Cancelled May 22, 1965 · Saint Louis University
- [N9092C](https://openairdocs.org/deregistered/N9092C-1965-05-22.md): Beech AT-7 · S/N 43-50030 · Cancelled May 22, 1965 · Saint Louis University
- [N9862K](https://openairdocs.org/deregistered/N9862K-1961-07-17.md): Stinson 108-2 · S/N 108-2862 · Cancelled Jul 17, 1961 · Exported to Canada · Midyett Omar
- [N52227](https://openairdocs.org/deregistered/N52227-1959-09-25.md): Fairchild PT-23 · S/N 250 · Cancelled Sep 25, 1959 · Built 1946 · Midyett Omar
- [N8753H](https://openairdocs.org/deregistered/N8753H-1957-03-27.md): Temco D-16 · S/N NAV4-753 TN-15 · Cancelled Mar 27, 1957 · Walston Aircraft Sales And Service Inc
- [N4677A](https://openairdocs.org/deregistered/N4677A-1956-10-03.md): Cessna 180 · S/N 32274 · Cancelled Oct 3, 1956 · Exported to Mexico · Walston Aircraft Sales & Service
- [N9327A](https://openairdocs.org/deregistered/N9327A-1956-07-02.md): Cessna 190 · S/N 7519 · Cancelled Jul 2, 1956 · Exported to Papua New Guinea · Walston Aircraft Sales & Service Inc
- [N63620](https://openairdocs.org/deregistered/N63620-1956-03-05.md): Cessna T-50 · S/N 6282 · Cancelled Mar 5, 1956 · Saint Louis University Parks College
- [N69834](https://openairdocs.org/deregistered/N69834-1956-02-20.md): Consolidated Vultee BT-13A · S/N 9688 · Cancelled Feb 20, 1956 · Henderson George L
- [N60838](https://openairdocs.org/deregistered/N60838-1956-02-15.md): Cessna T-50 · S/N 6542 · Cancelled Feb 15, 1956 · Midyett Omar
- [N48385](https://openairdocs.org/deregistered/N48385-1955-11-21.md): Ryan Aeronautical ST3KR · S/N 1636 · Cancelled Nov 21, 1955 · Built 1944 · Gallagher Leo C
- [N92020](https://openairdocs.org/deregistered/N92020-1955-11-15.md): Piper J3C-65 · S/N 16453 · Cancelled Nov 15, 1955 · Gohn L G
- [N21953](https://openairdocs.org/deregistered/N21953-1955-10-19.md): Porterfield CP-50 · S/N 550 · Cancelled Oct 19, 1955 · Built 1939 · Liljeblad Harry Etal
- [N69855](https://openairdocs.org/deregistered/N69855-1955-10-14.md): Fairchild M-62A-3 · S/N FT-701 · Cancelled Oct 14, 1955 · Omar Midyett
- [N69876](https://openairdocs.org/deregistered/N69876-1955-10-14.md): Fairchild M-62A-3 · S/N FT-627 · Cancelled Oct 14, 1955 · Omar Midyett
- [N76382](https://openairdocs.org/deregistered/N76382-1955-10-12.md): Cessna 140 · S/N 10803 · Cancelled Oct 12, 1955 · Midyett Omar
- [N26444](https://openairdocs.org/deregistered/N26444-1955-10-11.md): Stinson 10 · S/N 7585 · Cancelled Oct 11, 1955 · Built 1940 · Midyett Omar
- [N2043N](https://openairdocs.org/deregistered/N2043N-1955-10-05.md): Cessna 140 · S/N 12279 · Cancelled Oct 5, 1955 · Midyett Omar
- [N2897E](https://openairdocs.org/deregistered/N2897E-1955-10-04.md): Aeronca 7AC · S/N 7AC-6480 · Cancelled Oct 4, 1955 · Omar Midyett
- [N48185](https://openairdocs.org/deregistered/N48185-1955-03-31.md): Boeing A75N1 · S/N 75-1076 · Cancelled Mar 31, 1955 · Built 1945 · Molitor Elmer F
- [N45391](https://openairdocs.org/deregistered/N45391-1954-10-25.md): Douglas DC3 · S/N 11633 · Cancelled Oct 25, 1954 · Built 1945 · Shaven Glenn O
- [N48322](https://openairdocs.org/deregistered/N48322-1952-02-25.md): Fairchild M-62A · S/N 9334AE · Cancelled Feb 25, 1952 · Built 1944 · Midyett Omar
- [N2602M](https://openairdocs.org/deregistered/N2602M-1951-09-07.md): Piper PA-12 · S/N 12-1064 · Cancelled Sep 7, 1951 · Usselman Harry C
- [N99854](https://openairdocs.org/deregistered/N99854-1950-02-16.md): Ercoupe 415-C · S/N 2477 · Cancelled Feb 16, 1950 · Parks Aircraft Sales And Service Inc
- [N2726E](https://openairdocs.org/deregistered/N2726E-1949-05-27.md): Aeronca 7AC · S/N 7AC-6307 · Cancelled May 27, 1949 · Midyett Omar
- [N2323H](https://openairdocs.org/deregistered/N2323H-1948-11-09.md): Ercoupe 415-C · S/N 2948 · Cancelled Nov 9, 1948 · Built 1946 · Parks Aircraft Sales And Service Inc
- [N2694E](https://openairdocs.org/deregistered/N2694E-1948-10-08.md): Aeronca 7AC · S/N 7AC-6274 · Cancelled Oct 8, 1948 · Midyett Omar
- [N8716](https://openairdocs.org/deregistered/N8716-1948-08-10.md): Travel Air B-4000 · S/N 1000 · Cancelled Aug 10, 1948 · Hart William L
- [N178K](https://openairdocs.org/deregistered/N178K-1948-04-29.md): Monocoupe 90 · S/N 512 · Cancelled Apr 29, 1948 · Built 1930 · Miller Raynond Wesely
- [N16431](https://openairdocs.org/deregistered/N16431-1940-03-30.md): Smith Pete SMITH 1 · S/N 1 · Cancelled Mar 30, 1940 · Built 1937 · Gregory Eugene
- [N428W](https://openairdocs.org/deregistered/N428W-1935-09-12.md): Curtiss Wright TRAVEL AIR 4000 · S/N 1419 · Cancelled Sep 12, 1935 · Parks Air College Inc
- [N12080](https://openairdocs.org/deregistered/N12080-1933-06-17.md): Joseph Patrick SECONDARY GLIDER · S/N 1313 · Cancelled Jun 17, 1933 · Joseph Patrick
- [N2654K](https://openairdocs.org/deregistered/N2654K-undated.md): Luscombe 8E · S/N 5381 · Cancellation date not recorded · Halstead George

## 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 = 'IL' AND d.registrant_city = 'EAST ST LOUIS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/IL/East%20St%20Louis/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
