# Cancelled registrations: Farmington, MI

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

Cancelled aircraft registrations in Farmington, MI.

- [N87088](https://openairdocs.org/deregistered/N87088-2019-09-06.md): Engineering & Research 415-C · S/N 261 · Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Martin Vaughn Jr
- [N396ST](https://openairdocs.org/deregistered/N396ST-2018-01-19.md): Lee Cleve L MONOWHEEL XS · S/N A198 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Lee Cleve L
- [N43123](https://openairdocs.org/deregistered/N43123-2017-11-22.md): Taylorcraft BF · S/N 6782 · Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Fenner Stanley W
- [N6120H](https://openairdocs.org/deregistered/N6120H-2017-02-04.md): Piper J3C-65 · S/N 19283 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Mathieu James G
- [N7888C](https://openairdocs.org/deregistered/N7888C-2017-02-04.md): Universal Stinson 108-2 · S/N 108-3211 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Dale David R
- [N97CP](https://openairdocs.org/deregistered/N97CP-2014-12-22.md): Robinson Helicopter R22 ALPHA · S/N 0421 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1984 · Siversen Keith R
- [N51519](https://openairdocs.org/deregistered/N51519-2013-10-23.md): Raven S-50A · S/N S50A-227 · Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1973 · Kenney John T
- [N6277P](https://openairdocs.org/deregistered/N6277P-2013-08-05.md): Piper PA-24 · S/N 24-1386 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1959 · Pappas Theodore Sr
- [N9581U](https://openairdocs.org/deregistered/N9581U-2013-05-23.md): Grumman American Avn. AA-5A · S/N AA5A-0081 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1975 · Becker G Craig
- [N45685](https://openairdocs.org/deregistered/N45685-2012-07-24.md): Luscombe 8A · S/N 2212 · Cancelled Jul 24, 2012 · Revoked, canceled · Built 1946 · Bolyard Charles F
- [N8089D](https://openairdocs.org/deregistered/N8089D-2007-09-05.md): Scottish Aviation Bulldog BULLDOG BH 120 · S/N 415 · Cancelled Sep 5, 2007 · Exported to Canada · Built 1975 · Pope William B
- [N53070](https://openairdocs.org/deregistered/N53070-1992-02-28.md): Swearingen SA-26AT · S/N T26155 · Cancelled Feb 28, 1992 · Grand Aire Express Inc
- [N30332](https://openairdocs.org/deregistered/N30332-1991-05-29.md): Cessna 177A · S/N 17701198 · Cancelled May 29, 1991 · Exported to United Kingdom · Three A Flying Club Inc
- [N75810](https://openairdocs.org/deregistered/N75810-1981-10-19.md): Cessna 172N · S/N 17267968 · Cancelled Oct 19, 1981 · John Hatala Photographer Inc
- [N100KC](https://openairdocs.org/deregistered/N100KC-1975-10-31.md): Cessna 411A · S/N 411-0296 · Cancelled Oct 31, 1975 · Jatkoe Paul B
- [N5168X](https://openairdocs.org/deregistered/N5168X-1975-09-15.md): Champion 7ECA · S/N 675 · Cancelled Sep 15, 1975 · Exported to Canada · Fendt J L
- [N8335N](https://openairdocs.org/deregistered/N8335N-1973-07-20.md): Beech V35A · S/N D-8738 · Cancelled Jul 20, 1973 · Donald A Zanger
- [N82948](https://openairdocs.org/deregistered/N82948-1971-12-08.md): Aeronca 7AC · S/N 7AC-1599 · Cancelled Dec 8, 1971 · Buckner Ford J
- [N2389C](https://openairdocs.org/deregistered/N2389C-1971-08-31.md): Cessna 180 · S/N 30689 · Cancelled Aug 31, 1971 · R & D Tool Co
- [N7165P](https://openairdocs.org/deregistered/N7165P-1968-01-29.md): Piper PA-24-250 · S/N 24-2332 · Cancelled Jan 29, 1968 · Snyder Ross A
- [N9252K](https://openairdocs.org/deregistered/N9252K-1965-09-16.md): Stinson 108-2 · S/N 108-2252 · Cancelled Sep 16, 1965 · Exported to Canada · James M Kiefer
- [N96948](https://openairdocs.org/deregistered/N96948-1960-05-21.md): Taylorcraft BC12-D · S/N 9248 · Cancelled May 21, 1960 · Sallow Floyd
- [N74243](https://openairdocs.org/deregistered/N74243-1957-01-22.md): Bellanca 14-13-2 · S/N 1356 · Cancelled Jan 22, 1957 · Sampson Leon H
- [N61997](https://openairdocs.org/deregistered/N61997-1955-10-25.md): Cessna T-50 · S/N 6538 · Cancelled Oct 25, 1955 · Opdahl Floyd R
- [N23032](https://openairdocs.org/deregistered/N23032-1954-09-24.md): Luscombe 8A · S/N 955 · Cancelled Sep 24, 1954 · Exported to Canada · Built 1939 · Parker Johnnie C & Spicer Charles Jr
- [N36140](https://openairdocs.org/deregistered/N36140-1949-05-31.md): Taylorcraft BL12-65 · S/N 3107 · Cancelled May 31, 1949 · Shobe Harold R & Hazel B Shobe

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

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