# Cancelled registrations: Monmouth, IL

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

Cancelled aircraft registrations in Monmouth, IL.

- [N34340](https://openairdocs.org/deregistered/N34340-2022-01-08.md): Cessna 177B · S/N 17701771 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1972 · Lynch Melvin C
- [N8920V](https://openairdocs.org/deregistered/N8920V-2021-06-05.md): Cessna 172M · S/N 17264277 · Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1974 · Monmouth Flying Club
- [N4512T](https://openairdocs.org/deregistered/N4512T-2021-05-21.md): Piper PA-28R-200 · S/N 28R-7235062 · Cancelled May 21, 2021 · Third renewal notice · Built 1972 · Painter Farm Equipment Inc
- [N76671](https://openairdocs.org/deregistered/N76671-2020-03-24.md): Cessna 140 · S/N 11111 · Cancelled Mar 24, 2020 · Built 1946 · Daw Brian W
- [N6913H](https://openairdocs.org/deregistered/N6913H-2020-02-21.md): Piper J3C-65 · S/N 20145 · Cancelled Feb 21, 2020 · Revoked, canceled · Built 1946 · Starner Flying Service
- [N2983M](https://openairdocs.org/deregistered/N2983M-2019-12-09.md): Piper PA-12 · S/N 12-1368 · Cancelled Dec 9, 2019 · Revoked, canceled · Built 1946 · Starner Flying Service
- [N1964P](https://openairdocs.org/deregistered/N1964P-2019-10-18.md): Piper PA-18A 150 · S/N 18-4195 · Cancelled Oct 18, 2019 · Revoked, canceled · Built 1955 · Danforth Robert W
- [N65211](https://openairdocs.org/deregistered/N65211-2019-01-22.md): Consolidated Vultee BT-13A · S/N 9442 · Cancelled Jan 22, 2019 · Revoked, canceled · Built 1943 · Louck John M
- [N6805H](https://openairdocs.org/deregistered/N6805H-2018-08-28.md): Piper J3C-65 · S/N 20020 · Cancelled Aug 28, 2018 · Revoked, canceled · Built 1946 · Starner Flying Service
- [N95188](https://openairdocs.org/deregistered/N95188-2018-04-06.md): Taylorcraft BF · S/N 9588 · Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Monmouth Flying Club
- [N42299](https://openairdocs.org/deregistered/N42299-2013-05-23.md): Piper J3C-65 · S/N 14549 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Richmond Harold M
- [N9470](https://openairdocs.org/deregistered/N9470-2013-05-23.md): Lawhorn FLYBABY 1A · S/N 739 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1978 · Lawhorn Roger V
- [N609GJ](https://openairdocs.org/deregistered/N609GJ-2003-06-11.md): Jones Gary CHALLENGER 2 PLACE · S/N 0392-0829 · Cancelled Jun 11, 2003 · Jones Gary D
- [N609GJ](https://openairdocs.org/deregistered/N609GJ-2002-01-22.md): Phillips Joe/Phillips Avia CHALLENGER II · S/N 0392-0829 · Cancelled Jan 22, 2002 · Jones Gary D
- [N1105M](https://openairdocs.org/deregistered/N1105M-1974-04-02.md): North American NAVION A · S/N NAV-4-1034 · Cancelled Apr 2, 1974 · Connell J Douglas
- [N1114K](https://openairdocs.org/deregistered/N1114K-1971-12-14.md): Luscombe 8E · S/N 3841 · Cancelled Dec 14, 1971 · Peirce Stephen R
- [N3565K](https://openairdocs.org/deregistered/N3565K-1956-02-14.md): Piper J3C-65 · S/N 22257 · Cancelled Feb 14, 1956 · Danforth Robert W
- [N844C](https://openairdocs.org/deregistered/N844C-1955-11-17.md): Stinson 108-3 · S/N 108-3844 · Cancelled Nov 17, 1955 · Jones Russell F
- [N23581](https://openairdocs.org/deregistered/N23581-1955-10-06.md): Aeronca 65-C · S/N C-5379 · Cancelled Oct 6, 1955 · Russell D Manuel
- [N13070](https://openairdocs.org/deregistered/N13070-1940-05-15.md): Waco UIC · S/N 3721 · Cancelled May 15, 1940 · David W Moffat

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

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