# Cancelled registrations: Marion, IL

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

Cancelled aircraft registrations in Marion, IL.

- [N97WD](https://openairdocs.org/deregistered/N97WD-2021-09-02.md): Beech B100 · S/N BE-97 · Cancelled Sep 2, 2021 · Heartland Motion Transportation LLC
- [N4783A](https://openairdocs.org/deregistered/N4783A-2020-07-10.md): Piper PA-22-150 · S/N 22-3934 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1956 · Rees W N Jr
- [N4986S](https://openairdocs.org/deregistered/N4986S-2020-05-01.md): Rockwell International 114 · S/N 14019 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Ross Steve M
- [N557RS](https://openairdocs.org/deregistered/N557RS-2018-12-28.md): DJI INSPIRE 1 · S/N 0410038811 · Cancelled Dec 28, 2018 · Registration expired, pending cancellation · Sutton Ray E
- [N9879K](https://openairdocs.org/deregistered/N9879K-2017-03-10.md): Piper PA-28-161 · S/N 28-7816202 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1977 · Aerotaxi LLC DBA Aeroflite Sales & Charter
- [N5666Y](https://openairdocs.org/deregistered/N5666Y-2014-10-28.md): Piper PA-23-250 · S/N 27-2781 · Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1965 · White Bros Equip
- [N8450K](https://openairdocs.org/deregistered/N8450K-2005-08-17.md): Piper PA-28-181 · S/N 28-8290042 · Cancelled Aug 17, 2005 · Triennial form not returned · Built 1981 · Stoker Charles C
- [N5370E](https://openairdocs.org/deregistered/N5370E-1970-12-30.md): Beech K35 · S/N D-5860 · Cancelled Dec 30, 1970 · Fabick Machinery Company
- [N59R](https://openairdocs.org/deregistered/N59R-1970-11-23.md): Russell Gyroplane BR-2 · S/N 1 · Cancelled Nov 23, 1970 · Russell Aircraft Corp
- [N8894A](https://openairdocs.org/deregistered/N8894A-1965-05-21.md): Beech B35 · S/N D2592 · Cancelled May 21, 1965 · Valentin Air Service
- [N121R](https://openairdocs.org/deregistered/N121R-1965-05-18.md): Aeroflite Autogyro DGH-1 · S/N 1 · Cancelled May 18, 1965 · Aeroflite Inc
- [N9729R](https://openairdocs.org/deregistered/N9729R-1964-04-20.md): Beech K35 · S/N D-6198 · Cancelled Apr 20, 1964 · Fabick Machinery Co
- [N4432E](https://openairdocs.org/deregistered/N4432E-1953-07-01.md): Aeronca 7DC · S/N 7DC66 · Cancelled Jul 1, 1953 · Exported to Canada · Midwestern Weed And Pest Control Inc
- [N39345](https://openairdocs.org/deregistered/N39345-1951-06-27.md): Aeronca 65-TAL · S/N L4392TA · Cancelled Jun 27, 1951 · Built 1945 · Blankenship Robert
- [N1723V](https://openairdocs.org/deregistered/N1723V-1950-10-09.md): Cessna 120 · S/N 13908 · Cancelled Oct 9, 1950 · Southern Illinois Airways Inc
- [N32553](https://openairdocs.org/deregistered/N32553-1949-07-01.md): Piper J5A · S/N 5-333 · Cancelled Jul 1, 1949 · Valentin Fred C
- [N643Y](https://openairdocs.org/deregistered/N643Y-1941-05-15.md): Waco INF · S/N 3381 · Cancelled May 15, 1941 · Valentin Fred C
- [N938](https://openairdocs.org/deregistered/N938-1933-02-10.md): Standard J-1 · S/N 559 · Cancelled Feb 10, 1933 · Built 1927 · Gray Eagle Flyling Service Corp
- [N10934](https://openairdocs.org/deregistered/N10934-1932-10-04.md): Curtiss Wright CW-1 · S/N 1113 · Cancelled Oct 4, 1932 · Built 1931 · Marion Flying Club

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

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