# Cancelled registrations: Northville, MI

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

Cancelled aircraft registrations in Northville, MI.

- [N260Y](https://openairdocs.org/deregistered/N260Y-2024-09-06.md): Barbara Bergstrom TITAN T-51 · S/N M07SV6SOHK0128 · Cancelled Sep 6, 2024 · Built 2013 · Sutton Kenneth P
- [N263AC](https://openairdocs.org/deregistered/N263AC-2023-02-16.md): Beech 58 · S/N TH-382 · Cancelled Feb 16, 2023 · Registration expired, pending cancellation · Built 1973 · Lumair LLC
- [N238CM](https://openairdocs.org/deregistered/N238CM-2019-03-16.md): DJI PHANTOM 3 PROFESSION · S/N P76DCE28016532 · Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Meyer Christopher L
- [N4101G](https://openairdocs.org/deregistered/N4101G-2017-04-13.md): Bell 47G-5 · S/N 7912 · Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1968 · Arch Associates Ltd
- [N6315P](https://openairdocs.org/deregistered/N6315P-2015-04-27.md): Piper PA-24 · S/N 24-1425 · Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1959 · Beggs Larry A Sr
- [N6886G](https://openairdocs.org/deregistered/N6886G-2013-10-24.md): Cessna 150L · S/N 15072386 · Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1970 · Daurelio Joseph L
- [N2126C](https://openairdocs.org/deregistered/N2126C-2010-03-24.md): Cessna 195B · S/N 16111 · Cancelled Mar 24, 2010 · Exported to Australia · Built 1953 · Maxfield John O
- [N736FZ](https://openairdocs.org/deregistered/N736FZ-2008-06-02.md): Cessna R172K · S/N R1722504 · Cancelled Jun 2, 2008 · Exported to Canada · Built 1977 · Ramsthel Steven
- [N8421Q](https://openairdocs.org/deregistered/N8421Q-2003-10-07.md): Aerofab LAKE LA-250 · S/N 87 · Cancelled Oct 7, 2003 · Exported to Canada · Air Cloverdale Inc
- [N301FM](https://openairdocs.org/deregistered/N301FM-2001-10-09.md): Fouga CM 170R MAGISTER · S/N 240 · Cancelled Oct 9, 2001 · Triennial form not returned · Built 1959 · Simpson Roger S
- [N208KC](https://openairdocs.org/deregistered/N208KC-2001-07-09.md): Cessna 208B · S/N 208B0764 · Cancelled Jul 9, 2001 · Exported to Canada · Kc Aviation LLC
- [N21GV](https://openairdocs.org/deregistered/N21GV-1995-07-31.md): Cessna P206B · S/N P2060343 · Cancelled Jul 31, 1995 · Triennial form not returned · Palicki Raymond F
- [N41936](https://openairdocs.org/deregistered/N41936-1982-09-11.md): Piper PA-28-151 · S/N 28-7415363 · Cancelled Sep 11, 1982 · Built 1974 · West Kenneth R
- [N4WH](https://openairdocs.org/deregistered/N4WH-1979-04-10.md): Herzog VARI-EZE · S/N 430 · Cancelled Apr 10, 1979 · Built 1978 · Herzog W
- [N17612](https://openairdocs.org/deregistered/N17612-1974-06-27.md): Preiss Heinrich K SCHREDER HP-11 · S/N 2B · Cancelled Jun 27, 1974 · Built 1963 · Matz Thomas C Etal
- [N7813X](https://openairdocs.org/deregistered/N7813X-1972-08-30.md): Cessna 172B · S/N 17248313 · Cancelled Aug 30, 1972 · Exported to Canada · Canamer Associates Inc
- [N7039W](https://openairdocs.org/deregistered/N7039W-1972-02-16.md): Piper PA-28-180 · S/N 28-722 · Cancelled Feb 16, 1972 · John Lemon
- [N8554K](https://openairdocs.org/deregistered/N8554K-1971-12-14.md): Stinson 108-1 · S/N 108-1554 · Cancelled Dec 14, 1971 · Stroh Arthur J
- [N4183](https://openairdocs.org/deregistered/N4183-1931-08-18.md): Stinson SM-1 · S/N 223 · Cancelled Aug 18, 1931 · Stinson Aircraft Corporation
- [N7472](https://openairdocs.org/deregistered/N7472-1930-08-22.md): Stinson SM1-B · S/N M-270 · Cancelled Aug 22, 1930 · International Air Transport
- [N9698](https://openairdocs.org/deregistered/N9698-1929-10-17.md): Stinson SM-1F · S/N 503 · Cancelled Oct 17, 1929 · Exported to China · Stinson Aircraft Corp
- [N7469](https://openairdocs.org/deregistered/N7469-1929-06-28.md): Stinson SM1-B · S/N M-268 · Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp
- [N7470](https://openairdocs.org/deregistered/N7470-1929-06-28.md): Stinson SM1-B · S/N M-269 · Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp
- [N7473](https://openairdocs.org/deregistered/N7473-1929-06-28.md): Stinson SM1-B · S/N M-271 · Cancelled Jun 28, 1929 · Exported to Mexico · Built 1928 · Stinson Aircraft Corp
- [N5639](https://openairdocs.org/deregistered/N5639-1928-10-12.md): Stinson SM1-B · S/N M-240 · Cancelled Oct 12, 1928 · Stinson Aircraft Corp

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

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