# Cancelled registrations: Joplin, MO

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

Cancelled aircraft registrations in Joplin, MO.

- [N446FH](https://openairdocs.org/deregistered/N446FH-2022-09-21.md): Adam A Helwich H5 · S/N 5 · Cancelled Sep 21, 2022 · Registration expired, pending cancellation · Built 2011 · Wilson Robert L
- [N214RH](https://openairdocs.org/deregistered/N214RH-2021-07-31.md): Henderson Robert E RH170 · S/N 3-170 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 2012 · Henderson Robert E
- [N986ZS](https://openairdocs.org/deregistered/N986ZS-2020-02-03.md): Cameron Balloons US Z-77 · S/N 6218 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1999 · Robinson Shane
- [N25043](https://openairdocs.org/deregistered/N25043-2019-12-27.md): Coit Gyrocopter C5 · S/N 1 · Cancelled Dec 27, 2019 · Revoked, canceled · Built 1967 · Montgomery Allan D Co Ow
- [N9437X](https://openairdocs.org/deregistered/N9437X-2019-12-27.md): Cessna 210A · S/N 21057737 · Cancelled Dec 27, 2019 · Registration pending, canceled · Built 1961
- [N7517M](https://openairdocs.org/deregistered/N7517M-2019-05-06.md): Cameron Balloons US O-77 · S/N 5758 · Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1992 · Robinson Shane
- [N6786X](https://openairdocs.org/deregistered/N6786X-2018-08-10.md): Cessna 310F · S/N 310-0086 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1961 · US Assets Recovery
- [N510DT](https://openairdocs.org/deregistered/N510DT-2018-05-18.md): British Aerospace BAE JETSTREAM 3201 · S/N 879 · Cancelled May 18, 2018 · Exported to Canada · Built 1990 · Turbine Engine Consultants Inc
- [N41424](https://openairdocs.org/deregistered/N41424-2018-04-05.md): Piper J3F-65 · S/N 8052 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Sorensen Clifford E
- [N520SR](https://openairdocs.org/deregistered/N520SR-2018-03-27.md): Paulo Amaury De Toledo Filho N-23 · S/N FMB-200486 · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 2010 · Robinson Shane
- [N61513](https://openairdocs.org/deregistered/N61513-2018-03-27.md): Cameron Balloons US A-105 · S/N 6011 · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1995 · Robinson Shane
- [N147RT](https://openairdocs.org/deregistered/N147RT-2018-01-11.md): Thomas Ronald L STOL CH 701 · S/N 7-1185 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Thomas Ronald L
- [N8584B](https://openairdocs.org/deregistered/N8584B-2017-07-14.md): Cessna 172 · S/N 36284 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1957 · Maky LLC
- [N8094F](https://openairdocs.org/deregistered/N8094F-2017-06-15.md): Cessna 421B · S/N 421B0232 · Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1972 · Lde Corp
- [N744LB](https://openairdocs.org/deregistered/N744LB-2013-10-28.md): Lindstrand Balloons 77A · S/N 5012 · Cancelled Oct 28, 2013 · First renewal notice · Built 1997 · Barrett William M
- [N890X](https://openairdocs.org/deregistered/N890X-2013-08-27.md): Aviatika MAI-890 · S/N RT101 · Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2003
- [N86E](https://openairdocs.org/deregistered/N86E-2013-06-11.md): Piper PA-28RT-201T · S/N 28R-8231009 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1981 · Western Enterprises Inc
- [N6BS](https://openairdocs.org/deregistered/N6BS-2013-04-03.md): Cessna 310 · S/N 35362 · Cancelled Apr 3, 2013 · Built 1956 · Edwards Royce Deryl II
- [N34515](https://openairdocs.org/deregistered/N34515-2013-03-07.md): Cessna 177B · S/N 17701852 · Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1972 · Baker Danny P
- [N33922](https://openairdocs.org/deregistered/N33922-2012-09-12.md): Taylorcraft BC12-65 · S/N 2772 · Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1941
- [N55AZ](https://openairdocs.org/deregistered/N55AZ-2008-06-06.md): Piper PA-31-325 · S/N 31-7912039 · Cancelled Jun 6, 2008 · Triennial form not returned · Railroad Salvage Restoration Inc
- [N48BR](https://openairdocs.org/deregistered/N48BR-2005-06-08.md): Rhymer William RANS S-10 · S/N 1191136 · Cancelled Jun 8, 2005 · Triennial form not returned · Rhymer William R
- [N16405](https://openairdocs.org/deregistered/N16405-2003-05-08.md): Piper PA-28-235 · S/N 28-7310094 · Cancelled May 8, 2003 · Triennial form undeliverable · Built 1973 · David W Patterson Dds Pc
- [N104BR](https://openairdocs.org/deregistered/N104BR-2002-05-17.md): Swearingen SA-226T · S/N T269 · Cancelled May 17, 2002 · Built 1976 · Ls&C Development Services Inc
- [N182KC](https://openairdocs.org/deregistered/N182KC-2001-02-27.md): Cessna 182S · S/N 18280049 · Cancelled Feb 27, 2001 · Triennial form not returned · Fears Gregory L
- [N385AC](https://openairdocs.org/deregistered/N385AC-2000-01-06.md): Crum Alan B EVANS VP-1 · S/N 01 · Cancelled Jan 6, 2000 · Triennial form not returned · Crum Alan B
- [N84HH](https://openairdocs.org/deregistered/N84HH-1998-12-15.md): Cessna T210N · S/N 21062973 · Cancelled Dec 15, 1998 · Exported to Mexico · Truck World Trucks Inc
- [N6EJ](https://openairdocs.org/deregistered/N6EJ-1993-09-10.md): White GUSTY A · S/N RW3 · Cancelled Sep 10, 1993 · White Roger G Trustee
- [N612SM](https://openairdocs.org/deregistered/N612SM-1985-03-13.md): Cessna 310I · S/N 310I0144 · Cancelled Mar 13, 1985 · Exported to Costa Rica · Dr Thomas C Jackson
- [N2302B](https://openairdocs.org/deregistered/N2302B-1982-02-26.md): Temco GC-1B · S/N 3602 · Cancelled Feb 26, 1982 · Built 1948 · Barber Glen O
- [N2299S](https://openairdocs.org/deregistered/N2299S-1979-07-05.md): Martin 404 · S/N 14241 · Cancelled Jul 5, 1979 · Exported to Dominican Republic · Executive Trans Air Inc
- [N7808G](https://openairdocs.org/deregistered/N7808G-1975-08-02.md): Cessna 150L · S/N 15074729 · Cancelled Aug 2, 1975 · Thompson Harold F
- [N80434](https://openairdocs.org/deregistered/N80434-1971-07-07.md): Beech 35 · S/N D-34 · Cancelled Jul 7, 1971 · Hardwick George R Jr
- [N4492D](https://openairdocs.org/deregistered/N4492D-1962-10-05.md): Beech G35 · S/N D-4631 · Cancelled Oct 5, 1962 · Exported to Australia · Built 1956 · Foulke Emerson And Hallie
- [N61028](https://openairdocs.org/deregistered/N61028-1956-04-30.md): Cessna T-50 · S/N 1773 · Cancelled Apr 30, 1956 · Oltman H C
- [N39319](https://openairdocs.org/deregistered/N39319-1955-10-20.md): Aeronca 65-CA · S/N CA18082 · Cancelled Oct 20, 1955 · Built 1942 · Baker William B
- [N39577](https://openairdocs.org/deregistered/N39577-1955-10-20.md): Aeronca 65-CA · S/N CA18512 · Cancelled Oct 20, 1955 · Built 1942 · Baker William B
- [N5936V](https://openairdocs.org/deregistered/N5936V-1955-10-06.md): Piper J3C-65 · S/N 9635 · Cancelled Oct 6, 1955 · Missouri Wing Civil Air Patrol
- [N5937V](https://openairdocs.org/deregistered/N5937V-1955-10-06.md): Piper J3C-65 · S/N 9959 · Cancelled Oct 6, 1955 · Missouri Win Civil Air Patrol
- [N5935V](https://openairdocs.org/deregistered/N5935V-1952-06-10.md): Piper L-4 · S/N 9910 · Cancelled Jun 10, 1952 · Missouri Wing
- [N33802](https://openairdocs.org/deregistered/N33802-1952-02-19.md): Aeronca 65-CA · S/N 13551 · Cancelled Feb 19, 1952 · Daro
- [N84470](https://openairdocs.org/deregistered/N84470-1951-02-14.md): Aeronca 7AC · S/N 3167 · Cancelled Feb 14, 1951 · Long Raymond T
- [N2965E](https://openairdocs.org/deregistered/N2965E-1951-02-13.md): Aeronca 7AC · S/N 7AC-6551 · Cancelled Feb 13, 1951 · Lowrance Carl
- [N8801K](https://openairdocs.org/deregistered/N8801K-1951-02-13.md): Stinson 108-1 · S/N 108-1801 · Cancelled Feb 13, 1951 · Demier O L
- [N21941](https://openairdocs.org/deregistered/N21941-1949-12-30.md): Cessna C-165 · S/N 557 · Cancelled Dec 30, 1949 · D And R
- [N2418V](https://openairdocs.org/deregistered/N2418V-1949-06-14.md): Cessna 140 · S/N 14664 · Cancelled Jun 14, 1949 · Hatfield Jack
- [N8682K](https://openairdocs.org/deregistered/N8682K-1947-03-25.md): Stinson 108-1 · S/N 108-1682 · Cancelled Mar 25, 1947 · Schweikert Dorothy L
- [N2891](https://openairdocs.org/deregistered/N2891-1930-03-14.md): Eaglerock LONG WING EAGLEROCK · S/N 162 · Cancelled Mar 14, 1930 · Harper H G

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

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