# Cancelled registrations: Milan, MI

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

Cancelled aircraft registrations in Milan, MI.

- [N867TG](https://openairdocs.org/deregistered/N867TG-2018-05-24.md): Tumbling Goose 12S · S/N 353 · Cancelled May 24, 2018 · First renewal notice · Built 2016 · Tumbling Goose LLC
- [N3998K](https://openairdocs.org/deregistered/N3998K-2018-03-23.md): Cameron Balloons US V-90 · S/N 5694 · Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1991 · Ritchie Martin K
- [N2929K](https://openairdocs.org/deregistered/N2929K-2018-01-18.md): Luscombe 8E · S/N 5656 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1947 · Mcdaniel Joseph C
- [N5603K](https://openairdocs.org/deregistered/N5603K-2017-07-14.md): Kolb FIRESTAR II · S/N F1081 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1995 · Szentmiklosi Mark T
- [N44378](https://openairdocs.org/deregistered/N44378-2017-05-31.md): Miller Thomas R SONEX · S/N M-0806 · Cancelled May 31, 2017 · Registration expired, pending cancellation · Miller Thomas R
- [N6229R](https://openairdocs.org/deregistered/N6229R-2013-07-09.md): Cessna 150E · S/N 15061529 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1965 · Fiser Geroge H
- [N233CB](https://openairdocs.org/deregistered/N233CB-2013-06-04.md): Cameron Balloons O-77 · S/N 639 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Ritchie Martin K
- [N758MD](https://openairdocs.org/deregistered/N758MD-2013-05-29.md): Cessna R172K · S/N R1723197 · Cancelled May 29, 2013 · Exported to Uruguay · Built 1979 · Palmieri Vincent
- [N110N](https://openairdocs.org/deregistered/N110N-1998-05-05.md): Universal TEMCO D-16 · S/N TTN40 · Cancelled May 5, 1998 · Ritchie Kay M
- [N9656T](https://openairdocs.org/deregistered/N9656T-1991-07-29.md): Cessna 210 · S/N 57456 · Cancelled Jul 29, 1991 · Talladay Keith R
- [N93A](https://openairdocs.org/deregistered/N93A-1991-06-27.md): Woods CHRISTENA MINI-COUPE · S/N 153 · Cancelled Jun 27, 1991 · Triennial form not returned · Woods J D
- [N71447](https://openairdocs.org/deregistered/N71447-1977-03-21.md): Luscombe 8A · S/N 2874 · Cancelled Mar 21, 1977 · Exported to Canada · Wagensomer Anthoney J
- [N21112](https://openairdocs.org/deregistered/N21112-1974-07-12.md): Cessna 182P · S/N 18261421 · Cancelled Jul 12, 1974 · Exported to Australia · Gem-Way Inc
- [N8385X](https://openairdocs.org/deregistered/N8385X-1974-01-29.md): Cessna 172C · S/N 17248885 · Cancelled Jan 29, 1974 · Exported to Canada · Simecek Keith
- [N8577C](https://openairdocs.org/deregistered/N8577C-1965-05-21.md): Piper PA-18A-135 · S/N 18-2731 · Cancelled May 21, 1965 · Johnston Peter E
- [N92735](https://openairdocs.org/deregistered/N92735-1961-07-13.md): Piper PA-12 · S/N 12-172 · Cancelled Jul 13, 1961 · Exported to Canada · Joseph Simecek
- [N85886](https://openairdocs.org/deregistered/N85886-1959-11-10.md): Aeronca 11AC · S/N 11AC-313 · Cancelled Nov 10, 1959 · Exported to Canada · Simecek Joseph & Roger Stevens DBA Aero Traders
- [N3233K](https://openairdocs.org/deregistered/N3233K-1958-05-07.md): Globe GC-1B · S/N 1226 · Cancelled May 7, 1958 · Exported to Canada · Joseph Simecek
- [N84339](https://openairdocs.org/deregistered/N84339-1956-11-30.md): Aeronca 7AC · S/N 7AC-3024 · Cancelled Nov 30, 1956 · Exported to Canada · Built 1946 · Aero Traders/Stevens Roger/Simecek Joseph Partners
- [N2542E](https://openairdocs.org/deregistered/N2542E-1954-11-03.md): Aeronca 7AC · S/N 7AC-6124 · Cancelled Nov 3, 1954 · Johnston Peeter E
- [N14468](https://openairdocs.org/deregistered/N14468-1949-08-05.md): Porterfield 35-70 · S/N 128 · Cancelled Aug 5, 1949 · Kanitz Harold
- [N180Y](https://openairdocs.org/deregistered/N180Y-1939-11-01.md): Waco Glider PRIMARY GLIDER · S/N 4080 · Cancelled Nov 1, 1939 · Built 1930 · Four Ace Glider Club
- [N5039](https://openairdocs.org/deregistered/N5039-1933-10-08.md): Waco GXE · S/N 1246 · Cancelled Oct 8, 1933 · Built 1918 · Johnston Peter E

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

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