# Cancelled registrations: Metropolis, IL

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

Cancelled aircraft registrations in Metropolis, IL.

- [N4552Y](https://openairdocs.org/deregistered/N4552Y-2020-06-12.md): Piper PA-25-235 · S/N 25-4205 · Cancelled Jun 12, 2020 · Revoked, canceled · Built 1967 · Chapman Larry
- [N7566D](https://openairdocs.org/deregistered/N7566D-2018-10-01.md): Fleetwood Jack TEAM AIRBIKE · S/N AB000154 · Cancelled Oct 1, 2018 · Sale reported, canceled · Built 2005
- [N5534C](https://openairdocs.org/deregistered/N5534C-2017-11-21.md): Cessna 170B · S/N 19581 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1950 · Wemhoener Oil Promotion Co
- [N4349N](https://openairdocs.org/deregistered/N4349N-2013-07-30.md): Mann Charles Russell DK-1 · S/N 133 · Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1992
- [N9545G](https://openairdocs.org/deregistered/N9545G-2013-07-29.md): Cessna A188B · S/N 18801523T · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1974 · C&C Aviation Inc
- [N7243Z](https://openairdocs.org/deregistered/N7243Z-2013-05-06.md): Piper PA-25-235 · S/N 25-3169 · Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1965 · C & D Aviation
- [N7080Z](https://openairdocs.org/deregistered/N7080Z-2012-09-21.md): Piper PA-25-235 · S/N 25-2864 · Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1964 · C & D Aviation Inc
- [N4907U](https://openairdocs.org/deregistered/N4907U-2011-01-19.md): Cessna 210E · S/N 21058607 · Cancelled Jan 19, 2011 · Exported to Mexico · Built 1965 · Burkey Theodore W
- [N1348J](https://openairdocs.org/deregistered/N1348J-2010-07-21.md): Rockwell International 112A · S/N 348 · Cancelled Jul 21, 2010 · Triennial form not returned · Built 1975 · Jones Gary F
- [N42327](https://openairdocs.org/deregistered/N42327-1996-10-31.md): Piper PA-34-200 · S/N 347450170 · Cancelled Oct 31, 1996 · Triennial form not returned · Gallagher Marilyn P
- [N1559Q](https://openairdocs.org/deregistered/N1559Q-1983-04-16.md): Cessna 150L · S/N 15072859 · Cancelled Apr 16, 1983 · Administratively canceled · Gallagher Robert
- [N6581Z](https://openairdocs.org/deregistered/N6581Z-1981-10-20.md): Piper PA-25-235 · S/N 25-2135 · Cancelled Oct 20, 1981 · Sale reported · Built 1962
- [N62442](https://openairdocs.org/deregistered/N62442-1965-05-22.md): Cessna T-50 · S/N 3324 · Cancelled May 22, 1965 · Stoker Charles C
- [N46840](https://openairdocs.org/deregistered/N46840-1955-08-02.md): Fairchild M-62A · S/N T43-5968 · Cancelled Aug 2, 1955 · Tobin Robert
- [N3252N](https://openairdocs.org/deregistered/N3252N-1953-11-20.md): Piper J3C-65 · S/N 22443 · Cancelled Nov 20, 1953 · Ohio Valley Aviation
- [N76597](https://openairdocs.org/deregistered/N76597-1951-08-22.md): Cessna 140 · S/N 11037 · Cancelled Aug 22, 1951 · Gray W A
- [N2946E](https://openairdocs.org/deregistered/N2946E-1950-12-14.md): Aeronca 7AC · S/N 7AC-6532 · Cancelled Dec 14, 1950 · Ohio Valley Aviation Service
- [N26478](https://openairdocs.org/deregistered/N26478-1950-07-20.md): Meyers OTW · S/N 31 · Cancelled Jul 20, 1950 · Ohio Valley Aviation Service
- [N3904B](https://openairdocs.org/deregistered/N3904B-1949-12-20.md): Consolidated Vultee BT-15 · S/N 8496 · Cancelled Dec 20, 1949 · Clairday Willard L

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

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