# Cancelled registrations: Saint Joseph, MO

A list on [Saint Joseph, MO](https://openairdocs.org/faa-place/MO/Saint%20Joseph.md).

Cancelled aircraft registrations in Saint Joseph, MO.

- [N544EE](https://openairdocs.org/deregistered/N544EE-2022-08-10.md): Embraer S A EMB-545 · S/N 55010044 · Cancelled Aug 10, 2022 · Exported to Canada · Built 2019 · Bi Investments LLC
- [N4265Y](https://openairdocs.org/deregistered/N4265Y-2020-08-02.md): Stehle John C VOLKSPLANE VP-1 · S/N 2 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Stehle John C
- [N4635X](https://openairdocs.org/deregistered/N4635X-2018-03-23.md): Cessna 150G · S/N 15064685 · Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1966 · Nelson Lester G
- [N714DV](https://openairdocs.org/deregistered/N714DV-2018-03-02.md): Cessna 150M · S/N 15079104 · Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1976 · Nelson Lester G Jr
- [N72409](https://openairdocs.org/deregistered/N72409-2018-01-24.md): Beech C-45H · S/N AF-411 · Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1944 · Heavy Time Aviation LLC
- [N51085](https://openairdocs.org/deregistered/N51085-2016-09-19.md): Eipper Quicksilver MXL · S/N 1172 · Cancelled Sep 19, 2016 · Built 1983 · Quackenbush Alan R
- [N31566](https://openairdocs.org/deregistered/N31566-2014-09-29.md): Piper PA-28-181 · S/N 28-7890469 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1978 · Simerly Farms Inc
- [N7926T](https://openairdocs.org/deregistered/N7926T-2013-07-29.md): Cessna 175A · S/N 56626 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1960 · F C I Marketing Inc
- [N8446A](https://openairdocs.org/deregistered/N8446A-2013-05-14.md): Beech A35 · S/N D-1864 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1948 · Shipley Russell
- [N2242J](https://openairdocs.org/deregistered/N2242J-2012-08-30.md): Cessna 150G · S/N 15065442 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1966 · Nelson Terry L
- [N525SP](https://openairdocs.org/deregistered/N525SP-2011-09-20.md): Cessna R172K · S/N R1722591 · Cancelled Sep 20, 2011 · Second renewal notice · Built 1977 · Lackamp Robert J
- [N1023P](https://openairdocs.org/deregistered/N1023P-2011-06-22.md): Piper PA-23 · S/N 23-25 · Cancelled Jun 22, 2011 · Sale reported, canceled · Built 1954
- [N27820](https://openairdocs.org/deregistered/N27820-2009-11-17.md): Piper PA-31-350 · S/N 31-7952002 · Cancelled Nov 17, 2009 · Exported to Canada · Built 1978 · Hampton Clark W Trustee
- [N15VV](https://openairdocs.org/deregistered/N15VV-2006-04-24.md): Vestal John S AVID FLYER · S/N 195 · Cancelled Apr 24, 2006 · Triennial form not returned · Built 1986 · Springs Harlen
- [N45NP](https://openairdocs.org/deregistered/N45NP-2004-11-12.md): Learjet 45 · S/N 20 · Cancelled Nov 12, 2004 · Exported to Canada · Built 1999 · Npg Aircraft Inc
- [N2532N](https://openairdocs.org/deregistered/N2532N-2002-08-13.md): Piper PA-38-112 · S/N 38-79A0902 · Cancelled Aug 13, 2002 · Built 1979 · Martin Jack W
- [N40545](https://openairdocs.org/deregistered/N40545-1974-05-01.md): Piper PA-23-250 · S/N 27-7405283 · Cancelled May 1, 1974 · Exported to United Kingdom · St Joseph Flying Service Inc
- [N41336](https://openairdocs.org/deregistered/N41336-1951-08-31.md): Piper J5A · S/N 5-1312 · Cancelled Aug 31, 1951 · Built 1941 · Streeter William E / Funk Richard C
- [N32438](https://openairdocs.org/deregistered/N32438-1950-11-27.md): Porterfield LP-65 · S/N 868 · Cancelled Nov 27, 1950 · Built 1941 · Buczek John
- [N31657](https://openairdocs.org/deregistered/N31657-1948-08-26.md): Cessna AT 17B · S/N 3007 · Cancelled Aug 26, 1948 · Grief John E Et Al
- [N34450](https://openairdocs.org/deregistered/N34450-1943-05-10.md): Aeronca 65-TL · S/N L9931T · Cancelled May 10, 1943 · Built 1941 · Karle John M DBA Karle Flying Service
- [N34451](https://openairdocs.org/deregistered/N34451-1943-05-10.md): Aeronca 65-TL · S/N L9941T · Cancelled May 10, 1943 · Built 1941 · Karle John M DBA Karle Flying Service
- [N34452](https://openairdocs.org/deregistered/N34452-1943-05-10.md): Aeronca 65-TL · S/N L9951T · Cancelled May 10, 1943 · Built 1941 · Karle John M DBA Karle Flying Service
- [N8609](https://openairdocs.org/deregistered/N8609-1941-03-01.md): Fleet 1 · S/N 21 · Cancelled Mar 1, 1941 · Built 1929 · Pony Express Airways & College Inc

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

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