# Cancelled registrations: Allen Park, MI

A list on [Allen Park, MI](https://openairdocs.org/faa-place/MI/Allen%20Park.md).

Cancelled aircraft registrations in Allen Park, MI.

- [N5321E](https://openairdocs.org/deregistered/N5321E-2021-03-10.md): Beech K35 · S/N D-5801 · Cancelled Mar 10, 2021 · Registration expired, pending cancellation · Built 1959 · Walter Lon D
- [N31944](https://openairdocs.org/deregistered/N31944-2019-11-29.md): Aeronca 65-LB · S/N L12211 · Cancelled Nov 29, 2019 · Revoked, canceled · Built 1941 · Brant Robert E
- [N807LK](https://openairdocs.org/deregistered/N807LK-2018-08-10.md): Levon G King VANS RV9A · S/N 91528 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 2015 · King Levon G
- [N31533](https://openairdocs.org/deregistered/N31533-2018-03-23.md): Stinson 10A · S/N 7783 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1941 · Marcille Joseph L
- [N3209R](https://openairdocs.org/deregistered/N3209R-2015-05-06.md): Piper PA-28R-180 · S/N 28R-31131 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1969 · Michalski Michael J
- [N1379F](https://openairdocs.org/deregistered/N1379F-2013-09-10.md): Cessna 172G · S/N 17254874 · Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1966 · Hooper Andrew S
- [N607MS](https://openairdocs.org/deregistered/N607MS-2013-04-09.md): Stimac Michael Jon GLASAIR · S/N 607 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Stimac Michael J
- [N4800C](https://openairdocs.org/deregistered/N4800C-2012-12-13.md): Cessna 210N · S/N 21063633 · Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Humphreys Robert
- [N6032](https://openairdocs.org/deregistered/N6032-2012-10-02.md): Messer B-8M · S/N 1 · Cancelled Oct 2, 2012 · Sale reported, pending cancellation · Built 1971
- [N4513H](https://openairdocs.org/deregistered/N4513H-2009-01-12.md): Mooney M20J · S/N 24-0757 · Cancelled Jan 12, 2009 · Triennial form not returned · Built 1978 · Flykappa Sales LLC
- [N641D](https://openairdocs.org/deregistered/N641D-1993-11-03.md): Verriest Robert C DRAGONFLY · S/N 005 · Cancelled Nov 3, 1993 · Triennial form not returned · Verriest Robert C
- [N3036T](https://openairdocs.org/deregistered/N3036T-1971-09-16.md): Cessna 320C · S/N 320C-0036 · Cancelled Sep 16, 1971 · Davis Herbert A
- [N60066](https://openairdocs.org/deregistered/N60066-1971-07-02.md): Cessna 150J · S/N 15070049 · Cancelled Jul 2, 1971 · Exported to Canada · Bledsoe John A DBA Michigan Aircraft Rental Co
- [N3353V](https://openairdocs.org/deregistered/N3353V-1971-04-23.md): Beech 35 · S/N D-817 · Cancelled Apr 23, 1971 · Clark F L & A J Markyvech
- [N53484](https://openairdocs.org/deregistered/N53484-1963-08-16.md): Cessna T-50 · S/N 3710 · Cancelled Aug 16, 1963 · Lambarth Paul S
- [N2543H](https://openairdocs.org/deregistered/N2543H-1959-07-24.md): Ercoupe 415-C · S/N 3168 · Cancelled Jul 24, 1959 · Exported to Canada · Built 1946 · Welch Edward
- [N50807](https://openairdocs.org/deregistered/N50807-1955-10-11.md): Fairchild M-62A · S/N 7523AE · Cancelled Oct 11, 1955 · Hinton William E
- [N9560H](https://openairdocs.org/deregistered/N9560H-1948-01-23.md): Fairchild PT-26A · S/N FV-249 · Cancelled Jan 23, 1948 · Daniels William H

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

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