# Cancelled registrations: Bloomfield Hills, MI

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

Cancelled aircraft registrations in Bloomfield Hills, MI.

- [N6130Z](https://openairdocs.org/deregistered/N6130Z-2023-04-01.md): Mikoyan MIG-17 · S/N 1689 · Cancelled Apr 1, 2023 · Registration expired, pending cancellation · World Heritage Air Museum
- [N3791J](https://openairdocs.org/deregistered/N3791J-2020-08-02.md): Cessna 150G · S/N 15065091 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1966 · Halbrook Russell L
- [N111ZG](https://openairdocs.org/deregistered/N111ZG-2019-03-11.md): DJI Innovations INSPIRE 1 · S/N W13DCG08040150 · Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Wiand Dennis L
- [N9104A](https://openairdocs.org/deregistered/N9104A-2017-03-10.md): Swanson SPAD VII · S/N C-7 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1978 · Byrne Aviation Inc
- [N696CW](https://openairdocs.org/deregistered/N696CW-2014-09-03.md): Semco Balloon CHALLENGER · S/N SEM-140 · Cancelled Sep 3, 2014 · Revoked, canceled · Built 1974 · Weiner Carl B
- [N1920P](https://openairdocs.org/deregistered/N1920P-2013-11-12.md): Piper PA-22-150 · S/N 22-2667 · Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1955 · Rhodes David B
- [N157JW](https://openairdocs.org/deregistered/N157JW-2013-10-31.md): Cessna 310L · S/N 310L-0146 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1967 · Wright James M
- [N35956](https://openairdocs.org/deregistered/N35956-2013-08-19.md): Piper J3L-65 · S/N 6674 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1941
- [N63731](https://openairdocs.org/deregistered/N63731-2013-08-06.md): Piper PA-31-350 · S/N 31-7752054 · Cancelled Aug 6, 2013 · Revoked, canceled · Built 1977 · Palmer Michael P II DBA
- [N9499T](https://openairdocs.org/deregistered/N9499T-2013-05-23.md): Piper PA-38-112 · S/N 38-78A0117 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1978 · Bonfils Thomas A
- [N9691W](https://openairdocs.org/deregistered/N9691W-2013-05-23.md): Piper PA-28-140 · S/N 28-23162 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1967 · Dillon Thomas J Jr
- [N31469](https://openairdocs.org/deregistered/N31469-2010-10-18.md): Howard DGA-15P · S/N 830 · Cancelled Oct 18, 2010 · Exported to France · Aikcar Inc
- [N2741V](https://openairdocs.org/deregistered/N2741V-2009-09-15.md): Beech 35 · S/N D-121 · Cancelled Sep 15, 2009 · Registration revoked · Built 1947 · Hollenback Robert C
- [N1742](https://openairdocs.org/deregistered/N1742-2009-07-09.md): Lindoon PLATOON I · S/N 001 · Cancelled Jul 9, 2009 · Registration revoked · Built 1968 · Harding Linden F
- [N1981W](https://openairdocs.org/deregistered/N1981W-2009-07-09.md): Douglas DC3A · S/N 2232 · Cancelled Jul 9, 2009 · Registration revoked · Built 1940 · Merser Herbert B
- [N88MG](https://openairdocs.org/deregistered/N88MG-2007-06-01.md): Piper PA-31-350 · S/N 31-7652088 · Cancelled Jun 1, 2007 · Exported to Canada · Built 1976 · Mentag Development Corp
- [N811JG](https://openairdocs.org/deregistered/N811JG-2007-03-09.md): Aerofab LAKE 250 · S/N 113 · Cancelled Mar 9, 2007 · Triennial form not returned · Built 1991 · Gilson Jack E
- [N2805B](https://openairdocs.org/deregistered/N2805B-2006-02-13.md): Socata TB-20 TRINIDAD · S/N 1080 · Cancelled Feb 13, 2006 · Exported to Cambodia · Robertson Bernard I
- [N1199L](https://openairdocs.org/deregistered/N1199L-2006-01-24.md): Cessna 310L · S/N 310L-0033 · Cancelled Jan 24, 2006 · Triennial form not returned · Morgan Jerome
- [N4450W](https://openairdocs.org/deregistered/N4450W-2005-12-02.md): Beech 95-B55 (T42A) · S/N TC-1673 · Cancelled Dec 2, 2005 · Triennial form not returned · Built 1974 · B-Bo-B LLC
- [N308KC](https://openairdocs.org/deregistered/N308KC-2005-11-21.md): Cessna 208B · S/N 208B0780 · Cancelled Nov 21, 2005 · Exported to Canada · Built 1999 · Eagle Nest LLC
- [N1137L](https://openairdocs.org/deregistered/N1137L-2000-05-30.md): Lake LA-4 · S/N 299 · Cancelled May 30, 2000 · Mclaughlin Francis B
- [N10FD](https://openairdocs.org/deregistered/N10FD-1999-10-07.md): Cessna 414 · S/N 414-0634 · Cancelled Oct 7, 1999 · Exported to Canada · Byrne Aviation
- [N46445](https://openairdocs.org/deregistered/N46445-1995-03-21.md): Cessna 172K · S/N 17257273 · Cancelled Mar 21, 1995 · Triennial form not returned · Miller John R
- [N75362](https://openairdocs.org/deregistered/N75362-1994-05-25.md): Piper PA-28-235 · S/N 287610120 · Cancelled May 25, 1994 · Exported to Kenya · Hunts Investment Corp
- [N40754](https://openairdocs.org/deregistered/N40754-1991-03-22.md): Piper PA-28-140 · S/N 287425157 · Cancelled Mar 22, 1991 · Triennial form not returned · Aero Ed Inc
- [N212BF](https://openairdocs.org/deregistered/N212BF-1991-02-01.md): Beech 200 · S/N BB622 · Cancelled Feb 1, 1991 · Exported to France · Cross And Trecker Corporation
- [N3917N](https://openairdocs.org/deregistered/N3917N-1977-11-18.md): Beech B35 · S/N D-1172 · Cancelled Nov 18, 1977 · G D Peterson
- [N500KR](https://openairdocs.org/deregistered/N500KR-1977-11-11.md): Beagle B.206 SERIES 2 · S/N 065 · Cancelled Nov 11, 1977 · Cole Dollie Ann
- [N7852E](https://openairdocs.org/deregistered/N7852E-1976-02-27.md): Cessna 150 · S/N 17652 · Cancelled Feb 27, 1976 · Exported to Canada · Shaver Frederick R
- [N5706K](https://openairdocs.org/deregistered/N5706K-1973-10-09.md): Beech S35 · S/N D-7506 · Cancelled Oct 9, 1973 · Rush Desmond K
- [N9260A](https://openairdocs.org/deregistered/N9260A-1970-01-31.md): Cessna 170A · S/N 19021 · Cancelled Jan 31, 1970 · Jerry L Schweizer
- [N9347F](https://openairdocs.org/deregistered/N9347F-1965-11-02.md): Hughes 269B · S/N 540080 · Cancelled Nov 2, 1965 · Stephen F Booth Productions
- [N5608P](https://openairdocs.org/deregistered/N5608P-1965-05-20.md): Piper PA-24 · S/N 24-676 · Cancelled May 20, 1965 · Charles D Marsh
- [N473M](https://openairdocs.org/deregistered/N473M-1947-02-28.md): Detroit E-2A · S/N 18 · Cancelled Feb 28, 1947 · Walter Bromley

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

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