# Cancelled registrations: Plainwell, MI

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

Cancelled aircraft registrations in Plainwell, MI.

- [N12108](https://openairdocs.org/deregistered/N12108-2021-12-04.md): Digby Doll STOLP SA-300 · S/N 200 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1970 · Digby Larry G
- [N224AH](https://openairdocs.org/deregistered/N224AH-2021-09-15.md): Cirrus Design SR22 · S/N 1531 · Cancelled Sep 15, 2021 · Exported to Canada · Built 2005 · Von Seggern Wesley
- [N49MR](https://openairdocs.org/deregistered/N49MR-2015-05-13.md): Bell 47G-3B-2 · S/N 6828 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Vanderhoff Doulgas S
- [N3997G](https://openairdocs.org/deregistered/N3997G-2013-06-11.md): Great Lakes Skycycles CONDOR III+2 · S/N 83-113-3-2 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Great Lakes Skycycles Inc
- [N5505Z](https://openairdocs.org/deregistered/N5505Z-2013-04-22.md): Piper PA-22-108 · S/N 22-9291 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Plainview Aviation Inc
- [N47412](https://openairdocs.org/deregistered/N47412-2012-12-13.md): Cessna 152 · S/N 15283223 · Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Plainwell Aviation Inc
- [N171MA](https://openairdocs.org/deregistered/N171MA-2009-06-26.md): Mitsubishi MU-2B-40 · S/N 431 S.A. · Cancelled Jun 26, 2009 · Triennial form not returned · Built 1980 · Drug And Laboratory Disposal Inc
- [N1022Z](https://openairdocs.org/deregistered/N1022Z-2007-08-10.md): Sawyer TINY ACE SPECIAL · S/N 1 · Cancelled Aug 10, 2007 · Triennial form not returned · Built 1961 · Carlson Roy A
- [N36940](https://openairdocs.org/deregistered/N36940-2002-07-23.md): Aeronca 65-TAC · S/N C2471TA · Cancelled Jul 23, 2002 · Triennial form not returned · Built 1941 · Morehouse Merle G
- [N42DF](https://openairdocs.org/deregistered/N42DF-2000-09-15.md): Froelich Del QUICKIE Q-2 · S/N 2492 · Cancelled Sep 15, 2000 · Triennial form not returned · Froelich Del
- [N109R](https://openairdocs.org/deregistered/N109R-1982-04-15.md): Schreder HP-14 · S/N 6 · Cancelled Apr 15, 1982 · Administratively canceled · Whitmore Charles H
- [N7685J](https://openairdocs.org/deregistered/N7685J-1975-04-24.md): Piper PA-28R-180 · S/N 28R-31086 · Cancelled Apr 24, 1975 · Exported to Canada · Becker John A
- [N2981C](https://openairdocs.org/deregistered/N2981C-1975-04-21.md): Jupiter J 1 · S/N KRC-1 · Cancelled Apr 21, 1975 · Schiffer Albert E
- [N86624](https://openairdocs.org/deregistered/N86624-1974-07-23.md): Bellanca 7GCBC · S/N 675-74 · Cancelled Jul 23, 1974 · Digby Larry G & Otto Eddie T
- [N24220](https://openairdocs.org/deregistered/N24220-1970-10-07.md): Aeronca 65-TC · S/N C6847 · Cancelled Oct 7, 1970 · Built 1939 · Plainwell Aviation Inc
- [N2593A](https://openairdocs.org/deregistered/N2593A-1970-07-13.md): Piper PA-20 · S/N 20-940 · Cancelled Jul 13, 1970 · Schmitt Elden
- [N29629](https://openairdocs.org/deregistered/N29629-1970-07-13.md): Taylorcraft BL-65 · S/N 2471 · Cancelled Jul 13, 1970 · Plainwell Aviation Inc
- [N5023N](https://openairdocs.org/deregistered/N5023N-1956-02-15.md): Consolidated Vultee BT-13A · S/N 10424 · Cancelled Feb 15, 1956 · Cooper Jack
- [N69868](https://openairdocs.org/deregistered/N69868-1955-10-14.md): Fairchild M-62C · S/N 4113AE · Cancelled Oct 14, 1955 · Otsego-Plainwell Flying Service
- [N2407E](https://openairdocs.org/deregistered/N2407E-1952-02-19.md): Aeronca 7AC · S/N 7AC-5986 · Cancelled Feb 19, 1952 · Green Howard E

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

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