# Cancelled registrations: Coldwater, MI

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

Cancelled aircraft registrations in Coldwater, MI.

- [N19322](https://openairdocs.org/deregistered/N19322-2019-11-06.md): Cessna 150L · S/N 15074337 · Cancelled Nov 6, 2019 · Built 1973 · Fellabaum Thomas R
- [N312SH](https://openairdocs.org/deregistered/N312SH-2018-03-05.md): Bell 47G-2 · S/N 1375 · Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1955 · Odren Aviation LLC
- [N51461](https://openairdocs.org/deregistered/N51461-2017-11-20.md): Taylorcraft DC-65 · S/N 5569 · Cancelled Nov 20, 2017 · Revoked, canceled · Built 1943 · Rose Thomas L
- [N336TC](https://openairdocs.org/deregistered/N336TC-2017-08-04.md): Beech A36TC · S/N EA-211 · Cancelled Aug 4, 2017 · Registration expired, pending cancellation · Built 1981 · Wharton Howard
- [N9955](https://openairdocs.org/deregistered/N9955-2017-07-12.md): Robert Murfin B-8M · S/N 995 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1969 · Murfin Robert
- [N389TT](https://openairdocs.org/deregistered/N389TT-2016-04-07.md): Piper PA-12 · S/N 12-2726 · Cancelled Apr 7, 2016 · Exported to Canada · Built 1947 · Aircraft & Aviation Professionals LLC
- [N9165T](https://openairdocs.org/deregistered/N9165T-2013-11-08.md): Mooney M20R · S/N 29-0060 · Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1995 · Hanseatic Air Of Michigan Inc
- [N86884](https://openairdocs.org/deregistered/N86884-2013-09-11.md): Bellanca 14-13 · S/N 1246 · Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Tomson Jerry M
- [N1510K](https://openairdocs.org/deregistered/N1510K-2013-07-01.md): Balloon Works FIREFLY 7-B · S/N F7B-014 · Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1982 · Vought Carol
- [N4448N](https://openairdocs.org/deregistered/N4448N-2013-06-11.md): Colt Balloons 17A · S/N 403 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1982 · Reed Edward R
- [N131JT](https://openairdocs.org/deregistered/N131JT-2013-06-04.md): Tomson Jerry M VP-1 · S/N V 1583 (1902) · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1986 · Tomson Jerry M
- [N69223](https://openairdocs.org/deregistered/N69223-2013-05-02.md): Cessna 152 · S/N 15282568 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Branch County Aviation
- [N2557G](https://openairdocs.org/deregistered/N2557G-2012-11-05.md): Piper PA-38-112 · S/N 38-79A0553 · Cancelled Nov 5, 2012 · Exported to Argentina · Built 1979 · Aircraft & Aviation Professionals LLC
- [N3923F](https://openairdocs.org/deregistered/N3923F-2012-06-14.md): Piper PA-32R-300 · S/N 32R-7680419 · Cancelled Jun 14, 2012 · Sale reported, pending cancellation · Built 1976
- [N125NS](https://openairdocs.org/deregistered/N125NS-2005-08-19.md): Soder Norman R RANS S7 · S/N 0693113 · Cancelled Aug 19, 2005 · Exported to Canada · Built 1996 · Soder Norman R
- [N27360](https://openairdocs.org/deregistered/N27360-2004-05-07.md): Piper PA-31-350 · S/N 31-7752189 · Cancelled May 7, 2004 · Exported to Canada · Built 1977 · Sport Truck LLC
- [N2181A](https://openairdocs.org/deregistered/N2181A-2002-08-05.md): Piper PA-44-180 · S/N 44-7995088 · Cancelled Aug 5, 2002 · Exported to Canada · Built 1978 · Sport Truck LLC
- [N7915K](https://openairdocs.org/deregistered/N7915K-2002-06-14.md): Beech S35 · S/N D-7409 · Cancelled Jun 14, 2002 · Triennial form not returned · Built 1964 · Bgn Partnership
- [N14A](https://openairdocs.org/deregistered/N14A-1997-04-15.md): Cessna 421B · S/N 421B0373 · Cancelled Apr 15, 1997 · Hanseatic Air Inc
- [N5828M](https://openairdocs.org/deregistered/N5828M-1992-07-07.md): Cessna 340 · S/N 3400052 · Cancelled Jul 7, 1992 · Exported to Canada · Munn E Harold Jr
- [N4123Y](https://openairdocs.org/deregistered/N4123Y-1991-03-29.md): Raven Industries RALLY RX7 · S/N RX7288 · Cancelled Mar 29, 1991 · Triennial form not returned · Wind Riders Inc
- [N80422](https://openairdocs.org/deregistered/N80422-1991-01-28.md): Cessna 172M · S/N 17266581 · Cancelled Jan 28, 1991 · Triennial form not returned · Branch County Aviation Inc
- [N1036R](https://openairdocs.org/deregistered/N1036R-1982-11-24.md): Raven Industries RX6 · S/N RX6-196 · Cancelled Nov 24, 1982 · Administratively canceled · Wind Riders Inc
- [N20Y](https://openairdocs.org/deregistered/N20Y-1982-10-07.md): Fairchild M-62A · S/N T43-7429 · Cancelled Oct 7, 1982 · Built 1943 · Kelly Michael P And Meyer Raymond C Jr
- [N7877G](https://openairdocs.org/deregistered/N7877G-1981-10-14.md): Cessna 172L · S/N 17259577 · Cancelled Oct 14, 1981 · Dunn Keith A
- [N5256S](https://openairdocs.org/deregistered/N5256S-1977-12-05.md): Piper PA-32-300 · S/N 3240961 · Cancelled Dec 5, 1977 · Branch County Aviation
- [N8330N](https://openairdocs.org/deregistered/N8330N-1977-03-04.md): Beech D55 · S/N TE-543 · Cancelled Mar 4, 1977 · Hadley Clifford L
- [N4255U](https://openairdocs.org/deregistered/N4255U-1974-06-03.md): Cessna 150D · S/N 15060255 · Cancelled Jun 3, 1974 · Exported to Canada · Branch County Aviation Inc
- [N5599](https://openairdocs.org/deregistered/N5599-1974-04-23.md): Harris JEANIES TEENIE · S/N DH-1 · Cancelled Apr 23, 1974 · Harris Dewey Jr
- [N4313G](https://openairdocs.org/deregistered/N4313G-1972-03-17.md): Mcculloch J-2 · S/N 023 · Cancelled Mar 17, 1972 · Dean Dale A
- [N86208](https://openairdocs.org/deregistered/N86208-1971-03-19.md): Aeronca 11AC · S/N 11AC-12 · Cancelled Mar 19, 1971 · Exported to Canada · Built 1946 · Weaver George J
- [N1352W](https://openairdocs.org/deregistered/N1352W-1970-06-29.md): Mooney M20C · S/N 2633 · Cancelled Jun 29, 1970 · Cadillac Co Inc
- [N2837A](https://openairdocs.org/deregistered/N2837A-1957-11-13.md): Cessna 180 · S/N 30037 · Cancelled Nov 13, 1957 · Exported to Canada · Williams Grain Co
- [N61786](https://openairdocs.org/deregistered/N61786-1956-02-15.md): Consolidated Vultee BT-13A · S/N 8767 · Cancelled Feb 15, 1956 · Knoth William S
- [N54433](https://openairdocs.org/deregistered/N54433-1955-11-29.md): Cessna T-50 · S/N 3460 · Cancelled Nov 29, 1955 · Sheridan James A
- [N51295](https://openairdocs.org/deregistered/N51295-1952-03-03.md): Fairchild M-62C · S/N 4563AE · Cancelled Mar 3, 1952 · Sheridan James A
- [N36143](https://openairdocs.org/deregistered/N36143-1949-09-14.md): Taylorcraft BL-65 · S/N 3122 · Cancelled Sep 14, 1949 · Lepird George R
- [N84398](https://openairdocs.org/deregistered/N84398-1946-12-17.md): Aeronca 7AC · S/N 7AC-3097 · Cancelled Dec 17, 1946 · Branch County Air Service
- [N11132](https://openairdocs.org/deregistered/N11132-1931-05-20.md): Aircraft Builders PARROT · S/N 100 · Cancelled May 20, 1931 · Built 1930 · Aircraft Builders Co
- [N61728](https://openairdocs.org/deregistered/N61728-undated.md): Cessna T-50 · S/N 2227 · Cancellation date not recorded · Greenamyer Ardis 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 = 'COLDWATER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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