# Cancelled registrations: Grand Blanc, MI

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

Cancelled aircraft registrations in Grand Blanc, MI.

- [N1199P](https://openairdocs.org/deregistered/N1199P-2022-07-30.md): Lentsch Florenz J KR-2 · S/N 7029 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1996 · Ellwood Jeremy D
- [N509NX](https://openairdocs.org/deregistered/N509NX-2022-07-12.md): Piper PA-34-220T · S/N 3449509 · Cancelled Jul 12, 2022 · Exported to Romania · Built 2018 · Pjd Holdings LLC
- [N5806J](https://openairdocs.org/deregistered/N5806J-2021-10-05.md): Cessna A185E · S/N 18501775 · Cancelled Oct 5, 2021 · Third renewal notice · Built 1970 · Mainprize P Anthony
- [N7518H](https://openairdocs.org/deregistered/N7518H-2020-02-28.md): Cameron Balloons US N-90 · S/N 5774 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1991 · Pethink Ronald Jr
- [N8739D](https://openairdocs.org/deregistered/N8739D-2018-05-21.md): Piper PA-22-160 · S/N 22-5921 · Cancelled May 21, 2018 · Revoked, canceled · Built 1958 · Taylor Charles A
- [N5705](https://openairdocs.org/deregistered/N5705-2018-04-05.md): Lockheed ELECTRA 10-A · S/N 1059 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1936 · Universal Air Leasing Company
- [N894D](https://openairdocs.org/deregistered/N894D-2018-03-16.md): Stinson 108-2 · S/N 108-2894 · Cancelled Mar 16, 2018 · Revoked, canceled · Built 1947 · Starr Raymond J
- [N7987E](https://openairdocs.org/deregistered/N7987E-2015-07-20.md): Cessna 150 · S/N 17787 · Cancelled Jul 20, 2015 · Built 1959 · Carr Thomas W
- [N2059F](https://openairdocs.org/deregistered/N2059F-2014-12-17.md): Balloon Works FIREFLY 6 · S/N 630 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1976 · Titanic Balloon Port
- [N905BE](https://openairdocs.org/deregistered/N905BE-2013-09-17.md): Evans William D PIONEER FLIGHT STAR · S/N 458 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1984 · Hurley James L
- [N8468M](https://openairdocs.org/deregistered/N8468M-2013-09-10.md): Cessna A150K · S/N A15000168 · Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1970 · Digard Stanley Jr
- [N15GD](https://openairdocs.org/deregistered/N15GD-2013-08-13.md): Aerostar International RAVEN S57-A · S/N S57A-3063 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1989 · Dennis Sean M
- [N4491M](https://openairdocs.org/deregistered/N4491M-2013-07-19.md): Piper J3C-65 · S/N 22611 · Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1947 · Murphy Laverne H
- [N167LF](https://openairdocs.org/deregistered/N167LF-2013-07-05.md): Maule MX-7-160 · S/N 19013C · Cancelled Jul 5, 2013 · Exported to Russia · King David W
- [N18VB](https://openairdocs.org/deregistered/N18VB-2013-04-11.md): Sliwa SCHREDER HP-18 · S/N 51 · Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1975 · Owen Robert E
- [N2980U](https://openairdocs.org/deregistered/N2980U-2012-09-10.md): Cameron Balloons N-77 · S/N 5078 · Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1984
- [N2097F](https://openairdocs.org/deregistered/N2097F-2012-08-23.md): Balloon Works FIREFLY 6 · S/N 631 · Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1976 · Thornton James J DBA
- [N47855](https://openairdocs.org/deregistered/N47855-2012-08-07.md): Taylorcraft DC-65 · S/N L5074 · Cancelled Aug 7, 2012 · Revoked, canceled · Built 1943 · Coppens Walter H
- [N1944R](https://openairdocs.org/deregistered/N1944R-2009-07-10.md): Raven Vulcoon R S-50A · S/N S50A-151 · Cancelled Jul 10, 2009 · Registration revoked · Built 1970 · Thornton James J
- [N5309A](https://openairdocs.org/deregistered/N5309A-2004-12-17.md): Cameron Balloons US N-77 · S/N 6159 · Cancelled Dec 17, 2004 · Second triennial mailing, no response · Built 1998 · General Motors Corporation
- [N4588F](https://openairdocs.org/deregistered/N4588F-1969-05-09.md): Cessna 185 · S/N 185-1095 · Cancelled May 9, 1969 · Exported to Canada · Hovey William G
- [N3355E](https://openairdocs.org/deregistered/N3355E-1954-10-28.md): Aeronca 11AC · S/N 11AC-1687 · Cancelled Oct 28, 1954 · Exported to Canada · Dunkel Loren Kenneth
- [N47098](https://openairdocs.org/deregistered/N47098-1950-07-10.md): Fairchild M-62A · S/N T43-7303 · Cancelled Jul 10, 1950 · Dupraw Rohdy

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

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