# Cancelled registrations: Mt Clemens, MI

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

Cancelled aircraft registrations in Mt Clemens, MI.

- [N2633M](https://openairdocs.org/deregistered/N2633M-2017-11-22.md): Piper PA-12 · S/N 12-1089 · Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Greater Detroit Avn Corp
- [N66944](https://openairdocs.org/deregistered/N66944-2014-11-07.md): Cessna 152 · S/N 15281679 · Cancelled Nov 7, 2014 · Registration expired, pending cancellation · Built 1978 · Almont Air Inc
- [N6714U](https://openairdocs.org/deregistered/N6714U-2013-09-26.md): Mooney M20C · S/N 2446 · Cancelled Sep 26, 2013 · Revoked, canceled · Built 1963 · Knoll Henry J
- [N69YP](https://openairdocs.org/deregistered/N69YP-2013-07-08.md): Kramer James Dennis KR-2 · S/N 001A · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Kramer James D
- [N3777Q](https://openairdocs.org/deregistered/N3777Q-2013-06-12.md): Scanlan John FW-190 · S/N 1 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Scanlan John
- [N13223](https://openairdocs.org/deregistered/N13223-2013-06-06.md): Mercury S-1 · S/N 52 · Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1932 · Wood Lawrence A
- [N91RC](https://openairdocs.org/deregistered/N91RC-2013-05-17.md): Carman SA700 · S/N 9 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Carman Richard W
- [N8529D](https://openairdocs.org/deregistered/N8529D-2013-03-07.md): Piper PA-22-150 · S/N 22-5760 · Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1957
- [N109PF](https://openairdocs.org/deregistered/N109PF-2012-10-11.md): Fletcher EOS/001 · S/N AI-0205 · Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Fletcher Patterson
- [N9716H](https://openairdocs.org/deregistered/N9716H-2012-09-12.md): Cessna T-50 · S/N 3655 · Cancelled Sep 12, 2012 · Revoked, canceled · Built 1942 · Cubs Flying Inc
- [N4102V](https://openairdocs.org/deregistered/N4102V-2012-06-04.md): Cessna 170 · S/N 18434 · Cancelled Jun 4, 2012 · Revoked, canceled · Built 1948 · Reese Delbert J
- [N9062Y](https://openairdocs.org/deregistered/N9062Y-2009-11-25.md): Cessna 310A · S/N 38085 · Cancelled Nov 25, 2009 · Triennial form not returned · Built 1958 · United States Navy Owner
- [N4962](https://openairdocs.org/deregistered/N4962-1998-01-17.md): Morrison BENSEN B-8M · S/N RJ8165 · Cancelled Jan 17, 1998 · Triennial form not returned · Kirst Henry
- [N3680L](https://openairdocs.org/deregistered/N3680L-1996-03-12.md): Cessna 172G · S/N 17253849 · Cancelled Mar 12, 1996 · Triennial form not returned · Meysing Helmut J
- [N51RD](https://openairdocs.org/deregistered/N51RD-1991-03-15.md): Dunbar Robinson A KR · S/N 2991 · Cancelled Mar 15, 1991 · Dunbar Robinson A
- [N50935](https://openairdocs.org/deregistered/N50935-1980-12-29.md): Cessna 150J · S/N 15069655 · Cancelled Dec 29, 1980 · Carter Leo M
- [N303E](https://openairdocs.org/deregistered/N303E-1978-04-24.md): Aero Commander 500 S · S/N 3092 · Cancelled Apr 24, 1978 · Tech Intl Engineering Inc
- [N71910](https://openairdocs.org/deregistered/N71910-1975-05-07.md): Luscombe 8A · S/N 3337 · Cancelled May 7, 1975 · Mcinnis William K
- [N95972](https://openairdocs.org/deregistered/N95972-1974-05-31.md): Taylorcraft BC12-D · S/N 8272 · Cancelled May 31, 1974 · Exported to Canada · Ripplinger Edward
- [N1653A](https://openairdocs.org/deregistered/N1653A-1972-08-16.md): Piper PA-20 · S/N 20-846 · Cancelled Aug 16, 1972 · Exported to Canada · Nichols Robert P
- [N89839](https://openairdocs.org/deregistered/N89839-1971-11-26.md): Cessna 140 · S/N 8888 · Cancelled Nov 26, 1971 · Exported to Canada · Naval Air Facility Detroit Flying Club
- [N33292](https://openairdocs.org/deregistered/N33292-1970-08-19.md): Piper J4F · S/N 4-1364 · Cancelled Aug 19, 1970 · Bel-Air Views
- [N2941C](https://openairdocs.org/deregistered/N2941C-1965-05-19.md): Beech T-34A · S/N 53-4101A · Cancelled May 19, 1965 · U S Air Force
- [N75983](https://openairdocs.org/deregistered/N75983-1959-07-16.md): Cessna T-50 · S/N 3330 · Cancelled Jul 16, 1959 · Ses Flying Service Inc
- [N6223M](https://openairdocs.org/deregistered/N6223M-1957-04-26.md): Stinson 108-3 · S/N 108-4223 · Cancelled Apr 26, 1957 · Exported to Canada · Chipman Vance J & Glenn G Moore
- [N707](https://openairdocs.org/deregistered/N707-1936-10-15.md): Packard Motor Car PACKARD · S/N A-1 · Cancelled Oct 15, 1936 · Hatzenbuhler Howard F

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

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