# Cancelled registrations: Roselle, IL

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

Cancelled aircraft registrations in Roselle, IL.

- [N5245Z](https://openairdocs.org/deregistered/N5245Z-2019-12-12.md): Piper PA-22-108 · S/N 22-8927 · Cancelled Dec 12, 2019 · Revoked, pending cancellation · Built 1961 · B & M Acft Corp
- [N751NC](https://openairdocs.org/deregistered/N751NC-2019-10-05.md): DJI PHANTOM 2 VISION + · S/N PH645474147 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Case Foundation Co
- [N70MJ](https://openairdocs.org/deregistered/N70MJ-2018-01-23.md): Bellanca 8KCAB · S/N 221-75 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1975 · Trinair Aviation Inc
- [N241V](https://openairdocs.org/deregistered/N241V-2017-11-22.md): Cessna 140 · S/N 14693 · Cancelled Nov 22, 2017 · Revoked, canceled · Built 1948 · Roselle Beechcraft Sales Inc
- [N73608](https://openairdocs.org/deregistered/N73608-2017-02-04.md): Fairchild M-62A · S/N FV676 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1944 · Melone Edward
- [N757XF](https://openairdocs.org/deregistered/N757XF-2015-05-13.md): Cessna 152 · S/N 15280080 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1977 · J C R Aviation Inc
- [N61XT](https://openairdocs.org/deregistered/N61XT-2013-08-29.md): Skykits SAVANNAH VGW · S/N 10-03-51-905 · Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2011
- [N190DG](https://openairdocs.org/deregistered/N190DG-2013-06-07.md): Galovich David J LONG EZ · S/N 39 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Galovich David J
- [N39LC](https://openairdocs.org/deregistered/N39LC-2013-05-13.md): Schlamer Robert B PITTS S-1-E · S/N 8-0111 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1986 · Coltrin Lorence C
- [N56093](https://openairdocs.org/deregistered/N56093-2013-04-22.md): Piper PA-28R-200 · S/N 28R-7335352 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1973 · Wilson William
- [N8228G](https://openairdocs.org/deregistered/N8228G-2013-02-27.md): Cessna 172N · S/N 17273617 · Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1979
- [N2687](https://openairdocs.org/deregistered/N2687-2013-02-21.md): Troy PITTS SPECIAL S-1C · S/N GJT-1 · Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1975 · Scheberle Donald R
- [N1590](https://openairdocs.org/deregistered/N1590-2012-08-08.md): Simpson-Beaty-Zimmerman ZBS BREEZY · S/N LOF-1 · Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1969 · Amidon Earl R
- [N959VP](https://openairdocs.org/deregistered/N959VP-2000-08-08.md): Dehavilland DH104 DOVE 7A · S/N 04088 · Cancelled Aug 8, 2000 · Exported to United Kingdom · Coltrin Lorence C
- [N1846J](https://openairdocs.org/deregistered/N1846J-1993-05-06.md): Piper PA-28-140 · S/N 2824282 · Cancelled May 6, 1993
- [N2421A](https://openairdocs.org/deregistered/N2421A-1991-05-29.md): Piper PA-38-112 · S/N 3878A0675 · Cancelled May 29, 1991 · Exported to United Kingdom · Coloby Jeffrey G
- [N2758P](https://openairdocs.org/deregistered/N2758P-1991-03-29.md): Piper PA-22-150 · S/N 223065 · Cancelled Mar 29, 1991 · Triennial form not returned · Heller Terry
- [N487A](https://openairdocs.org/deregistered/N487A-1991-03-25.md): Kehoe Frank J GYROPLANE · S/N 1 · Cancelled Mar 25, 1991 · Triennial form not returned · Kehoe Frank J
- [N7737S](https://openairdocs.org/deregistered/N7737S-1983-05-09.md): Schweizer SGS 1-26D · S/N 437 · Cancelled May 9, 1983 · Proctor Jerry L
- [N3943K](https://openairdocs.org/deregistered/N3943K-1977-07-06.md): Piper PA-28-140 · S/N 28-23818 · Cancelled Jul 6, 1977 · Lloyd Richard E
- [N5773Z](https://openairdocs.org/deregistered/N5773Z-1975-11-04.md): Piper PA-22-108 · S/N 22-9616 · Cancelled Nov 4, 1975 · Lloyd R E
- [N5328Z](https://openairdocs.org/deregistered/N5328Z-1975-04-29.md): Piper PA-22-108 · S/N 229033 · Cancelled Apr 29, 1975 · Richard Lloyd E
- [N5699Z](https://openairdocs.org/deregistered/N5699Z-1975-03-13.md): Piper PA-22-108 · S/N 22-9536 · Cancelled Mar 13, 1975 · R E Lloyd
- [N5747Z](https://openairdocs.org/deregistered/N5747Z-1974-04-23.md): Piper PA-22-108 · S/N 22-9586 · Cancelled Apr 23, 1974 · Lloyd Richard E
- [N4660Z](https://openairdocs.org/deregistered/N4660Z-1972-11-24.md): Piper PA-22-108 · S/N 22-8186 · Cancelled Nov 24, 1972 · Willis Timothy J
- [N8178W](https://openairdocs.org/deregistered/N8178W-1972-01-14.md): Piper PA-28-180 · S/N 28-2302 · Cancelled Jan 14, 1972 · Lloyd Richard E
- [N3825B](https://openairdocs.org/deregistered/N3825B-1971-10-21.md): Beech F35 · S/N D4094 · Cancelled Oct 21, 1971 · B & M Aircraft Corp
- [N3538R](https://openairdocs.org/deregistered/N3538R-1971-08-25.md): Beech A23 · S/N M-706 · Cancelled Aug 25, 1971 · Roselle Beechcraft Sales Inc
- [N1449L](https://openairdocs.org/deregistered/N1449L-1971-08-16.md): Beech A23 · S/N M844 · Cancelled Aug 16, 1971 · B & M Aircraft Corp
- [N76642](https://openairdocs.org/deregistered/N76642-1970-12-07.md): Cessna 120 · S/N 11082 · Cancelled Dec 7, 1970 · Hamilton Verlon D
- [N5670S](https://openairdocs.org/deregistered/N5670S-1967-11-09.md): Beech A23-19 · S/N MB-109 · Cancelled Nov 9, 1967 · Built 1966 · B And M Aircraft Corp
- [N1619K](https://openairdocs.org/deregistered/N1619K-1967-09-29.md): Luscombe 8A · S/N 4346 · Cancelled Sep 29, 1967 · Cook Cecil C
- [N48306](https://openairdocs.org/deregistered/N48306-1956-12-04.md): Ryan Aeronautical ST3KR · S/N 1865 · Cancelled Dec 4, 1956 · Kresmery K A Loman E Melone

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

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