# Cancelled registrations: Paola, KS

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

Cancelled aircraft registrations in Paola, KS.

- [N8868G](https://openairdocs.org/deregistered/N8868G-2022-02-05.md): Cessna 150F · S/N 15062968 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1966 · Davis Clint H
- [N117HM](https://openairdocs.org/deregistered/N117HM-2019-11-29.md): Mace Harvey F M103 · S/N 9 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Blumhorst Rick W
- [N9917Y](https://openairdocs.org/deregistered/N9917Y-2019-09-06.md): Cessna 210N · S/N 21064638 · Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1981
- [N5152P](https://openairdocs.org/deregistered/N5152P-2018-05-30.md): Piper PA-24 · S/N 24-168 · Cancelled May 30, 2018 · Sale reported, canceled · Built 1958
- [N7027M](https://openairdocs.org/deregistered/N7027M-2017-10-31.md): Cessna 175 · S/N 55327 · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1958 · Yackle Andy
- [N589FL](https://openairdocs.org/deregistered/N589FL-2014-12-18.md): Piper PA-28-140 · S/N 28-7125449 · Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1971
- [N1991Z](https://openairdocs.org/deregistered/N1991Z-2013-11-01.md): Zimmerman Roger 1910 BARNWELL · S/N 1910 · Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Zimmerman Roger M
- [N4315J](https://openairdocs.org/deregistered/N4315J-2013-07-16.md): Piper PA-28-140 · S/N 28-22689 · Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1967 · Wilson Charles E
- [N50KT](https://openairdocs.org/deregistered/N50KT-2013-06-05.md): Beech E50 · S/N LH-187 · Cancelled Jun 5, 2013 · Sale reported, canceled
- [N50WU](https://openairdocs.org/deregistered/N50WU-2013-06-05.md): Beech E50 · S/N LH-128 · Cancelled Jun 5, 2013 · Sale reported, canceled
- [N60274](https://openairdocs.org/deregistered/N60274-2013-03-13.md): Cessna 172S · S/N 172S10161 · Cancelled Mar 13, 2013 · Exported to Brazil · Built 2006 · N60274 LLC
- [N59229](https://openairdocs.org/deregistered/N59229-2013-02-01.md): Bowers Fly Baby 1A-BIS · S/N 278 · Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1972
- [N3671K](https://openairdocs.org/deregistered/N3671K-2012-08-30.md): Balloon Works FIREFLY 7 · S/N F7-087 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1983 · Odell Melvin W
- [N234EM](https://openairdocs.org/deregistered/N234EM-2011-12-28.md): Piper PA-28-181 · S/N 28-7990183 · Cancelled Dec 28, 2011 · Exported to Brazil · Built 1978 · Aerofox USA
- [N7811A](https://openairdocs.org/deregistered/N7811A-2011-06-28.md): Cessna 180A · S/N 32708 · Cancelled Jun 28, 2011 · Revoked, pending cancellation · Built 1956 · Howard Constr Co
- [N2598Z](https://openairdocs.org/deregistered/N2598Z-2011-06-22.md): Bellanca 7ECA · S/N 1222-77 · Cancelled Jun 22, 2011 · Second renewal notice · Built 1977 · Linder Gene D
- [N111LJ](https://openairdocs.org/deregistered/N111LJ-2010-11-02.md): Beech A36 · S/N E-1822 · Cancelled Nov 2, 2010 · Exported to Brazil · Built 1981 · Hellyer Harry L
- [N87S](https://openairdocs.org/deregistered/N87S-2008-12-04.md): Cessna 150K · S/N 15071289 · Cancelled Dec 4, 2008 · Exported to Brazil · Hellyer Harry L
- [N59027](https://openairdocs.org/deregistered/N59027-2005-04-05.md): Cessna T210L · S/N 21060033 · Cancelled Apr 5, 2005 · Exported to Mexico · Built 1973
- [N39231](https://openairdocs.org/deregistered/N39231-1991-01-29.md): Taylorcraft BC12-D · S/N 6485 · Cancelled Jan 29, 1991 · Triennial form not returned · Vogel Stanley E
- [N4980D](https://openairdocs.org/deregistered/N4980D-1974-08-02.md): Cessna 182A · S/N 51080 · Cancelled Aug 2, 1974 · Wilson Charles R
- [N3868J](https://openairdocs.org/deregistered/N3868J-1972-01-03.md): Cessna 150G · S/N 15065168 · Cancelled Jan 3, 1972 · Kan-Av Associates 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 = 'KS' AND d.registrant_city = 'PAOLA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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