# Cancelled registrations: Three Rivers, MI

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

Cancelled aircraft registrations in Three Rivers, MI.

- [N9722W](https://openairdocs.org/deregistered/N9722W-2023-07-08.md): Piper PA-28-140 · S/N 28-23200 · Cancelled Jul 8, 2023 · Registration pending, canceled · Built 1967
- [N2079K](https://openairdocs.org/deregistered/N2079K-2022-11-22.md): Luscombe 8A · S/N 4806 · Cancelled Nov 22, 2022 · Sale reported, canceled · Built 1947
- [N8265Z](https://openairdocs.org/deregistered/N8265Z-2021-03-06.md): Cessna 210-5(205) · S/N 205-0265 · Cancelled Mar 6, 2021 · Sale reported, canceled · Built 1963
- [N944SS](https://openairdocs.org/deregistered/N944SS-2019-03-06.md): Schauer Stephen R SEAREY · S/N 1MK115 · Cancelled Mar 6, 2019 · Registration expired, pending cancellation · Built 1996 · Schauer Stephen R
- [N106PH](https://openairdocs.org/deregistered/N106PH-2018-01-09.md): Phantom Aeronautics PHANTOM II · S/N 123105001 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2006 · Pederson Erik T
- [N6908Q](https://openairdocs.org/deregistered/N6908Q-2015-05-13.md): Beech A23-19 · S/N MB-280 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1967 · Kme Tool Inc
- [N4057K](https://openairdocs.org/deregistered/N4057K-2014-12-18.md): Balloon Works FIREFLY 7 · S/N 10114 · Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1980 · Sperry Wayne S
- [N7048](https://openairdocs.org/deregistered/N7048-2013-08-23.md): Ensley CAVALIER SA-102-5EM · S/N 69103 · Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1973
- [N879B](https://openairdocs.org/deregistered/N879B-2013-05-15.md): Mooney M20 · S/N 1042 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1956 · Titus Charles
- [N6513B](https://openairdocs.org/deregistered/N6513B-2013-04-30.md): Mooney M20 · S/N 1180 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1957 · Titus Charles
- [N6531B](https://openairdocs.org/deregistered/N6531B-2013-04-30.md): Mooney M20 · S/N 1198 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1958 · Titus Charles
- [N113JF](https://openairdocs.org/deregistered/N113JF-2009-09-21.md): Cessna 170A · S/N 18966 · Cancelled Sep 21, 2009 · Registration revoked · Built 1949 · Arbanas Jerry A
- [N2256J](https://openairdocs.org/deregistered/N2256J-1991-10-16.md): Cessna 150G · S/N 15065456 · Cancelled Oct 16, 1991 · Triennial form not returned · 3 Rivers Aviation
- [N82EA](https://openairdocs.org/deregistered/N82EA-1977-09-30.md): Mooney M20 · S/N 1016 · Cancelled Sep 30, 1977 · Titus Charles
- [N14505](https://openairdocs.org/deregistered/N14505-1970-12-30.md): Harold Hartman/Harold Delano HARTMAN/DELANO HEATH · S/N 101 · Cancelled Dec 30, 1970 · Ward Richard
- [N2969S](https://openairdocs.org/deregistered/N2969S-1968-09-30.md): Cessna 150G · S/N 15066869 · Cancelled Sep 30, 1968 · Matthews Richard C
- [N2078E](https://openairdocs.org/deregistered/N2078E-1960-12-22.md): Aeronca 7AC · S/N 7AC-5648 · Cancelled Dec 22, 1960 · Exported to Canada · Built 1946 · Ward Aero Service
- [N79276](https://openairdocs.org/deregistered/N79276-1960-04-26.md): Cessna T-50 · S/N 1388 · Cancelled Apr 26, 1960 · Greenlight Auto Supply
- [N4865K](https://openairdocs.org/deregistered/N4865K-1954-11-03.md): Ryan NAVION A · S/N NAV-4-1865 · Cancelled Nov 3, 1954 · Newton Roy C
- [N86932](https://openairdocs.org/deregistered/N86932-1949-03-31.md): Bellanca 14-13 · S/N 1294 · Cancelled Mar 31, 1949 · D G Miller & Sons
- [N3967](https://openairdocs.org/deregistered/N3967-1930-02-14.md): Eaglerock LONG WING EAGLEROCK · S/N 382 · Cancelled Feb 14, 1930 · Built 1928 · Easterbrook Frank

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

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