# Cancelled registrations: Charlevoix, MI

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

Cancelled aircraft registrations in Charlevoix, MI.

- [N33TT](https://openairdocs.org/deregistered/N33TT-2022-01-08.md): Schleicher ASW-15 · S/N 15033 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1969 · Kemppainen Calvin R
- [N224HW](https://openairdocs.org/deregistered/N224HW-2020-09-16.md): Bellanca 17-30A · S/N 30317 · Cancelled Sep 16, 2020 · Registration expired, pending cancellation · Built 1970 · Wharton Howard S
- [N50998](https://openairdocs.org/deregistered/N50998-2014-12-17.md): Lawrence AM EAGLET · S/N 155 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Lawrence Philip J
- [N8645Z](https://openairdocs.org/deregistered/N8645Z-2013-03-07.md): Cessna TP206C · S/N P206-0445 · Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1967
- [N1161L](https://openairdocs.org/deregistered/N1161L-2012-06-07.md): Lake LA-4 · S/N 323 · Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Haveman Nancy L
- [N5553B](https://openairdocs.org/deregistered/N5553B-2010-06-29.md): Cessna 182 · S/N 33553 · Cancelled Jun 29, 2010 · Triennial form not returned · Built 1956 · Skydive Harbor Springs Inc
- [N8099T](https://openairdocs.org/deregistered/N8099T-1981-10-13.md): Cessna 175B · S/N 17556799 · Cancelled Oct 13, 1981 · Stoneham Ronald
- [N55573](https://openairdocs.org/deregistered/N55573-1977-07-08.md): Piper PA-32-260 · S/N 327300037 · Cancelled Jul 8, 1977 · Mcphillips Flying Service Inc
- [N7331K](https://openairdocs.org/deregistered/N7331K-1973-06-08.md): Piper PA-20 · S/N 20-238 · Cancelled Jun 8, 1973 · Exported to Canada · Weber Herbert D & Gail A Weber
- [N64058](https://openairdocs.org/deregistered/N64058-1970-09-24.md): Fairchild M-62C · S/N HO-410 · Cancelled Sep 24, 1970 · Built 1943 · Shadko Warren J
- [N46547](https://openairdocs.org/deregistered/N46547-1965-10-05.md): Fairchild M-62A · S/N T43-7343 · Cancelled Oct 5, 1965 · Jack R Paul
- [N6605M](https://openairdocs.org/deregistered/N6605M-1960-05-12.md): Stinson 108-3 · S/N 108-4605 · Cancelled May 12, 1960 · Exported to Canada · Built 1948 · Krahnke H O
- [N5784N](https://openairdocs.org/deregistered/N5784N-1960-04-26.md): Cessna 195 · S/N 7123 · Cancelled Apr 26, 1960 · Freedam Aircraft Engineering Corp
- [N61999](https://openairdocs.org/deregistered/N61999-1955-10-12.md): Cessna T-50 · S/N 2591 · Cancelled Oct 12, 1955 · Built 1942 · Mcphillips Flying Service
- [N4882M](https://openairdocs.org/deregistered/N4882M-1949-06-20.md): Piper PA-11 · S/N 11-409 · Cancelled Jun 20, 1949 · Built 1947 · Hansen William L
- [N9321](https://openairdocs.org/deregistered/N9321-1930-09-09.md): Nicholas Beazley NB-3 · S/N 23 · Cancelled Sep 9, 1930 · A P Stock

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

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