# Cancelled registrations: Mundelein, IL

A list on [Mundelein, IL](https://openairdocs.org/faa-place/IL/Mundelein.md).

Cancelled aircraft registrations in Mundelein, IL.

- [N260GK](https://openairdocs.org/deregistered/N260GK-2023-12-06.md): Piper PA-32-260 · S/N 32-1073 · Cancelled Dec 6, 2023 · Exported to Canada · Built 1968 · Ye Weihang
- [N24044](https://openairdocs.org/deregistered/N24044-2018-03-23.md): Taylorcraft BL · S/N 1579 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1939 · Hannaford Foster Jr
- [N2629B](https://openairdocs.org/deregistered/N2629B-2017-07-18.md): Wagner Nathan D HART BIRD II · S/N HB2-004 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Wagner Nathan D
- [N203FS](https://openairdocs.org/deregistered/N203FS-2015-05-20.md): Harmenings High Flyers STANDARD · S/N HHF5857 · Cancelled May 20, 2015 · Registration pending, canceled · Built 1997
- [N2015F](https://openairdocs.org/deregistered/N2015F-2014-09-10.md): Balloon Works FIREFLY 7 · S/N 190 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Strand C R
- [N549LS](https://openairdocs.org/deregistered/N549LS-2014-07-09.md): Flight Design CTLS · S/N 07-11-19 · Cancelled Jul 9, 2014 · Second renewal notice · Built 2007 · Mayworm Daniel E
- [N91BD](https://openairdocs.org/deregistered/N91BD-2013-09-18.md): Bede James R BD-9 · S/N 0001 · Cancelled Sep 18, 2013 · Registration expired, pending cancellation · Built 1983 · Bede James R
- [N104AP](https://openairdocs.org/deregistered/N104AP-2013-09-12.md): Raven S55A · S/N S55A-749 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1981 · Fay Peter C
- [N408TC](https://openairdocs.org/deregistered/N408TC-2013-07-30.md): Thunder & Colt Airborne Amer AX6-65S1 · S/N 2157USA · Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1992
- [N6063V](https://openairdocs.org/deregistered/N6063V-2013-04-10.md): Piper PA-18 · S/N 18-921 · Cancelled Apr 10, 2013 · Revoked, canceled · Sky Soaring Inc
- [N83HS](https://openairdocs.org/deregistered/N83HS-2013-04-02.md): Sorensen Harvey L QUICKIE Q-2 · S/N 2458 · Cancelled Apr 2, 2013 · Built 1983 · Butler William G
- [N76DP](https://openairdocs.org/deregistered/N76DP-2013-02-26.md): Piccard AX-6 · S/N 723 · Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1974
- [N1700U](https://openairdocs.org/deregistered/N1700U-2012-08-10.md): Piper PA-23-160 · S/N 23-1346 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1958 · Production Group Alpha Inc
- [N1738](https://openairdocs.org/deregistered/N1738-2012-08-10.md): Bensen B-8M · S/N 1 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1968 · Garrett Paul E
- [N47552](https://openairdocs.org/deregistered/N47552-2012-08-06.md): Fairchild 24 G · S/N 2916 · Cancelled Aug 6, 2012 · Revoked, canceled · Built 1937 · Henrotte Emil J
- [N3988B](https://openairdocs.org/deregistered/N3988B-2005-03-15.md): Smith/Forrest ROTEC RALLY 3A · S/N 25320 · Cancelled Mar 15, 2005 · Second triennial mailing, no response · Built 1983 · Smith David M
- [N47EE](https://openairdocs.org/deregistered/N47EE-2004-04-29.md): Beech 35 · S/N D-788 · Cancelled Apr 29, 2004 · Triennial form not returned · Built 1947 · Weidner Brian T
- [N9726A](https://openairdocs.org/deregistered/N9726A-1992-01-03.md): Lotter-Robert SONERAI · S/N 00116 · Cancelled Jan 3, 1992 · Triennial form not returned · Lotter Robert F
- [N83262](https://openairdocs.org/deregistered/N83262-1991-02-14.md): Piper PA-34-220T · S/N 348133004 · Cancelled Feb 14, 1991 · Exported to Italy · Ocker Larry W
- [N3912H](https://openairdocs.org/deregistered/N3912H-1976-06-24.md): Engineering & Research ERCOUPE 415-CD · S/N 4613 · Cancelled Jun 24, 1976 · Crunk Thomas C
- [N2746C](https://openairdocs.org/deregistered/N2746C-1974-09-26.md): Cessna 170B · S/N 26290 · Cancelled Sep 26, 1974 · Exported to Canada · Ostrowski John V & Bateman John R
- [N3746E](https://openairdocs.org/deregistered/N3746E-1973-08-22.md): Aeronca 11AC · S/N 11AC-S1 · Cancelled Aug 22, 1973 · Barlow Richard E
- [N3305A](https://openairdocs.org/deregistered/N3305A-1970-09-04.md): Piper PA-22-135 · S/N 22-1578 · Cancelled Sep 4, 1970 · James J Beranek

## 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 = 'MUNDELEIN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/IL/Mundelein/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.