# Cancelled registrations: Royal Oak, MI

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

Cancelled aircraft registrations in Royal Oak, MI.

- [N687NS](https://openairdocs.org/deregistered/N687NS-2022-11-05.md): DJI INSPIRE 1 · S/N W13DBL24020481 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Seventy 7 Productions
- [N360N](https://openairdocs.org/deregistered/N360N-2019-09-06.md): Smith Martin P LANCAIR 320 · S/N 330 · Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1999
- [N263AN](https://openairdocs.org/deregistered/N263AN-2019-03-16.md): Beauchesne/Wells GLASAIR TD · S/N 544 · Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1985 · Rusinowski Steven P
- [N80221](https://openairdocs.org/deregistered/N80221-2018-08-29.md): Cessna 172M · S/N 17266455 · Cancelled Aug 29, 2018 · Exported to Philippines · Built 1975 · Dmb Associates Consulting LLC
- [N26181](https://openairdocs.org/deregistered/N26181-2018-01-02.md): Grumman American Avn. AA-5A · S/N AA5A0469 · Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1977 · Snoopy Aviation LLC
- [N1GK](https://openairdocs.org/deregistered/N1GK-2017-06-19.md): Grohs Donald SCORPION TOO · S/N 10689 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1980 · Kreiner Robert L
- [N9405F](https://openairdocs.org/deregistered/N9405F-2017-02-13.md): Hughes 269B · S/N 0131 · Cancelled Feb 13, 2017 · Revoked, canceled · Built 1964 · Nelson Hel Sales Larry
- [N41466](https://openairdocs.org/deregistered/N41466-2015-05-15.md): Piper PA-28-151 · S/N 28-7415227 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1974 · Hammond Robert E
- [N714PR](https://openairdocs.org/deregistered/N714PR-2014-12-02.md): Cessna 150M · S/N 15079332 · Cancelled Dec 2, 2014 · Revoked, canceled · Built 1977 · Polasky Robert
- [N3669B](https://openairdocs.org/deregistered/N3669B-2014-10-02.md): Beech B50 · S/N CH-62 · Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1954 · Mattson Bruce A
- [N6873M](https://openairdocs.org/deregistered/N6873M-2013-11-06.md): Cessna 182P · S/N 18263872 · Cancelled Nov 6, 2013 · Registration expired, pending cancellation · Built 1975 · Kurvi Paavo E
- [N3518Z](https://openairdocs.org/deregistered/N3518Z-2013-08-13.md): Piper PA-22-150 · S/N 22-7416 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1960 · Lankford Blaine L
- [N116KU](https://openairdocs.org/deregistered/N116KU-2013-03-21.md): Uhley Kent L ONE-1 · S/N 375206180 · Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1991 · Uhley Kent L
- [N48275](https://openairdocs.org/deregistered/N48275-2012-11-13.md): Taylorcraft DC-65 · S/N 5392 · Cancelled Nov 13, 2012 · Revoked, canceled · Built 1943 · Badrak Alex
- [N90RB](https://openairdocs.org/deregistered/N90RB-2012-09-25.md): Baker Roy G BCA-2 · S/N 1001 · Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1985 · Baker Roy G
- [N1667C](https://openairdocs.org/deregistered/N1667C-2012-07-19.md): Cessna 180 · S/N 30367 · Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1953
- [N5064W](https://openairdocs.org/deregistered/N5064W-2010-04-29.md): Destiny 2000 · S/N 2C0364 · Cancelled Apr 29, 2010 · Exported to Canada · Built 2001 · Knight Roger J
- [N7196K](https://openairdocs.org/deregistered/N7196K-2007-02-07.md): Robinson Helicopter R44 · S/N 0985 · Cancelled Feb 7, 2007 · Exported to Canada · Built 2001 · Continental Helicopters LLC
- [N4101U](https://openairdocs.org/deregistered/N4101U-2004-05-17.md): Dzendel George T KITFOX MOD II · S/N 374 · Cancelled May 17, 2004 · Triennial form not returned · Dzendzel George T
- [N8300T](https://openairdocs.org/deregistered/N8300T-2004-02-13.md): Piper PA-34-200T · S/N 34-8170044 · Cancelled Feb 13, 2004 · Triennial form not returned · Built 1980 · Abc Leasing Inc
- [N4283C](https://openairdocs.org/deregistered/N4283C-1984-07-17.md): Baker Corvair Amphibian BCA-1 · S/N 1002 · Cancelled Jul 17, 1984 · Built 1964 · Baker Gilbert R
- [N64AC](https://openairdocs.org/deregistered/N64AC-1978-03-07.md): Short Bros. & Harland SC7 SERIES 3 · S/N SH1849 · Cancelled Mar 7, 1978 · De Gain William J
- [N411EF](https://openairdocs.org/deregistered/N411EF-1977-03-04.md): Cessna 411 · S/N 411-0081 · Cancelled Mar 4, 1977 · Built 1965 · J & L Aircraft Sale
- [N212AD](https://openairdocs.org/deregistered/N212AD-1973-05-30.md): Piper PA-31 · S/N 31-160 · Cancelled May 30, 1973 · Equitable Engineering Co Inc
- [N96883](https://openairdocs.org/deregistered/N96883-1971-07-26.md): Taylorcraft BC12-D · S/N 9183 · Cancelled Jul 26, 1971 · Sellheim Walbert
- [N23363](https://openairdocs.org/deregistered/N23363-1971-07-17.md): Piper J4A · S/N 4-594 · Cancelled Jul 17, 1971 · Higgs Robert
- [N1234D](https://openairdocs.org/deregistered/N1234D-1971-06-15.md): Cessna 170A · S/N 20117 · Cancelled Jun 15, 1971 · Spencer Alva L
- [N1203D](https://openairdocs.org/deregistered/N1203D-1970-09-02.md): Cessna 170A · S/N 19976 · Cancelled Sep 2, 1970 · Brown Robert M Eugene Brown
- [N1075](https://openairdocs.org/deregistered/N1075-1968-08-15.md): Kapeg 1 K-1 · S/N K-1 · Cancelled Aug 15, 1968 · Joseph C Dovey
- [N13886](https://openairdocs.org/deregistered/N13886-1965-06-08.md): Aeronca C-3 · S/N A-308 · Cancelled Jun 8, 1965 · Exported to Canada · Trainor Tom E
- [N7401K](https://openairdocs.org/deregistered/N7401K-1961-05-31.md): Piper PA-20 · S/N 20-309 · Cancelled May 31, 1961 · Exported to Canada · Flying Ten Aero Club Inc
- [N1157H](https://openairdocs.org/deregistered/N1157H-1957-03-07.md): Aeronca 15AC · S/N 15AC-170 · Cancelled Mar 7, 1957 · Exported to Canada · Built 1948 · Morean William E
- [N43840](https://openairdocs.org/deregistered/N43840-1957-01-09.md): Taylorcraft BC12-D · S/N 7499 · Cancelled Jan 9, 1957 · George V Bodenbach
- [N91473](https://openairdocs.org/deregistered/N91473-1956-12-14.md): North American NAVION · S/N NAV-4-280 · Cancelled Dec 14, 1956 · Brown C Robert
- [N14752](https://openairdocs.org/deregistered/N14752-1956-02-17.md): Fairchild 24 C8C · S/N 2658 · Cancelled Feb 17, 1956 · Built 1934 · Seliga Gerald J
- [N61982](https://openairdocs.org/deregistered/N61982-1956-02-15.md): Boeing A75 · S/N 75-050 · Cancelled Feb 15, 1956 · Roper Harold A
- [N9940H](https://openairdocs.org/deregistered/N9940H-1956-02-14.md): Consolidated Vultee BT-13A · S/N 7321 · Cancelled Feb 14, 1956 · Butler W J & H N Carter
- [N47122](https://openairdocs.org/deregistered/N47122-1955-10-10.md): Taylorcraft/Bacher Scott N DC0-65/L2M · S/N L-4746 · Cancelled Oct 10, 1955 · Muncey James L & Betty Muncey
- [N97144](https://openairdocs.org/deregistered/N97144-1951-07-25.md): Consolidated Vultee BT-13A · S/N 3049 · Cancelled Jul 25, 1951 · Built 1946 · Grattan Donald W
- [N47361](https://openairdocs.org/deregistered/N47361-1951-06-29.md): Aeronca 0-58B · S/N 13404 · Cancelled Jun 29, 1951 · Pierson Glenn W
- [N21368](https://openairdocs.org/deregistered/N21368-1948-06-02.md): Aeronca 65-LA · S/N C-1748 · Cancelled Jun 2, 1948 · Shriber W E
- [N20468](https://openairdocs.org/deregistered/N20468-1948-05-21.md): Welch OW5M · S/N 163 · Cancelled May 21, 1948 · Rydahl Harry
- [N698](https://openairdocs.org/deregistered/N698-1930-05-02.md): Curtiss JN-4 (CANADIAN) · S/N 359 · Cancelled May 2, 1930 · Jeavons J H
- [N795K](https://openairdocs.org/deregistered/N795K-1930-03-22.md): Royal ROYAL AIR TRAINER · S/N 6 · Cancelled Mar 22, 1930 · Built 1929 · Royal Aircraft Corporation

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

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