# Cancelled registrations: Southfield, MI

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

Cancelled aircraft registrations in Southfield, MI.

- [N239GF](https://openairdocs.org/deregistered/N239GF-2019-12-16.md): Hawker Beechcraft HAWKER 900XP · S/N HA-0175 · Cancelled Dec 16, 2019 · Exported to Mexico · Built 2011 · Law Flight LLC
- [N2680A](https://openairdocs.org/deregistered/N2680A-2019-11-29.md): Solo Wing AQUILLA TRIKE · S/N 1958 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Jweda Kamal Ezzat
- [N4247T](https://openairdocs.org/deregistered/N4247T-2018-01-19.md): Piper PA-28-180 · S/N 28-7205117 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Friedlander Allen Harvey
- [N234NA](https://openairdocs.org/deregistered/N234NA-2017-10-26.md): North American T-28A · S/N 50-234 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1950 · Yankee Flyers Museum Inc
- [N80045](https://openairdocs.org/deregistered/N80045-2017-02-04.md): Beech D18S · S/N A-154 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Vincent Augustin
- [N550BP](https://openairdocs.org/deregistered/N550BP-2015-05-13.md): Cessna 550 · S/N 550-0246 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1981 · Toy Air Inc
- [N110LR](https://openairdocs.org/deregistered/N110LR-2013-10-25.md): Robbins Orma L JR RAND KR-2 · S/N OR1 · Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1985 · Robbins Orma L Jr
- [N1981R](https://openairdocs.org/deregistered/N1981R-2013-09-13.md): Raven S-50A · S/N S50A-194 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1972 · Shimmin Robert D
- [N8512R](https://openairdocs.org/deregistered/N8512R-2013-09-10.md): Bellanca 14-19-3 · S/N 4274 · Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1965 · Little Michael T
- [N84UM](https://openairdocs.org/deregistered/N84UM-2013-07-29.md): Cessna 414A · S/N 414A0625 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1980 · Kapetansky Donald
- [N31844](https://openairdocs.org/deregistered/N31844-2013-06-18.md): Piper PA-32RT-300 · S/N 32R-7885132 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1978 · Michigan Drywall
- [N93572](https://openairdocs.org/deregistered/N93572-2013-05-22.md): Bellanca 17-30A · S/N 74-30692 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1974 · Wooden Airplane Co
- [N95443](https://openairdocs.org/deregistered/N95443-2013-05-02.md): Cameron Balloons US N-77 · S/N 5571 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1989 · Re Max Brokers Service Center
- [N4234R](https://openairdocs.org/deregistered/N4234R-2012-10-02.md): Raven S55A · S/N S55A-1033 · Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Re/Max Broker Service Center Inc
- [N33RZ](https://openairdocs.org/deregistered/N33RZ-2011-10-20.md): Rockwell International NA-265-80 · S/N 380-47 · Cancelled Oct 20, 2011 · Exported to Mexico · Built 1976 · Air-N33 Rz Inc
- [N9086C](https://openairdocs.org/deregistered/N9086C-2011-07-15.md): Chatterton Sterling G CHATTERTON TWINKIE · S/N 1 · Cancelled Jul 15, 2011 · Revoked, pending cancellation · Built 1960 · Bond Cash D Jr
- [N165WM](https://openairdocs.org/deregistered/N165WM-2008-02-21.md): Mcclintock Willie N GLASAIR SH-2 · S/N 165 · Cancelled Feb 21, 2008 · Triennial form not returned · Built 1984 · May Robert W
- [N311JX](https://openairdocs.org/deregistered/N311JX-2005-08-18.md): Bell 206L-3 · S/N 51251 · Cancelled Aug 18, 2005 · Built 1988 · Act Two Inc
- [N30628](https://openairdocs.org/deregistered/N30628-2004-10-05.md): Socata TB200XL · S/N 1769 · Cancelled Oct 5, 2004 · Exported to Canada · Built 1995 · Prymak Cameron
- [N121JW](https://openairdocs.org/deregistered/N121JW-1991-03-01.md): Cessna 551 · S/N 5510463 · Cancelled Mar 1, 1991 · Exported to Venezuela · General Electric Capital Corp
- [N1199T](https://openairdocs.org/deregistered/N1199T-1981-04-11.md): Beech D95A · S/N TD-608 · Cancelled Apr 11, 1981 · Administratively canceled · Obrien John H
- [N5194S](https://openairdocs.org/deregistered/N5194S-1978-03-03.md): Piper PA-28-180 · S/N 287105054 · Cancelled Mar 3, 1978 · Troy Flying Co
- [N298CC](https://openairdocs.org/deregistered/N298CC-1977-03-17.md): Piper PA-28R-200 · S/N 28R-35371 · Cancelled Mar 17, 1977 · Michigan National Bank Of Detroit
- [N253P](https://openairdocs.org/deregistered/N253P-1976-09-15.md): Rowe CASSUTT-111M · S/N 527 · Cancelled Sep 15, 1976 · Rowe John Calvin
- [N8408N](https://openairdocs.org/deregistered/N8408N-1976-05-27.md): Beech B-55 · S/N TC-1094 · Cancelled May 27, 1976 · Built 1968 · Gittleman Robert/Clifford Paskel/Bonilla Jaime
- [N3077](https://openairdocs.org/deregistered/N3077-1976-05-18.md): Steven Geppert B-8M · S/N 1 · Cancelled May 18, 1976 · Built 1971 · Geppert Steven
- [N8418N](https://openairdocs.org/deregistered/N8418N-1974-04-24.md): Beech V35A · S/N D-8781 · Cancelled Apr 24, 1974 · Built 1968 · Southfield Leasing Inc
- [N9691X](https://openairdocs.org/deregistered/N9691X-1974-03-26.md): Cessna 210B · S/N 21057991 · Cancelled Mar 26, 1974 · Friend Construction Co Inc
- [N6875Q](https://openairdocs.org/deregistered/N6875Q-1974-01-15.md): Beech 65-A80 · S/N LD-191 · Cancelled Jan 15, 1974 · Michigan Airtravel Corp
- [N46341](https://openairdocs.org/deregistered/N46341-1972-06-01.md): Cessna 172K · S/N 17257195 · Cancelled Jun 1, 1972 · Exported to Canada · Williams Earl R
- [N2217F](https://openairdocs.org/deregistered/N2217F-1972-01-17.md): Cessna 310L · S/N 310L-0017 · Cancelled Jan 17, 1972 · Friend Arthur S
- [N4463V](https://openairdocs.org/deregistered/N4463V-1970-09-23.md): Beech 35 · S/N D-1279 · Cancelled Sep 23, 1970 · Equipment Liquidating Co

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

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