# Cancelled registrations: Canton, IL

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

Cancelled aircraft registrations in Canton, IL.

- [N3629Q](https://openairdocs.org/deregistered/N3629Q-2018-01-18.md): Beech A23-24 · S/N MA-224 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1967 · Thayer Robert E
- [N412EZ](https://openairdocs.org/deregistered/N412EZ-2017-07-18.md): Snyder James R/Carl D VARIEZE · S/N 1327 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1982 · Snyder James R
- [N593D](https://openairdocs.org/deregistered/N593D-2013-09-30.md): Quinones Marcus A MONI · S/N 320 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1993 · Quinones Marcus A
- [N2263N](https://openairdocs.org/deregistered/N2263N-2013-08-07.md): Inman-Larry KR-2 · S/N LI-1 · Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1978 · Spaulding Robert J
- [N9664D](https://openairdocs.org/deregistered/N9664D-2006-01-09.md): Piper PA-22-150 · S/N 22-6580 · Cancelled Jan 9, 2006 · Built 1959 · Koon Robert S
- [N4465L](https://openairdocs.org/deregistered/N4465L-2000-08-16.md): Cessna 172G · S/N 17254560 · Cancelled Aug 16, 2000 · Triennial form not returned · Bump Charles E
- [N2900G](https://openairdocs.org/deregistered/N2900G-1998-04-27.md): Callair A-5 · S/N 255 · Cancelled Apr 27, 1998 · Triennial form not returned · Reinholtz E J
- [N6540U](https://openairdocs.org/deregistered/N6540U-1975-09-02.md): Mooney M20C · S/N 2323 · Cancelled Sep 2, 1975 · Varner Gene
- [N5961D](https://openairdocs.org/deregistered/N5961D-1972-11-03.md): Piper PA-22-150 · S/N 22-4625 · Cancelled Nov 3, 1972 · Built 1957 · Richardson Rodney D
- [N96483](https://openairdocs.org/deregistered/N96483-1970-09-14.md): Taylorcraft BC12-D · S/N 8783 · Cancelled Sep 14, 1970 · Lundry Flying Service
- [N4447D](https://openairdocs.org/deregistered/N4447D-1970-06-29.md): Beech G35 · S/N D-4587 · Cancelled Jun 29, 1970 · Canton Daily Ledger Inc
- [N95397](https://openairdocs.org/deregistered/N95397-1970-06-17.md): Taylorcraft BC12-D · S/N 9797 · Cancelled Jun 17, 1970 · Nagel Ivan R / Arthur Reinholtz
- [N102P](https://openairdocs.org/deregistered/N102P-1970-06-05.md): Aeronca 7AC · S/N 7AC-4436 · Cancelled Jun 5, 1970 · Built 1946 · Weese Robert V & Boone Thomas E
- [N2266K](https://openairdocs.org/deregistered/N2266K-1956-02-14.md): Luscombe 8A · S/N 4993 · Cancelled Feb 14, 1956 · Organ John E & Ellis L Maxwell
- [N61938](https://openairdocs.org/deregistered/N61938-1955-11-15.md): Fairchild M-62A · S/N T43-5423 · Cancelled Nov 15, 1955 · Nebergall Paul
- [N96982](https://openairdocs.org/deregistered/N96982-1952-09-16.md): Taylorcraft BC12-D · S/N 9282 · Cancelled Sep 16, 1952 · Lundry L B
- [N92172](https://openairdocs.org/deregistered/N92172-1948-10-13.md): Piper J3C-65 · S/N 16613 · Cancelled Oct 13, 1948 · Pilcher Samuel B

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

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