# Cancelled registrations: Emporia, KS

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

Cancelled aircraft registrations in Emporia, KS.

- [N90009](https://openairdocs.org/deregistered/N90009-2024-03-23.md): Stephens Road Runner 3A · S/N 3A · Cancelled Mar 23, 2024 · Sale reported, canceled · Built 1970
- [N54WD](https://openairdocs.org/deregistered/N54WD-2016-08-24.md): Wilson Douglas E PEGAZAIR SP 150 · S/N 001 · Cancelled Aug 24, 2016 · First renewal notice · Built 1999 · Wilson Douglas E
- [N90455](https://openairdocs.org/deregistered/N90455-2015-05-07.md): Tevis Don SPACEWALKER II · S/N 202 · Cancelled May 7, 2015 · Built 2005 · Tevis Don
- [N65272](https://openairdocs.org/deregistered/N65272-2013-04-30.md): Bush BD-4 · S/N 642 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1977 · Bush Jesse B
- [N75264](https://openairdocs.org/deregistered/N75264-2012-09-12.md): Golden Circle Air T-BIRD · S/N TA-19 · Cancelled Sep 12, 2012 · Registration pending, canceled
- [N93791](https://openairdocs.org/deregistered/N93791-2012-01-21.md): Fisher Bryan L PCHUTE · S/N 01 · Cancelled Jan 21, 2012 · First renewal notice · Fisher Bryan L
- [N6282G](https://openairdocs.org/deregistered/N6282G-2011-03-14.md): Cessna 150K · S/N 15071782 · Cancelled Mar 14, 2011 · Expired dealer · Built 1970 · Kansas Flying Service & Sales Inc
- [N5065U](https://openairdocs.org/deregistered/N5065U-2008-06-19.md): Rans S-12XL · S/N TA-13 · Cancelled Jun 19, 2008 · Exported to Mexico · Built 2002 · Tevis Donald E
- [N5289H](https://openairdocs.org/deregistered/N5289H-2004-12-23.md): Piper PA-16 · S/N 16-93 · Cancelled Dec 23, 2004 · Triennial form not returned · Built 1949 · Farthing Harold B
- [N704BF](https://openairdocs.org/deregistered/N704BF-2002-01-11.md): Cessna 150M · S/N 15078476 · Cancelled Jan 11, 2002 · Triennial form not returned · Built 1976 · Tevis Aviation Inc
- [N305RJ](https://openairdocs.org/deregistered/N305RJ-2001-03-22.md): Mooney M20K · S/N 250602 · Cancelled Mar 22, 2001 · Triennial form not returned · Cripps Rick E
- [N194JP](https://openairdocs.org/deregistered/N194JP-1997-01-22.md): Prevatt David R RV-6 · S/N 21752 · Cancelled Jan 22, 1997 · Prevatt David R
- [N20428](https://openairdocs.org/deregistered/N20428-1991-06-03.md): Cessna 172M · S/N 17261281 · Cancelled Jun 3, 1991 · Westwind Aviation Inc
- [N76448](https://openairdocs.org/deregistered/N76448-1983-11-17.md): Cessna 140 · S/N 10880 · Cancelled Nov 17, 1983 · Traylor Wayne B
- [N104Y](https://openairdocs.org/deregistered/N104Y-1982-04-15.md): Sickler-Lewis B · S/N 1 · Cancelled Apr 15, 1982 · Administratively canceled · Sickler Fred H
- [N8496H](https://openairdocs.org/deregistered/N8496H-1981-09-10.md): Bartram Ralph Dean MUSTANG-II · S/N 879 · Cancelled Sep 10, 1981 · Bartram Ralph D
- [N16009](https://openairdocs.org/deregistered/N16009-1975-09-26.md): Cessna 150L · S/N 15073407 · Cancelled Sep 26, 1975 · Built 1972 · Holy Toledo Flying Service
- [N60410](https://openairdocs.org/deregistered/N60410-1973-10-15.md): Cessna 150J · S/N 15070288 · Cancelled Oct 15, 1973 · Kansas Flying Service And Sales Inc
- [N50450](https://openairdocs.org/deregistered/N50450-1972-03-09.md): Cessna 150J · S/N 15069310 · Cancelled Mar 9, 1972 · Kansas Flying Service & Sales Inc
- [N36542](https://openairdocs.org/deregistered/N36542-1971-04-04.md): Aeronca 65-LB · S/N LB16181 · Cancelled Apr 4, 1971 · Marshall Jerry
- [N7862F](https://openairdocs.org/deregistered/N7862F-1970-06-29.md): Cessna 150F · S/N 15063962 · Cancelled Jun 29, 1970 · Rogers Flying Service
- [N4960P](https://openairdocs.org/deregistered/N4960P-1970-06-23.md): Piper PA-23-235 · S/N 27-561 · Cancelled Jun 23, 1970 · Donald A Glaser
- [N59555](https://openairdocs.org/deregistered/N59555-1960-05-21.md): Cessna T-50 · S/N 3749 · Cancelled May 21, 1960 · Weaver A Marvin
- [N87186](https://openairdocs.org/deregistered/N87186-1956-02-24.md): Ercoupe 415-C · S/N 359 · Cancelled Feb 24, 1956 · Hudson Frank
- [N1958E](https://openairdocs.org/deregistered/N1958E-1951-01-26.md): Aeronca 7AC · S/N 7AC-5525 · Cancelled Jan 26, 1951 · Place Chas A
- [N22179](https://openairdocs.org/deregistered/N22179-1948-06-11.md): Aeronca 50-F · S/N F-2839 · Cancelled Jun 11, 1948 · Built 1939 · Stafford Leonard A
- [N15452](https://openairdocs.org/deregistered/N15452-1936-10-11.md): Porterfield 35-70 · S/N 152 · Cancelled Oct 11, 1936 · Built 1935 · Mood C M
- [N808M](https://openairdocs.org/deregistered/N808M-1936-08-01.md): Saul 1000 · S/N 1001 · Cancelled Aug 1, 1936 · Mood C M

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

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