# Cancelled registrations: Dekalb, IL

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

Cancelled aircraft registrations in Dekalb, IL.

- [N468KM](https://openairdocs.org/deregistered/N468KM-2021-01-09.md): Pphu Ekolot KR-030 TOPAZ · S/N 30-08-03 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 2017 · North Illinois Union Group Aircraft Division Inc
- [N65855](https://openairdocs.org/deregistered/N65855-2020-05-08.md): Schweizer SGS 2-33A · S/N 345 · Cancelled May 8, 2020 · Sale reported, canceled · Built 1974
- [N7014D](https://openairdocs.org/deregistered/N7014D-2020-01-24.md): Piper PA-22-150 · S/N 22-4907 · Cancelled Jan 24, 2020 · Revoked, canceled · Built 1957 · Taylor Willard Rue DBA
- [N630B](https://openairdocs.org/deregistered/N630B-2018-04-24.md): Beck Robert BB-1 · S/N 001 · Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Beck Robert O
- [N4050W](https://openairdocs.org/deregistered/N4050W-2015-05-06.md): Fisher Michael E FISHER BIPLANE · S/N B0010 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Pinckney Leith A
- [N43910](https://openairdocs.org/deregistered/N43910-2012-11-29.md): Taylorcraft BC12-D · S/N 7569 · Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1946 · Dienst Lon C
- [N2053P](https://openairdocs.org/deregistered/N2053P-2012-08-08.md): Piper PA-23-150 · S/N 23-637 · Cancelled Aug 8, 2012 · Sale reported, canceled
- [N10979](https://openairdocs.org/deregistered/N10979-2011-02-18.md): Cessna 150L · S/N 15075183 · Cancelled Feb 18, 2011 · Exported to Argentina · Built 1973
- [N97393](https://openairdocs.org/deregistered/N97393-2009-09-18.md): Stinson 108 · S/N 108-393 · Cancelled Sep 18, 2009 · Registration revoked · Built 1946 · Taylor Willard R
- [N290Y](https://openairdocs.org/deregistered/N290Y-2009-06-25.md): Beech F17D · S/N 258 · Cancelled Jun 25, 2009 · Exported to Australia · Built 1939 · Dienst Lon C
- [N700R](https://openairdocs.org/deregistered/N700R-1986-01-09.md): Rockwell International 690B · S/N 11434 · Cancelled Jan 9, 1986 · Dekalb Agresearch Inc
- [N8531W](https://openairdocs.org/deregistered/N8531W-1983-09-14.md): Piper PA-28-235 · S/N 28-10032 · Cancelled Sep 14, 1983 · Administratively canceled · The Dekalb Bank
- [N6507H](https://openairdocs.org/deregistered/N6507H-1981-05-19.md): Piper J3C-65 · S/N 19694 · Cancelled May 19, 1981 · Exported to Iceland · Taylor Willard R
- [N2563A](https://openairdocs.org/deregistered/N2563A-1980-11-05.md): Piper PA-22-135 · S/N 22-858 · Cancelled Nov 5, 1980 · Bennett Jack
- [N6150R](https://openairdocs.org/deregistered/N6150R-1974-05-08.md): Cessna T210F · S/N T210-0050 · Cancelled May 8, 1974 · University National Bank Of Dekalb
- [N7996D](https://openairdocs.org/deregistered/N7996D-1971-02-12.md): Beech H35 · S/N D-5289 · Cancelled Feb 12, 1971 · Robinson Nelson M
- [N6120X](https://openairdocs.org/deregistered/N6120X-1971-02-01.md): Aero Commander 500 · S/N 500B-948-14 · Cancelled Feb 1, 1971 · Robinson Nelson M
- [N5729B](https://openairdocs.org/deregistered/N5729B-1971-01-29.md): Cessna 182 · S/N 33729 · Cancelled Jan 29, 1971 · Built 1956 · Robinson Nelson M/DBA Hawk Aviation
- [N5263P](https://openairdocs.org/deregistered/N5263P-1971-01-22.md): Piper PA-24-250 · S/N 24-299 · Cancelled Jan 22, 1971 · R & W Aircraft Services
- [N2944Y](https://openairdocs.org/deregistered/N2944Y-1970-12-31.md): Cessna 182E · S/N 18253944 · Cancelled Dec 31, 1970 · Built 1962 · Robinson Nelson M DBA Hawk Aviation
- [N3274U](https://openairdocs.org/deregistered/N3274U-1970-11-17.md): Cessna 182F · S/N 18254674 · Cancelled Nov 17, 1970 · Robinson Nelson M /DBA Hawk Aviation
- [N6109X](https://openairdocs.org/deregistered/N6109X-1963-02-01.md): Aero Commander 500-B · S/N 500B-949-15 · Cancelled Feb 1, 1963 · Dekalb Agricultural Association Inc
- [N1079B](https://openairdocs.org/deregistered/N1079B-1962-04-09.md): Mooney M20A · S/N 1305 · Cancelled Apr 9, 1962 · Exported to United Kingdom · Elliott James R
- [N4341N](https://openairdocs.org/deregistered/N4341N-1956-07-12.md): Cessna 195 · S/N 7068 · Cancelled Jul 12, 1956 · Built 1947 · Schoemperlen Edwin G
- [N79089](https://openairdocs.org/deregistered/N79089-1954-01-07.md): Boeing A75N1 · S/N 75-4917 · Cancelled Jan 7, 1954 · Fawcett Jerome W
- [N9365](https://openairdocs.org/deregistered/N9365-1936-03-15.md): Irwin M T 2 · S/N 1 SUB · Cancelled Mar 15, 1936 · Dresser Walter J

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

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