# Cancelled registrations: Clayton, MO

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

Cancelled aircraft registrations in Clayton, MO.

- [N2150](https://openairdocs.org/deregistered/N2150-2026-10-20.md): Cessna 208B · S/N 208B5054 · Cancelled Oct 20, 2026 · Exported to Bahamas · Built 2013 · Avtran LLC
- [N18102](https://openairdocs.org/deregistered/N18102-2025-03-13.md): Embraer EMB-145XR · S/N 145643 · Cancelled Mar 13, 2025 · Exported to Bahamas · Built 2002 · Enterprise Aircraft Finance LLC
- [N11544](https://openairdocs.org/deregistered/N11544-2022-03-03.md): Embraer EMB-145LR · S/N 145557 · Cancelled Mar 3, 2022 · Exported to Bahamas · Built 2002 · Enterprise Aircraft Finance LLC
- [N911TQ](https://openairdocs.org/deregistered/N911TQ-2021-07-31.md): Hughes 369A (OH-6A) · S/N 1080811 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · St Louis County Police Department
- [N628AM](https://openairdocs.org/deregistered/N628AM-2021-07-28.md): Cessna 525 · S/N 525-0628 · Cancelled Jul 28, 2021 · Exported to Germany · Built 2006 · Avtran LLC
- [N284BS](https://openairdocs.org/deregistered/N284BS-2018-08-31.md): Saab-Scania SF340A · S/N 340A153 · Cancelled Aug 31, 2018 · Exported to Bahamas · Avtran LLC
- [N350WF](https://openairdocs.org/deregistered/N350WF-2017-07-12.md): Piper PA 46-350P · S/N 4622082 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1989 · Bingham Capital Markets St Louis Inc
- [N9071S](https://openairdocs.org/deregistered/N9071S-2013-09-20.md): Aerostar International SHAMU · S/N SHAMU-3001 · Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1997 · Busch Entertainment Corporation
- [N90417](https://openairdocs.org/deregistered/N90417-2013-03-18.md): Bell TH-13T · S/N 3432 · Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1964
- [N712MG](https://openairdocs.org/deregistered/N712MG-2008-12-05.md): Saab-Scania SF-340-A · S/N 340A-067 · Cancelled Dec 5, 2008 · Exported to Bahamas · Built 1986 · Avtran LLC
- [N50DG](https://openairdocs.org/deregistered/N50DG-1999-01-27.md): North American NA-265-60 · S/N 306-19 · Cancelled Jan 27, 1999 · Sale reported
- [N67023](https://openairdocs.org/deregistered/N67023-1982-11-23.md): Polcyn GYROCOPTER · S/N 01 · Cancelled Nov 23, 1982 · Frank R Polcyn
- [N9499W](https://openairdocs.org/deregistered/N9499W-1981-12-17.md): Piper PA-28-235 · S/N 28-11241 · Cancelled Dec 17, 1981 · Boardman Harry L
- [N64713](https://openairdocs.org/deregistered/N64713-1981-10-29.md): Bell TH-13T · S/N 64-17876 · Cancelled Oct 29, 1981 · Louis Count Office Of Civil Preparedness
- [N2583K](https://openairdocs.org/deregistered/N2583K-1980-11-04.md): Cessna 180K · S/N 18053004 · Cancelled Nov 4, 1980 · Exported to Papua New Guinea · Built 1979 · Wings Of Hope Inc
- [N64863](https://openairdocs.org/deregistered/N64863-1977-09-13.md): Bell TH-13T · S/N 17889 · Cancelled Sep 13, 1977 · St Louis County Office Of Civil Preparedness
- [N48132](https://openairdocs.org/deregistered/N48132-1977-07-07.md): Bell TH-13T · S/N 3618 · Cancelled Jul 7, 1977 · St Louis County Civil Defense
- [N749](https://openairdocs.org/deregistered/N749-1976-11-18.md): Bell 47G-2 · S/N 2191 · Cancelled Nov 18, 1976 · St Louis County Office Of Civil Preparedness
- [N22504](https://openairdocs.org/deregistered/N22504-1974-10-24.md): Cessna 150H · S/N 15068322 · Cancelled Oct 24, 1974 · Silverberg Edwin M
- [N7587P](https://openairdocs.org/deregistered/N7587P-1972-07-05.md): Piper PA-24-250 · S/N 24-2798 · Cancelled Jul 5, 1972 · Exported to Canada · Robert J Plimpton
- [N7730U](https://openairdocs.org/deregistered/N7730U-1970-08-26.md): Cessna 172E · S/N 17251730 · Cancelled Aug 26, 1970 · Commercial Credit Equipment Corporation
- [N91672](https://openairdocs.org/deregistered/N91672-1954-10-25.md): Ryan NAVION · S/N NAV-4-420 · Cancelled Oct 25, 1954 · C T Wilson Contracting Co
- [N50900](https://openairdocs.org/deregistered/N50900-1954-10-18.md): Cessna T-50 · S/N 5964 · Cancelled Oct 18, 1954 · National Associated Underwriting Co
- [N326M](https://openairdocs.org/deregistered/N326M-1954-01-26.md): Mooney M-18C · S/N 207 · Cancelled Jan 26, 1954 · Built 1950 · National Insuranceunderwriters
- [N8439K](https://openairdocs.org/deregistered/N8439K-1951-11-08.md): Stinson 108-1 · S/N 108-1439 · Cancelled Nov 8, 1951 · Park Alden B
- [N3813H](https://openairdocs.org/deregistered/N3813H-1949-07-25.md): Engineering & Research 415-CD · S/N 4514 · Cancelled Jul 25, 1949 · Built 1947 · Park Alden B
- [N34209](https://openairdocs.org/deregistered/N34209-1948-09-13.md): Frankfort GLIDER B · S/N B-1-3 · Cancelled Sep 13, 1948 · Saint Louis Soaring Ass'N
- [N18060](https://openairdocs.org/deregistered/N18060-1938-07-11.md): Van Dyke Jacob VD-X-1 · S/N 1 · Cancelled Jul 11, 1938 · Van Dyke Jacob III
- [N111V](https://openairdocs.org/deregistered/N111V-1934-08-12.md): Israel Gordon ISRAEL RACING 1 · S/N 1 · Cancelled Aug 12, 1934 · Built 1932 · Israel Gordon
- [N3014](https://openairdocs.org/deregistered/N3014-1934-07-12.md): G L Bumbaugh SPHERICAL FREE BALLO · S/N 101 · Cancelled Jul 12, 1934 · H Eugene Honeywell

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

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