# Cancelled registrations: Charleston, MO

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

Cancelled aircraft registrations in Charleston, MO.

- [N20361](https://openairdocs.org/deregistered/N20361-2018-04-18.md): Air Tractor AT-802A · S/N 802A-0420 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2011 · Thompson Flying Service LLC
- [N8940L](https://openairdocs.org/deregistered/N8940L-2014-11-20.md): Piper PA-25-260 · S/N 25-5405 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1971 · Mcdowell Kenneth
- [N8945L](https://openairdocs.org/deregistered/N8945L-2014-11-20.md): Piper PA-25-235 · S/N 25-5410 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1971 · Mcdowell Kenneth
- [N912X](https://openairdocs.org/deregistered/N912X-2013-07-09.md): Grumman G-164A · S/N 503 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1968 · Austin Crop Care LLC
- [N1770S](https://openairdocs.org/deregistered/N1770S-2013-04-11.md): Aero Commander 600 S-2D RESTRICTED · S/N 600-1413D · Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1967 · Mcdowell Ken
- [N5352V](https://openairdocs.org/deregistered/N5352V-2008-09-24.md): Hiller UH-12E · S/N 2027 · Cancelled Sep 24, 2008 · Triennial form not returned · Built 1959 · Mcdowell Kenneth
- [N6621Q](https://openairdocs.org/deregistered/N6621Q-2000-08-01.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1687 · Cancelled Aug 1, 2000 · Exported to Chile · Austin Stephen Bruce
- [N6767Z](https://openairdocs.org/deregistered/N6767Z-2000-03-10.md): Piper PA-25-235 · S/N 25-2391 · Cancelled Mar 10, 2000 · Triennial form not returned · Mcdowell Kenneth
- [N9722P](https://openairdocs.org/deregistered/N9722P-2000-03-10.md): Piper PA-25-235 · S/N 25-7556042 · Cancelled Mar 10, 2000 · Triennial form not returned · Mcdowell Kenneth T
- [N9771P](https://openairdocs.org/deregistered/N9771P-2000-03-10.md): Piper PA-25-235 · S/N 25-7556082 · Cancelled Mar 10, 2000 · Second triennial mailing, no response · Mcdowell Kenneth T
- [N6705Q](https://openairdocs.org/deregistered/N6705Q-1981-05-07.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 219B · Cancelled May 7, 1981 · Mcdowell Kenneth T
- [N7202Z](https://openairdocs.org/deregistered/N7202Z-1980-02-20.md): Piper PA-25-235 · S/N 25-3109 · Cancelled Feb 20, 1980 · Exported to France · Mcdowell Ken
- [N21863](https://openairdocs.org/deregistered/N21863-1977-07-14.md): Cessna A188B · S/N 18801084T · Cancelled Jul 14, 1977 · Built 1972 · Mcdowell Ken T
- [N8360Y](https://openairdocs.org/deregistered/N8360Y-1968-01-17.md): Piper PA-30 · S/N 30-1508 · Cancelled Jan 17, 1968 · Built 1967 · Story A L
- [N64250](https://openairdocs.org/deregistered/N64250-1955-10-13.md): Fairchild M-62A · S/N T41-1004 · Cancelled Oct 13, 1955 · Carr Leo
- [N71010](https://openairdocs.org/deregistered/N71010-1952-08-29.md): Piper J-3C · S/N 18026 · Cancelled Aug 29, 1952 · Veterans Flying Club/ George T Hutcherson Mgr
- [N48452](https://openairdocs.org/deregistered/N48452-1949-01-17.md): Taylorcraft DCO-65 · S/N L-4805 · Cancelled Jan 17, 1949 · Carr Robert L
- [N50089](https://openairdocs.org/deregistered/N50089-1948-05-13.md): Boeing N2S-1 · S/N 75-1106 · Cancelled May 13, 1948 · A L Story

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

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