# Cancelled registrations: Harvey, IL

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

Cancelled aircraft registrations in Harvey, IL.

- [N5506Q](https://openairdocs.org/deregistered/N5506Q-2024-10-12.md): Mooney M20E · S/N 606 · Cancelled Oct 12, 2024 · Revoked, canceled · Built 1965 · Great Lakes Flying Club Inc
- [N2138E](https://openairdocs.org/deregistered/N2138E-2019-10-25.md): Aeronca 7AC · S/N 7AC5709 · Cancelled Oct 25, 2019 · Revoked, canceled · Built 1946 · Zummallen A L
- [N3054G](https://openairdocs.org/deregistered/N3054G-2018-03-23.md): Aircoupe F-1A · S/N 5757 · Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1961 · Tanner Perry A
- [N2168H](https://openairdocs.org/deregistered/N2168H-2018-03-21.md): Engineering & Research ERCOUPE 415-C · S/N 2791 · Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1946 · Tanner Perry A
- [N931PD](https://openairdocs.org/deregistered/N931PD-2017-07-12.md): Bell UH-1H · S/N 65-09939 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · City Of Harvey Police Department
- [N2545E](https://openairdocs.org/deregistered/N2545E-2014-12-02.md): Griffin Frank W B-8M · S/N 1 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Griffin Frank W
- [N632](https://openairdocs.org/deregistered/N632-2013-08-05.md): Nardi FN-333 · S/N 0111 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1964 · Reinders William T
- [N3857H](https://openairdocs.org/deregistered/N3857H-1993-03-05.md): Engineering & Research 415-C · S/N 4558 · Cancelled Mar 5, 1993 · Triennial form not returned · Tanner Perry A
- [N9289E](https://openairdocs.org/deregistered/N9289E-1978-12-06.md): Aeronca 11AC · S/N 11AC-926 · Cancelled Dec 6, 1978 · Built 1946 · Jona Kent Nehring
- [N173V](https://openairdocs.org/deregistered/N173V-1972-05-04.md): North American SNJ-4 · S/N 88-13779 · Cancelled May 4, 1972 · Vik Carl
- [N8718H](https://openairdocs.org/deregistered/N8718H-1969-12-19.md): North American NAVION · S/N NAV-4-718 · Cancelled Dec 19, 1969 · Four Seasons Flying Club
- [N26022](https://openairdocs.org/deregistered/N26022-1965-05-18.md): Piper J3C-65 · S/N 3971 · Cancelled May 18, 1965 · Built 1939 · Nyeholt E And Meyer B
- [N61624](https://openairdocs.org/deregistered/N61624-1956-02-15.md): Consolidated Vultee BT-13A · S/N 8354 · Cancelled Feb 15, 1956 · Twenty Feathers Flying Club
- [N72138](https://openairdocs.org/deregistered/N72138-1952-02-19.md): Cessna 140 · S/N 9305 · Cancelled Feb 19, 1952 · Beverly Air Service Inc
- [N2454B](https://openairdocs.org/deregistered/N2454B-1952-01-16.md): Temco GC-1B · S/N 3754 · Cancelled Jan 16, 1952 · Stevenson G A
- [N34640](https://openairdocs.org/deregistered/N34640-1951-07-31.md): Stinson 10A · S/N 8040 · Cancelled Jul 31, 1951 · Thompson L H
- [N40055](https://openairdocs.org/deregistered/N40055-1951-04-12.md): North American P-51K · S/N 111-30-272 · Cancelled Apr 12, 1951 · Built 1944 · Newhall Wilson V
- [N1129H](https://openairdocs.org/deregistered/N1129H-1950-08-30.md): Aeronca 15AC · S/N 15AC-58 · Cancelled Aug 30, 1950 · Built 1948 · Beverly Air Service Incorporated
- [N51801](https://openairdocs.org/deregistered/N51801-1949-02-10.md): Aeronca 0-58B · S/N 11463 · Cancelled Feb 10, 1949 · William R Jacobs
- [N51813](https://openairdocs.org/deregistered/N51813-1949-02-10.md): Aeronca 0-58B · S/N 13484 · Cancelled Feb 10, 1949 · Built 1945 · Jacobs William R
- [N48333](https://openairdocs.org/deregistered/N48333-1949-02-08.md): Ryan Aeronautical ST3KR · S/N 1621 · Cancelled Feb 8, 1949 · Built 1941 · Jacobs William R
- [N47270](https://openairdocs.org/deregistered/N47270-1948-12-31.md): Aeronca 0-58B · S/N 058B-10333 · Cancelled Dec 31, 1948 · Spiewak Geo & Ed Merkner
- [N642K](https://openairdocs.org/deregistered/N642K-1948-02-10.md): Cessna DC6B · S/N 222 · Cancelled Feb 10, 1948 · Thornton Junior College
- [N3033K](https://openairdocs.org/deregistered/N3033K-1947-08-21.md): Culver V · S/N V-252 · Cancelled Aug 21, 1947 · Stevenson G A
- [N579V](https://openairdocs.org/deregistered/N579V-1938-03-15.md): Command-Aire 3C-3 · S/N 646 · Cancelled Mar 15, 1938 · Haas William J
- [N2416](https://openairdocs.org/deregistered/N2416-1932-02-16.md): Curtiss JN4D · S/N 44407 · Cancelled Feb 16, 1932 · Bradley Fred A

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

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