# Cancelled registrations: Kennett, MO

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

Cancelled aircraft registrations in Kennett, MO.

- [N84586](https://openairdocs.org/deregistered/N84586-2018-04-06.md): Aeronca 7AC · S/N 7AC-3290 · Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Downing Nick
- [N967JB](https://openairdocs.org/deregistered/N967JB-2017-04-20.md): Air Tractor AT-602 · S/N 602-1243 · Cancelled Apr 20, 2017 · Built 2014 · Bootheel Ag Air Services LLC
- [N2722N](https://openairdocs.org/deregistered/N2722N-2017-04-07.md): Cessna 140 · S/N 12980 · Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1947 · Bickerstaff Kerry L
- [N54395](https://openairdocs.org/deregistered/N54395-2014-12-22.md): Piper PA-28-151 · S/N 28-7415054 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1973 · Gowan John
- [N4776R](https://openairdocs.org/deregistered/N4776R-2014-10-14.md): Cessna A188B · S/N 18802317 · Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1975 · Branum Ronald G
- [N30081](https://openairdocs.org/deregistered/N30081-2013-08-13.md): Midget Mustang MM-1 · S/N 243 · Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1968
- [N68777](https://openairdocs.org/deregistered/N68777-2013-05-02.md): Cessna 152 · S/N 15282371 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Nicks Aircraft Sales Inc
- [N68780](https://openairdocs.org/deregistered/N68780-2013-05-02.md): Cessna 152 · S/N 15282373 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Hal Aviation
- [N222RF](https://openairdocs.org/deregistered/N222RF-2013-02-07.md): Cessna 150M · S/N 15076949 · Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1975 · Hal Aviation Inc
- [N9041Q](https://openairdocs.org/deregistered/N9041Q-2011-03-03.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1697 · Cancelled Mar 3, 2011 · Exported to France · Bootheel Ag Air Services LLC
- [N23BP](https://openairdocs.org/deregistered/N23BP-2007-06-20.md): Peel Robert H VARIEZE · S/N 1966 · Cancelled Jun 20, 2007 · Exported to Argentina · Boyd Bill R
- [N9412G](https://openairdocs.org/deregistered/N9412G-1995-10-06.md): Cessna A188B · S/N 18801478T · Cancelled Oct 6, 1995 · Exported to Bolivia · Jewell Aviation Inc
- [N6662S](https://openairdocs.org/deregistered/N6662S-1984-12-14.md): Cessna 150H · S/N 150-67462 · Cancelled Dec 14, 1984 · Hal Aviation Inc
- [N78FR](https://openairdocs.org/deregistered/N78FR-1984-05-07.md): Cessna 172N · S/N 17273135 · Cancelled May 7, 1984 · Hal Aviation Inc
- [N5205](https://openairdocs.org/deregistered/N5205-1979-05-21.md): Grumman G-164A · S/N 1127 · Cancelled May 21, 1979 · Exported to Costa Rica · Gill Tommy
- [N3128T](https://openairdocs.org/deregistered/N3128T-1976-05-20.md): Cessna 177 · S/N 17700428 · Cancelled May 20, 1976 · Built 1962 · Skelton Metz K/DBA Skelton Associates
- [N91065](https://openairdocs.org/deregistered/N91065-1975-07-24.md): Cessna 207 · S/N 20700052 · Cancelled Jul 24, 1975 · Built 1969 · Hurst William
- [N91019](https://openairdocs.org/deregistered/N91019-1974-04-24.md): Cessna 207 · S/N 20700013 · Cancelled Apr 24, 1974 · Built 1969 · Hurst Bill
- [N1875P](https://openairdocs.org/deregistered/N1875P-1973-11-20.md): Piper PA-18-150 · S/N 18-4154 · Cancelled Nov 20, 1973 · Wells Zeke
- [N8343U](https://openairdocs.org/deregistered/N8343U-1972-05-25.md): Cessna 172F · S/N 17252243 · Cancelled May 25, 1972 · Exported to Canada · Mcghee Aviation Inc
- [N2241Y](https://openairdocs.org/deregistered/N2241Y-1972-02-02.md): Cessna 177 · S/N 17700041 · Cancelled Feb 2, 1972 · Mcclain John
- [N6282Z](https://openairdocs.org/deregistered/N6282Z-1971-11-02.md): Piper PA-25-150 · S/N 25-352 · Cancelled Nov 2, 1971 · Rice R P
- [N75283](https://openairdocs.org/deregistered/N75283-1965-05-20.md): Cessna T-50 · S/N 2848 · Cancelled May 20, 1965 · Rice Richard P
- [N85382](https://openairdocs.org/deregistered/N85382-1955-06-13.md): Aeronca 7AC · S/N 7AC-4122 · Cancelled Jun 13, 1955 · Christiancy Allan H

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

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