# Cancelled registrations: West Bloomfield, MI

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

Cancelled aircraft registrations in West Bloomfield, MI.

- [N1110X](https://openairdocs.org/deregistered/N1110X-2022-06-04.md): DJI INSPIRE 1 · S/N W13DCG21040526 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Bardha Air
- [N2930Y](https://openairdocs.org/deregistered/N2930Y-2022-06-04.md): Piper PA-34-200 · S/N 34-7450099 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1974 · Ixi LLC
- [N181DV](https://openairdocs.org/deregistered/N181DV-2022-05-07.md): DJI INSPIRE 1 · S/N W13DCC30020125 · Cancelled May 7, 2022 · Registration expired, pending cancellation · Singer Michael D
- [N917E](https://openairdocs.org/deregistered/N917E-2022-02-05.md): Ilir Bardha FREEFLY CINESTAR X8 · S/N BA-917 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Bardha Air
- [N74KF](https://openairdocs.org/deregistered/N74KF-2019-06-29.md): Wilkinson Lorin L KITFOX II · S/N 274 · Cancelled Jun 29, 2019 · Registration pending, canceled · Built 1990
- [N36458](https://openairdocs.org/deregistered/N36458-2019-01-15.md): Piper PA-28R-201 · S/N 28R-7837279 · Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1978 · Ixi LLC
- [N122JL](https://openairdocs.org/deregistered/N122JL-2019-01-09.md): Lapalme Joseph E T-AEROW · S/N 2 · Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 1991 · Lapalme Joseph L
- [N54487](https://openairdocs.org/deregistered/N54487-2018-12-06.md): La Palme KELEHER LARK JK-1A · S/N 192 · Cancelled Dec 6, 2018 · Registration expired, pending cancellation · Built 1977 · Lapalme Joseph L
- [N917XX](https://openairdocs.org/deregistered/N917XX-2018-10-26.md): Ilir Bardha FREEFLY CINESTAR X8 · S/N BA-1111 · Cancelled Oct 26, 2018 · Second renewal notice · Bardha Air
- [N5828](https://openairdocs.org/deregistered/N5828-2018-09-13.md): Yuneec USA Q500 · S/N YU44901214BO1H · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Gosney Gregory
- [N3604R](https://openairdocs.org/deregistered/N3604R-2018-06-20.md): Balloon Works FIREFLY 7-B · S/N F7B-058 · Cancelled Jun 20, 2018 · First renewal notice · Brown Richard M
- [N47480](https://openairdocs.org/deregistered/N47480-2018-04-12.md): Piper PA-28-181 · S/N 28-7890078 · Cancelled Apr 12, 2018 · First renewal notice · Built 1977 · Ixi LLC
- [N689WW](https://openairdocs.org/deregistered/N689WW-2013-11-12.md): Piper PA-31-310 · S/N 31-69 · Cancelled Nov 12, 2013 · Revoked, canceled · Built 1967 · Spinney Latimer W
- [N219CB](https://openairdocs.org/deregistered/N219CB-2013-04-09.md): Cameron Balloons O-77 · S/N 617 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1980 · Clark William F
- [N24898](https://openairdocs.org/deregistered/N24898-2012-09-10.md): Masko MUSTANG M II · S/N 8 · Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Peterson Craig W
- [N75543](https://openairdocs.org/deregistered/N75543-2012-08-02.md): Murphy Aircraft Mfg REBEL-912 · S/N 147MCW · Cancelled Aug 2, 2012 · Exported to Canada · Built 2007
- [N373MR](https://openairdocs.org/deregistered/N373MR-2009-11-24.md): Cessna 172N · S/N 17268558 · Cancelled Nov 24, 2009 · Exported to Canada · Ashton Charles H
- [N83JF](https://openairdocs.org/deregistered/N83JF-1996-08-13.md): Piper PA-32RT-300 · S/N 32R7985023 · Cancelled Aug 13, 1996 · Triennial form not returned · Hagin Inc

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

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