# Cancelled registrations: Crystal Lake, IL

A list on [Crystal Lake, IL](https://openairdocs.org/faa-place/IL/Crystal%20Lake.md).

Cancelled aircraft registrations in Crystal Lake, IL.

Page 1 of 2 · 56 registrations

- [N769M](https://openairdocs.org/deregistered/N769M-2023-03-27.md): Israel Aircraft Industries 1124A · S/N 344 · Cancelled Mar 27, 2023 · Klockenga Matthew B
- [N81SG](https://openairdocs.org/deregistered/N81SG-2023-03-01.md): Cessna TU206F · S/N U20603038 · Cancelled Mar 1, 2023 · Exported to Guatemala · Built 1975
- [N42079](https://openairdocs.org/deregistered/N42079-2022-12-22.md): Piper PA-31-350 · S/N 31-7405488 · Cancelled Dec 22, 2022 · Exported to Canada · Built 1974 · Klockenga Matthew
- [N652SS](https://openairdocs.org/deregistered/N652SS-2022-06-04.md): DJI INSPIRE 1 · S/N W13DCB15020177 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Satellite Technology Systems Inc
- [N6743B](https://openairdocs.org/deregistered/N6743B-2021-07-27.md): Piper PA-22-150 · S/N 22-4077 · Cancelled Jul 27, 2021 · Revoked, canceled · Built 1956 · Morgan Franklin A
- [N947GS](https://openairdocs.org/deregistered/N947GS-2020-05-06.md): Gates Learjet 35A · S/N 250 · Cancelled May 6, 2020 · Exported to Mexico · Built 1979 · Saldana Air LLC
- [N652ES](https://openairdocs.org/deregistered/N652ES-2019-06-29.md): DJI S1000+ · S/N 03Q0012229 · Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Satellite Technology Systems Inc
- [N3665Z](https://openairdocs.org/deregistered/N3665Z-2019-01-15.md): Balloon Works FIREFLY 7 · S/N F7-061 · Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1983 · Hill Dave A
- [N5046S](https://openairdocs.org/deregistered/N5046S-2018-01-23.md): Piper PA-28R-200 · S/N 28R-35792 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1970 · Lockart Dale
- [N69404](https://openairdocs.org/deregistered/N69404-2018-01-23.md): Cessna 402B · S/N 402B0537 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Aircraft Sales Corp
- [N97CM](https://openairdocs.org/deregistered/N97CM-2018-01-10.md): Beech A36 · S/N E-1119 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1977 · Aircraft Sales Corp
- [N6645G](https://openairdocs.org/deregistered/N6645G-2018-01-08.md): Beech V35B · S/N D-10271 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1979 · Aircraft Sales Corp
- [N5852M](https://openairdocs.org/deregistered/N5852M-2018-01-05.md): Cessna 340 · S/N 340-0055 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1972 · Aircraft Sales Corp
- [N6111C](https://openairdocs.org/deregistered/N6111C-2018-01-05.md): Beech A36 · S/N E-1955 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1981 · Aircraft Sales Corp
- [N6655T](https://openairdocs.org/deregistered/N6655T-2017-10-31.md): Beech V35B · S/N D-10274 · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Aircraft Sales Corp
- [N7253Z](https://openairdocs.org/deregistered/N7253Z-2017-10-31.md): Beech A36 · S/N E-2279 · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1985 · Aircraft Sales Corp
- [N2048D](https://openairdocs.org/deregistered/N2048D-2017-10-27.md): Beech V35B · S/N D-10192 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Aircraft Sales Corp
- [N4682C](https://openairdocs.org/deregistered/N4682C-2017-10-27.md): Cessna T303 · S/N T30300115 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1982 · Aircraft Sales Corp
- [N6144U](https://openairdocs.org/deregistered/N6144U-2017-10-27.md): Cessna T210R · S/N 21064912 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Aircraft Sales Corp
- [N8442F](https://openairdocs.org/deregistered/N8442F-2017-10-26.md): Cessna 340 · S/N 340-0159 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1972 · Aircraft Sales Corp
- [N8682K](https://openairdocs.org/deregistered/N8682K-2017-10-26.md): Cessna 340A · S/N 340A0617 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales Corp
- [N1701G](https://openairdocs.org/deregistered/N1701G-2017-10-25.md): Cessna 340 · S/N 340-0512 · Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 1974 · Aircraft Sales Corp
- [N837L](https://openairdocs.org/deregistered/N837L-2017-10-20.md): Piper PA-23-250 · S/N 27-3181 · Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1966 · Aircraft Sales Corp
- [N9151F](https://openairdocs.org/deregistered/N9151F-2017-10-20.md): Piper PA-23-250 · S/N 27-4580 · Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1970 · Aircraft Sales Corp
- [N6035Y](https://openairdocs.org/deregistered/N6035Y-2017-10-06.md): Piper PA-23-250 · S/N 27-3220 · Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1966 · Aircraft Sales Corp
- [N94640](https://openairdocs.org/deregistered/N94640-2017-10-06.md): Cessna 182Q · S/N 18266470 · Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales Corp
- [N3978H](https://openairdocs.org/deregistered/N3978H-2017-09-26.md): Mooney M20J · S/N 24-0999 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1980 · Aircraft Sales Corp
- [N8180R](https://openairdocs.org/deregistered/N8180R-2017-06-30.md): Beech 58 · S/N TH-522 · Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1974 · Aircraft Sales Corp
- [N4065A](https://openairdocs.org/deregistered/N4065A-2017-06-21.md): Balloon Works FIREFLY 7 · S/N 10006 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1979 · Koehler Keith
- [N4979G](https://openairdocs.org/deregistered/N4979G-2017-06-07.md): Cessna 172N · S/N 17273526 · Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · Aircraft Sales Corp
- [N432AR](https://openairdocs.org/deregistered/N432AR-2017-05-22.md): Cessna P210N · S/N P21000098 · Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales Corp
- [N587C](https://openairdocs.org/deregistered/N587C-2015-05-19.md): Piper PA-32R-301T · S/N 3257324 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 2003 · Aircraft Sales Corp
- [N25WR](https://openairdocs.org/deregistered/N25WR-2014-11-26.md): Rosenthal William CHRISTEN EAGLE II · S/N ROSENTHAL-0001 · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Rosenthal William
- [N37221](https://openairdocs.org/deregistered/N37221-2013-08-19.md): Cessna T310R · S/N 310R0961 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1977
- [N7858B](https://openairdocs.org/deregistered/N7858B-2013-06-12.md): Beech 58TC · S/N TK-64 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1978 · Aircraft Sales Corp
- [N6871B](https://openairdocs.org/deregistered/N6871B-2013-05-02.md): Cessna 340A · S/N 340A1517 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1982 · Aircraft Sales Corp
- [N5788Z](https://openairdocs.org/deregistered/N5788Z-2013-02-21.md): Piper PA-22-108 · S/N 22-9632 · Cancelled Feb 21, 2013 · Revoked, canceled · Built 1963 · Bowles Edward T
- [N145BL](https://openairdocs.org/deregistered/N145BL-2013-01-31.md): Cessna 680 · S/N 680-0045 · Cancelled Jan 31, 2013 · Exported to Chile · Built 2005 · Aircraft Sales Corp
- [N40532](https://openairdocs.org/deregistered/N40532-2012-11-15.md): Balloon Works FIREFLY 7 · S/N 10090 · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1980 · Pierce Ronald W
- [N2377V](https://openairdocs.org/deregistered/N2377V-2012-08-14.md): Cessna 140 · S/N 14614 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1948
- [N341DM](https://openairdocs.org/deregistered/N341DM-2012-06-26.md): Cessna 340 · S/N 340-0347 · Cancelled Jun 26, 2012 · Expired dealer · Built 1974 · Aircraft Sales Corp
- [N4162K](https://openairdocs.org/deregistered/N4162K-2012-06-26.md): Piper PA-34-220T · S/N 3449097 · Cancelled Jun 26, 2012 · Expired dealer · Built 1999 · Aircraft Sales Corp
- [N366J](https://openairdocs.org/deregistered/N366J-2008-09-16.md): Cessna 310K · S/N 310K0086 · Cancelled Sep 16, 2008 · Triennial form not returned · Built 1966 · National Assocation Of System Administrations Inc
- [N4315S](https://openairdocs.org/deregistered/N4315S-2004-11-02.md): Beech A36 · S/N E-685 · Cancelled Nov 2, 2004 · Triennial form not returned · Built 1975 · Larocco Gary J
- [N7172B](https://openairdocs.org/deregistered/N7172B-2002-01-11.md): Gelasi John J AIRCAMPER · S/N 1188 · Cancelled Jan 11, 2002 · Triennial form not returned · Built 1991 · Gelasi John J
- [N9021A](https://openairdocs.org/deregistered/N9021A-1979-03-06-18776.md): Cessna 170A · S/N 18776 · Cancelled Mar 6, 1979 · Exported to Canada · Stokes Winston L
- [N1957W](https://openairdocs.org/deregistered/N1957W-1977-07-21.md): Beech B19 · S/N MB-621 · Cancelled Jul 21, 1977 · Built 1973 · Bennett James C
- [N6413U](https://openairdocs.org/deregistered/N6413U-1976-02-24.md): Mooney M20C · S/N 2160 · Cancelled Feb 24, 1976 · Hurt Michael L
- [N7689A](https://openairdocs.org/deregistered/N7689A-1975-06-24.md): Cessna 180 · S/N 32586 · Cancelled Jun 24, 1975 · Miller Gerald R
- [N110JH](https://openairdocs.org/deregistered/N110JH-1972-12-14.md): Hagle THORP T-18 · S/N 347 · Cancelled Dec 14, 1972 · Built 1971 · Hagle Conrad H

Next page: https://openairdocs.org/faa-place/IL/Crystal%20Lake/earlier.md?page=2

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

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