# Cancelled registrations: Frankfort, IL

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

Cancelled aircraft registrations in Frankfort, IL.

- [N408BB](https://openairdocs.org/deregistered/N408BB-2022-05-09.md): Blitz Aero QUICKSILVER GT 500 · S/N 05161944 · Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 2007 · Jimenez Miguel D
- [N2590A](https://openairdocs.org/deregistered/N2590A-2021-10-02.md): Benevelli Michael E QUICKSILVER GT400 · S/N 1406 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Jimenez Miguel D
- [N6650D](https://openairdocs.org/deregistered/N6650D-2020-02-28.md): Beech 58 · S/N TH-1375 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1983 · Grupo Tigre LLC
- [N310BH](https://openairdocs.org/deregistered/N310BH-2018-01-17.md): Cessna 310R · S/N 310R0950 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Ward Bryan J
- [N5222B](https://openairdocs.org/deregistered/N5222B-2018-01-17.md): Cessna 152 · S/N 15283808 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1979 · South Suburban Aviation Inc
- [N101BD](https://openairdocs.org/deregistered/N101BD-2013-10-29.md): Cavenaugh BEDE BD-5B · S/N 1526 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1976 · Cavenaugh Richard A
- [N89786](https://openairdocs.org/deregistered/N89786-2013-09-18.md): Cessna 140 · S/N 8835 · Cancelled Sep 18, 2013 · Registration expired, pending cancellation · Built 1946 · Hennings William F
- [N5225B](https://openairdocs.org/deregistered/N5225B-2013-09-13.md): Cessna 152 · S/N 15283810 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1979 · South Suburban Aviation Inc
- [N7167D](https://openairdocs.org/deregistered/N7167D-2013-08-22.md): Gay David E AVID FLYER · S/N ATG-9087 · Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1990
- [N92625](https://openairdocs.org/deregistered/N92625-2013-03-18.md): Cessna 182N · S/N 18260288 · Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1970
- [N5281A](https://openairdocs.org/deregistered/N5281A-2008-07-03.md): Cessna 210N · S/N 21063346 · Cancelled Jul 3, 2008 · Exported to Bolivia · Built 1979 · South Suburban Aviation Inc
- [N5549L](https://openairdocs.org/deregistered/N5549L-2001-07-11.md): Cessna 152 · S/N 15284351 · Cancelled Jul 11, 2001 · Triennial form not returned · South Suburban Aviation Inc
- [N5776Q](https://openairdocs.org/deregistered/N5776Q-1982-09-27.md): Mooney M20C · S/N 3090 · Cancelled Sep 27, 1982 · Vokes Douglas W
- [N42WB](https://openairdocs.org/deregistered/N42WB-1981-07-20.md): Piper PA-23-250 · S/N 27-7405247 · Cancelled Jul 20, 1981 · Exported to Iceland · Frankfort Aviation Service Inc
- [N9371H](https://openairdocs.org/deregistered/N9371H-1981-05-20.md): Cessna 172M · S/N 17266122 · Cancelled May 20, 1981 · Exported to Iceland · Frankfort Aviation Service Inc
- [N3218E](https://openairdocs.org/deregistered/N3218E-1981-05-05.md): Aeronca 11AC · S/N 11AC-1566 · Cancelled May 5, 1981 · Built 1946 · Gryczewski Leo H
- [N67501](https://openairdocs.org/deregistered/N67501-1980-04-28.md): Cessna 152 · S/N 15281871 · Cancelled Apr 28, 1980 · Exported to Iceland · Frankfort Aviation Inc
- [N75578](https://openairdocs.org/deregistered/N75578-1980-04-28.md): Cessna 172N · S/N 17267822 · Cancelled Apr 28, 1980 · Exported to Iceland · Frankfort Aviation Service Inc
- [N739HJ](https://openairdocs.org/deregistered/N739HJ-1980-04-15.md): Cessna 172N · S/N 17270553 · Cancelled Apr 15, 1980 · Exported to Iceland · Frankfort Aviation Service Inc
- [N75804](https://openairdocs.org/deregistered/N75804-1980-04-15.md): Cessna 172N · S/N 17267963 · Cancelled Apr 15, 1980 · Exported to Iceland · Frankfort Aviation Service Inc
- [N67536](https://openairdocs.org/deregistered/N67536-1980-04-10.md): Cessna 152 · S/N 15281898 · Cancelled Apr 10, 1980 · Exported to Iceland · Frankfort Aviation Services Inc
- [N67569](https://openairdocs.org/deregistered/N67569-1980-04-10.md): Cessna 152 · S/N 15281918 · Cancelled Apr 10, 1980 · Exported to Iceland · Franfort Aviation Service Inc
- [N64462](https://openairdocs.org/deregistered/N64462-1978-07-20.md): Cessna 172M · S/N 17265249 · Cancelled Jul 20, 1978 · Exported to Canada · Frankfort Aviation Service Inc
- [N11107](https://openairdocs.org/deregistered/N11107-1975-10-03.md): Cessna 150L · S/N 15075203 · Cancelled Oct 3, 1975 · Exported to Canada · Frankfort Aviation Service Inc
- [N4299L](https://openairdocs.org/deregistered/N4299L-1974-07-19.md): Cessna 172G · S/N 17254368 · Cancelled Jul 19, 1974 · Frankfort Aviation
- [N1795Q](https://openairdocs.org/deregistered/N1795Q-1973-09-26.md): Cessna 150L · S/N 15073095 · Cancelled Sep 26, 1973 · Exported to Canada · Built 1971 · Frankfort Aviation Service Inc
- [N1651Q](https://openairdocs.org/deregistered/N1651Q-1973-07-12.md): Cessna 150L · S/N 15072951 · Cancelled Jul 12, 1973 · Exported to Canada · Frankfort Aviation Service Inc
- [N5758G](https://openairdocs.org/deregistered/N5758G-1972-08-30.md): Cessna 150K · S/N 15071258 · Cancelled Aug 30, 1972 · Exported to Canada · Frankfort Aviation Service Inc
- [N5582R](https://openairdocs.org/deregistered/N5582R-1966-01-04.md): Cessna 172F · S/N 17253181 · Cancelled Jan 4, 1966 · Frankfort Aviation Service
- [N13648](https://openairdocs.org/deregistered/N13648-1940-03-01.md): Corben Ace B · S/N 17 · Cancelled Mar 1, 1940 · Built 1933 · Connor Maurice M

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

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