# Cancelled registrations: St Joseph, MI

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

Cancelled aircraft registrations in St Joseph, MI.

- [N46635](https://openairdocs.org/deregistered/N46635-2020-02-28.md): Aeronca 0-58B · S/N 13724 · Cancelled Feb 28, 2020 · Revoked, canceled · Built 1944 · Pullins Gordon R
- [N3243G](https://openairdocs.org/deregistered/N3243G-2019-04-22.md): North American SNJ-5 · S/N 90641 · Cancelled Apr 22, 2019 · Revoked, canceled · Built 1942 · Appliance Buyers Credit Corp
- [N9677C](https://openairdocs.org/deregistered/N9677C-2017-02-13.md): North American T-28A · S/N 49-1650A · Cancelled Feb 13, 2017 · Revoked, canceled · Appliance Buyers Credit Corp
- [N6308T](https://openairdocs.org/deregistered/N6308T-2013-08-05.md): North American F-51D · S/N 44-72382 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1944 · Appliance Buyers Credit Corporation
- [N2949X](https://openairdocs.org/deregistered/N2949X-2013-07-15.md): Cessna 177 · S/N 17700349 · Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 1967 · Kuechenmeister Fred R
- [N8139C](https://openairdocs.org/deregistered/N8139C-1997-11-17.md): Piper PA-28R-200 · S/N 28R7635131 · Cancelled Nov 17, 1997 · Triennial form not returned · Taildragger Flyers Inc
- [N305BJ](https://openairdocs.org/deregistered/N305BJ-1991-04-03.md): Billings J O/White C E AVID FLYER · S/N 305 · Cancelled Apr 3, 1991 · Triennial form not returned · Billings James O
- [N4620T](https://openairdocs.org/deregistered/N4620T-1980-01-24.md): Maule M-4-210 · S/N 1032 · Cancelled Jan 24, 1980 · Exported to Canada · Silvernale Everett D
- [N9212U](https://openairdocs.org/deregistered/N9212U-1973-05-24.md): Cessna 320D · S/N 320D0091 · Cancelled May 24, 1973 · Beaudoin-Stueland Electric Co Inc
- [N2218](https://openairdocs.org/deregistered/N2218-1971-03-29.md): Schreder Sailplane HP-14 · S/N 52 · Cancelled Mar 29, 1971 · Fisher Mercer P Etal
- [N68Q](https://openairdocs.org/deregistered/N68Q-1971-02-24.md): Beech AT-11 · S/N 5065 · Cancelled Feb 24, 1971 · Appliance Buyers Credit Corp
- [N6865C](https://openairdocs.org/deregistered/N6865C-1971-02-03.md): Beech AT-11 · S/N 42-37277A · Cancelled Feb 3, 1971 · Appliance Buyers Credit Corp
- [N5989X](https://openairdocs.org/deregistered/N5989X-1965-05-22.md): Brantly B-2 · S/N 133 · Cancelled May 22, 1965 · Appliance Buyers Credit Corp
- [N6643E](https://openairdocs.org/deregistered/N6643E-1965-05-21.md): Cessna 175 · S/N 56143 · Cancelled May 21, 1965 · Appliance Buyers Credit Corporation
- [N9145R](https://openairdocs.org/deregistered/N9145R-1965-05-21.md): North American P-51D · S/N 44-74458 · Cancelled May 21, 1965 · Appliance Buyers Credit Corp
- [N9613Y](https://openairdocs.org/deregistered/N9613Y-1965-05-21.md): Beech 95-A55 · S/N TC-372 · Cancelled May 21, 1965 · Appliance Buyers Credit Corp
- [N6263X](https://openairdocs.org/deregistered/N6263X-1965-05-20.md): Aero Commander 680-F · S/N 680F-1176-91 · Cancelled May 20, 1965 · Appliance Buyers Credit Corp
- [N93644](https://openairdocs.org/deregistered/N93644-1962-01-29.md): Ercoupe 415-C · S/N 967 · Cancelled Jan 29, 1962 · Exported to Canada · Lang David L
- [N1925P](https://openairdocs.org/deregistered/N1925P-1959-03-06.md): Piper PA-22 · S/N 22-2676 · Cancelled Mar 6, 1959 · Pintcke Irwin E
- [N9075E](https://openairdocs.org/deregistered/N9075E-1956-02-29.md): Aeronca 11AC · S/N 11AC-706 · Cancelled Feb 29, 1956 · Demers Louis J
- [N951W](https://openairdocs.org/deregistered/N951W-1933-04-18.md): Midwestern School Of Gliding MW PRIMARY GLIDER · S/N WCI-2 · Cancelled Apr 18, 1933 · Midwestern School Of Gliding Inc

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

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