# Cancelled registrations: Romulus, MI

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

Cancelled aircraft registrations in Romulus, MI.

- [N4142C](https://openairdocs.org/deregistered/N4142C-2020-10-31.md): Stinson 108-3 · S/N 108-5142 · Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1949 · Renner Gerald D
- [N37ES](https://openairdocs.org/deregistered/N37ES-2018-06-08.md): Cessna 150M · S/N 15077084 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1975 · Oquet Jean C
- [N8642K](https://openairdocs.org/deregistered/N8642K-2018-04-06.md): Stinson 108-1 · S/N 1081642 · Cancelled Apr 6, 2018 · Revoked, canceled · Burgus Marvin L
- [N9682R](https://openairdocs.org/deregistered/N9682R-2013-07-01.md): Beech G18S · S/N BA-505 · Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1960 · Hale Aviation Inc
- [N503R](https://openairdocs.org/deregistered/N503R-2013-05-13.md): Olson Randall S RO-2 · S/N 2001-RO-2 · Cancelled May 13, 2013 · First renewal notice · Olson Randall S
- [N17RJ](https://openairdocs.org/deregistered/N17RJ-2012-11-21.md): Jarvis Ronald J BD-4 · S/N 246 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Blan Samuel D
- [N56036](https://openairdocs.org/deregistered/N56036-2012-08-27.md): Cessna T-50 · S/N 5343 · Cancelled Aug 27, 2012 · Revoked, canceled · Built 1943 · Koepke Lee R
- [N37876](https://openairdocs.org/deregistered/N37876-2011-01-21.md): Ozga EASYRISER · S/N X15-238 · Cancelled Jan 21, 2011 · Revoked, pending cancellation · Ozga John S
- [N503R](https://openairdocs.org/deregistered/N503R-1995-11-20.md): Olson Randall S RO-1 · S/N 1992 · Cancelled Nov 20, 1995 · Triennial form not returned · Olson Randall S
- [N8519H](https://openairdocs.org/deregistered/N8519H-1960-05-21.md): North American NAVION · S/N NAV-4-517 · Cancelled May 21, 1960 · Down River Flying Club
- [N43858](https://openairdocs.org/deregistered/N43858-1956-02-29.md): Taylorcraft BC12-D · S/N 7517 · Cancelled Feb 29, 1956 · Laverack Alton J And Robert J Hudgins
- [N21154](https://openairdocs.org/deregistered/N21154-1956-02-22.md): Stinson HW75 · S/N 7046 · Cancelled Feb 22, 1956 · Built 1939 · Dziobak Benjamin
- [N9571H](https://openairdocs.org/deregistered/N9571H-1956-02-14.md): Boeing B75N1 · S/N 75-7305 · Cancelled Feb 14, 1956 · Gorrill Flying Service Inc
- [N1757E](https://openairdocs.org/deregistered/N1757E-1948-11-12.md): Aeronca 7AC · S/N 7AC-5324 · Cancelled Nov 12, 1948 · Built 1946 · Gorrill Thomas M
- [N611V](https://openairdocs.org/deregistered/N611V-1948-02-24.md): Parks P-1 · S/N 1996 · Cancelled Feb 24, 1948 · Wheeler William E
- [N15355](https://openairdocs.org/deregistered/N15355-1941-06-01.md): Piper E-2 · S/N 265 · Cancelled Jun 1, 1941 · Built 1935 · Raulerson Hugh Etal
- [N260V](https://openairdocs.org/deregistered/N260V-1935-10-15.md): Wyandotte Aviation Club WYANDOTTE MODEL 1 · S/N 216 · Cancelled Oct 15, 1935 · Built 1929 · Fauser Hubert J
- [N319H](https://openairdocs.org/deregistered/N319H-1933-10-09.md): Moth 60-GM · S/N 1-I · Cancelled Oct 9, 1933 · Mutual Flying Services

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

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