# Cancelled registrations: Clarkston, MI

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

Cancelled aircraft registrations in Clarkston, MI.

- [N601PC](https://openairdocs.org/deregistered/N601PC-2025-05-18.md): Piper AEROSTAR 601P · S/N 61P-0554-238 · Cancelled May 18, 2025 · Built 1978 · Universal Investors LLC
- [N4020E](https://openairdocs.org/deregistered/N4020E-2020-04-03.md): Aeronca 11BC · S/N 11BC-107 · Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1947 · Latour Air Inc
- [N1406K](https://openairdocs.org/deregistered/N1406K-2018-05-03.md): Luscombe 8E · S/N 4133 · Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1946 · Foxx Daniel J
- [N88434](https://openairdocs.org/deregistered/N88434-2017-11-21.md): Piper J3C-65 · S/N 16052 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mcgee Charles J
- [N94WB](https://openairdocs.org/deregistered/N94WB-2017-07-12.md): Wood Daniel J SEAWIND 3000 · S/N 00045 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1999 · American Inspection Inc
- [N94582](https://openairdocs.org/deregistered/N94582-2016-09-06.md): Piper J3C-65 · S/N 9897 · Cancelled Sep 6, 2016 · Third renewal notice · Built 1943 · Michelsen Brent R
- [N912BC](https://openairdocs.org/deregistered/N912BC-2014-12-18.md): Evans William D MAXAIR DRIFTER XP503 · S/N DR 0243 · Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1986 · Evans William D
- [N15146](https://openairdocs.org/deregistered/N15146-2013-07-18.md): Balloon Works FIREFLY 7 · S/N 11041 · Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1981 · North Central Promotions Inc
- [N4060Q](https://openairdocs.org/deregistered/N4060Q-2013-03-07.md): Balloon Works FIREFLY 7 · S/N 7976 · Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1979 · Steele Howard D
- [N148JR](https://openairdocs.org/deregistered/N148JR-2013-01-31.md): Convair 240-27 · S/N 232 · Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Knight Richard
- [N9181P](https://openairdocs.org/deregistered/N9181P-2005-07-20.md): Piper PA-24-260 · S/N 24-4671 · Cancelled Jul 20, 2005 · Triennial form not returned · Built 1967 · Ylvisaker John R.
- [N6162T](https://openairdocs.org/deregistered/N6162T-2003-03-24.md): Cessna 150E · S/N 15060862 · Cancelled Mar 24, 2003 · Second triennial mailing, no response · Built 1964 · Johnson Ellsworth H
- [N132BC](https://openairdocs.org/deregistered/N132BC-1992-04-29.md): Cessna 320D · S/N 320D0130 · Cancelled Apr 29, 1992 · Triennial form not returned · Air-Land Surveys Inc
- [N3223H](https://openairdocs.org/deregistered/N3223H-1991-04-04.md): Michigan Airsports QUICKSILVER MX II · S/N 1106 · Cancelled Apr 4, 1991 · Triennial form not returned · Michigan Airsports Inc
- [N725M](https://openairdocs.org/deregistered/N725M-1985-10-16.md): Beech D55 · S/N TE-674 · Cancelled Oct 16, 1985 · Green Robert L
- [N617M](https://openairdocs.org/deregistered/N617M-1980-08-01.md): Beech E18S · S/N BA-322 · Cancelled Aug 1, 1980 · Green Robert L
- [N5XX](https://openairdocs.org/deregistered/N5XX-1978-05-10.md): Bradbury THORP T-18 · S/N 354 · Cancelled May 10, 1978 · Bradbury Robert P
- [N38652](https://openairdocs.org/deregistered/N38652-1967-06-02.md): Piper J5A · S/N 5-1037 · Cancelled Jun 2, 1967 · Exported to Canada · Morrow James W And/Or Jessie L Morrow

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

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