# Cancelled registrations: Grand Haven, MI

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

Cancelled aircraft registrations in Grand Haven, MI.

- [N993PT](https://openairdocs.org/deregistered/N993PT-2024-10-22.md): Aerofab LA-4 · S/N 341 · Cancelled Oct 22, 2024 · Built 1966 · Ashby Roland
- [N46545](https://openairdocs.org/deregistered/N46545-2023-10-12.md): Cessna 172K · S/N 17257341 · Cancelled Oct 12, 2023 · Exported to Guatemala · Built 1968 · Mdk Aviation LLC
- [N5383H](https://openairdocs.org/deregistered/N5383H-2018-01-05.md): Piper PA-16 · S/N 16-190 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Stornant Anthony F
- [N8154E](https://openairdocs.org/deregistered/N8154E-2015-05-19.md): Mooney M20A · S/N 1425 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1959 · Fortenbacher David J
- [N9075X](https://openairdocs.org/deregistered/N9075X-2014-11-24.md): Cessna 182D · S/N 18253475 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1961 · Maxfield Charles Z
- [N61731](https://openairdocs.org/deregistered/N61731-2013-08-05.md): Timm N2T-1 · S/N 357 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1946 · Milliman Ray G Jr
- [N8655S](https://openairdocs.org/deregistered/N8655S-2000-09-05.md): Cessna 150F · S/N 15061955 · Cancelled Sep 5, 2000 · Second triennial mailing, no response · Noga John J
- [N7199S](https://openairdocs.org/deregistered/N7199S-1994-02-16.md): Cessna 150H · S/N 15067899 · Cancelled Feb 16, 1994 · Triennial form not returned · Benaway Rita D
- [N3144](https://openairdocs.org/deregistered/N3144-1984-07-11.md): Pilgrim PITTS SPECIAL S-1 · S/N P2 · Cancelled Jul 11, 1984 · Administratively canceled · Roberts Joe
- [N6698](https://openairdocs.org/deregistered/N6698-1976-05-25.md): Paggeot B-8M · S/N 1 · Cancelled May 25, 1976 · Paggeot Norman A
- [N7564Y](https://openairdocs.org/deregistered/N7564Y-1971-12-20.md): Piper PA-30 · S/N 30-627 · Cancelled Dec 20, 1971 · National Products
- [N86143](https://openairdocs.org/deregistered/N86143-1969-05-22.md): Aeronca 11AC · S/N 11AC-573 · Cancelled May 22, 1969 · Exported to Canada · Built 1946 · Grand Haven Aviation Club Inc
- [N69838](https://openairdocs.org/deregistered/N69838-1956-02-20.md): Fairchild M-62C · S/N 1493-AE · Cancelled Feb 20, 1956 · Paggeot Norman A
- [N63665](https://openairdocs.org/deregistered/N63665-1955-04-01.md): Fairchild M-62A · S/N T42-3406 · Cancelled Apr 1, 1955 · Presley Randolph J
- [N1230N](https://openairdocs.org/deregistered/N1230N-1952-10-21.md): Curtiss P40E · S/N 18730 · Cancelled Oct 21, 1952 · De Santo James C
- [N54487](https://openairdocs.org/deregistered/N54487-1948-12-03.md): Cessna T-50 · S/N 5371 · Cancelled Dec 3, 1948 · Camfield Manufacturing Co

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

This list as a web page: https://openairdocs.org/faa-place/MI/Grand%20Haven/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
