# Cancelled registrations: Shawnee Mission, KS

A list on [Shawnee Mission, KS](https://openairdocs.org/faa-place/KS/Shawnee%20Mission.md).

Cancelled aircraft registrations in Shawnee Mission, KS.

- [N43759](https://openairdocs.org/deregistered/N43759-2020-10-26.md): Taylorcraft BC12-D · S/N 7418 · Cancelled Oct 26, 2020 · Sale reported, canceled · Built 1946
- [N1214D](https://openairdocs.org/deregistered/N1214D-2019-11-18.md): Cessna 170A · S/N 19768 · Cancelled Nov 18, 2019 · Sale reported · Built 1950
- [N34207](https://openairdocs.org/deregistered/N34207-2019-03-20.md): Cessna 177B · S/N 17701705 · Cancelled Mar 20, 2019 · Sale reported, canceled · Built 1972
- [N74070](https://openairdocs.org/deregistered/N74070-2017-06-15.md): Balloon Works FIREFLY 8B · S/N F8B-024 · Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Aeronautical Adventures Inc
- [N45355](https://openairdocs.org/deregistered/N45355-2014-05-28.md): Cessna 150M · S/N 15076868 · Cancelled May 28, 2014 · Exported to Mexico · Built 1975 · Wilson Jean A
- [N60813](https://openairdocs.org/deregistered/N60813-2013-08-19.md): Boeing A75N1(PT17) · S/N 75-3811 · Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Simmons Ronald P
- [N4041Q](https://openairdocs.org/deregistered/N4041Q-2013-03-07.md): Balloon Works FIREFLY 7 · S/N 7845 · Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1979 · Aerostat Aviation Corp
- [N175DB](https://openairdocs.org/deregistered/N175DB-2013-01-31.md): Aero Commander 680T · S/N 1519-95 · Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1963 · Rohrman Richard
- [N326WL](https://openairdocs.org/deregistered/N326WL-2010-07-27.md): Cessna 182Q · S/N 18266869 · Cancelled Jul 27, 2010 · Exported to Tanzania · Built 1979 · Lippman Wayne E
- [N2095C](https://openairdocs.org/deregistered/N2095C-2009-07-13.md): Beech E18S · S/N BA-451 · Cancelled Jul 13, 2009 · Registration revoked · Built 1959 · Burns Robert L DBA
- [N2991R](https://openairdocs.org/deregistered/N2991R-1998-04-02.md): Cameron Balloons US V-77 · S/N 5159 · Cancelled Apr 2, 1998 · Petrehn Maury J
- [N819BE](https://openairdocs.org/deregistered/N819BE-1997-03-28.md): Beech 1900C · S/N UB62 · Cancelled Mar 28, 1997 · Exported to Australia · Mitc Aviation LLC
- [N27MT](https://openairdocs.org/deregistered/N27MT-1995-05-05.md): Rockwell International 690B · S/N 11533 · Cancelled May 5, 1995 · Triennial form not returned · Limbaugh B B
- [N88DM](https://openairdocs.org/deregistered/N88DM-1995-02-16.md): Cessna 421B · S/N 421B0574 · Cancelled Feb 16, 1995 · Triennial form not returned · Federated Rural Electric Ins Corp
- [N904DF](https://openairdocs.org/deregistered/N904DF-1991-09-12.md): Aero Commander 500-B · S/N 500B105746 · Cancelled Sep 12, 1991 · Towner John D
- [N6288U](https://openairdocs.org/deregistered/N6288U-1983-12-19.md): Mooney M20C · S/N 2127 · Cancelled Dec 19, 1983 · Metropolitan Avn Assoc
- [N5862S](https://openairdocs.org/deregistered/N5862S-1977-09-28.md): Beech 35-C33 · S/N CD-829 · Cancelled Sep 28, 1977 · Wayland Terri L
- [N917RG](https://openairdocs.org/deregistered/N917RG-1977-07-14.md): Aero Commander 680T · S/N 1576-30 · Cancelled Jul 14, 1977 · Scott Josef
- [N2288S](https://openairdocs.org/deregistered/N2288S-1977-02-24.md): Cessna 210L · S/N 21061231 · Cancelled Feb 24, 1977 · Fiering Alan C
- [N318K](https://openairdocs.org/deregistered/N318K-1975-05-08.md): Beech B-55 · S/N TC-837 · Cancelled May 8, 1975 · Neighbor Ernest G
- [N79082](https://openairdocs.org/deregistered/N79082-1970-09-03.md): Convair BT-13 · S/N 6263 · Cancelled Sep 3, 1970 · Reed Fred M
- [N771F](https://openairdocs.org/deregistered/N771F-1970-06-09.md): Smith SMITH MINIPLANE · S/N 641 · Cancelled Jun 9, 1970 · Norris Robert E

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

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