# Cancelled registrations: Sycamore, IL

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

Cancelled aircraft registrations in Sycamore, IL.

- [N12040](https://openairdocs.org/deregistered/N12040-2023-08-31.md): Minicab GY-20 · S/N 1585 · Cancelled Aug 31, 2023 · Revoked, pending cancellation · Built 1966 · Bodeen Gilbert W
- [N5271A](https://openairdocs.org/deregistered/N5271A-2019-04-10.md): Cessna 310 · S/N 35471 · Cancelled Apr 10, 2019 · First renewal notice · Anderson David R
- [N360TW](https://openairdocs.org/deregistered/N360TW-2017-07-12.md): Hubbard Chase BENSEN GYRO B-8M · S/N CH1 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Hubbard Chase L
- [N6457A](https://openairdocs.org/deregistered/N6457A-2013-07-02.md): Aerostar International RX-7 · S/N RX7-3079 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Poe Richard A
- [N162MC](https://openairdocs.org/deregistered/N162MC-2012-03-14.md): Mccall Ryan L ROTORWAY 162F · S/N 6493 · Cancelled Mar 14, 2012 · Second renewal notice · Built 2001 · Doonan Stephen J
- [N235WC](https://openairdocs.org/deregistered/N235WC-2011-11-09.md): Conkey D R / Wapelhorst J A LANCAIR 235 · S/N 001 · Cancelled Nov 9, 2011 · Exported to Canada · Built 1992 · Auman James L
- [N750LC](https://openairdocs.org/deregistered/N750LC-2009-04-15.md): Carlson Larry LANCAIR PROPJET · S/N LIV-526 · Cancelled Apr 15, 2009 · Triennial form not returned · Carlson Scott
- [N154BB](https://openairdocs.org/deregistered/N154BB-1996-12-19.md): Beech 200 · S/N BB748 · Cancelled Dec 19, 1996 · Exported to Zimbabwe · Brian Bemis Automotive Group Ltd
- [N1525X](https://openairdocs.org/deregistered/N1525X-1995-10-31.md): Balloon Works FIREFLY 7-B · S/N 10326 · Cancelled Oct 31, 1995 · Triennial form not returned · Ringo Kelley J
- [N5090D](https://openairdocs.org/deregistered/N5090D-1977-07-07.md): Cessna 182A · S/N 51190 · Cancelled Jul 7, 1977 · Deutsch Emelia
- [N1327V](https://openairdocs.org/deregistered/N1327V-1965-09-07.md): Fleet 16B · S/N 408 · Cancelled Sep 7, 1965 · Exported to Canada · Built 1942 · Frost Charle F
- [N87025](https://openairdocs.org/deregistered/N87025-1965-05-20.md): Ercoupe 415-C · S/N 198 · Cancelled May 20, 1965 · Swanson Aero Service
- [N2474](https://openairdocs.org/deregistered/N2474-1965-05-14.md): Nieuport 17 · S/N C-1 · Cancelled May 14, 1965 · Exported to Canada · Swanson Carl R
- [N8343A](https://openairdocs.org/deregistered/N8343A-1964-03-03.md): Cessna 170B · S/N 25195 · Cancelled Mar 3, 1964 · C.R.K. Flying Club Inc
- [N57503](https://openairdocs.org/deregistered/N57503-1955-08-19.md): Taylorcraft DCO-65 · S/N 4458 · Cancelled Aug 19, 1955 · Edwards W H & J R Sceibe
- [N85689](https://openairdocs.org/deregistered/N85689-1955-07-15.md): Aeronca 7AC · S/N 7AC-4435 · Cancelled Jul 15, 1955 · Exported to Canada · Swanson Aero Service

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

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