# Cancelled registrations: Larned, KS

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

Cancelled aircraft registrations in Larned, KS.

- [N6117Z](https://openairdocs.org/deregistered/N6117Z-2013-08-05.md): Piper PA-25 · S/N 25-137 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1960 · Young Kenneth P DBA
- [N20KT](https://openairdocs.org/deregistered/N20KT-2013-02-01.md): Tate ACRO-SPORT · S/N 20 · Cancelled Feb 1, 2013 · Registration expired, pending cancellation · Built 1975 · Rosner Larhue G
- [N640RS](https://openairdocs.org/deregistered/N640RS-2012-08-20.md): Quad City Ultralight Acft CHALLENGER I · S/N 028730220 · Cancelled Aug 20, 2012 · First renewal notice · Built 1987 · Sallee Robert A
- [N1036P](https://openairdocs.org/deregistered/N1036P-2003-02-06.md): Air Tractor AT-402 · S/N 402-0745 · Cancelled Feb 6, 2003 · Exported to Australia · Built 1990 · First National Bank & Trust Co In Larned
- [N60980](https://openairdocs.org/deregistered/N60980-1995-12-21.md): Air Tractor AT-502B · S/N 502B0287 · Cancelled Dec 21, 1995 · Exported to Australia · Mid Kansas Aerial Inc
- [N22KT](https://openairdocs.org/deregistered/N22KT-1993-12-09.md): Tate SNS-7 · S/N 222 · Cancelled Dec 9, 1993 · Second triennial mailing, no response · Tate Kenneth L
- [N83139](https://openairdocs.org/deregistered/N83139-1961-03-20.md): Aeronca 7AC · S/N 7AC1800 · Cancelled Mar 20, 1961 · Delbert F Erhart
- [N99519](https://openairdocs.org/deregistered/N99519-1960-12-19.md): Ercoupe 415-C · S/N 2142 · Cancelled Dec 19, 1960 · Built 1946 · Greene B Frank
- [N64484](https://openairdocs.org/deregistered/N64484-1956-02-17.md): Fairchild M-62C(PT-23A) · S/N 149HO · Cancelled Feb 17, 1956 · Hewett W A
- [N1790K](https://openairdocs.org/deregistered/N1790K-1952-11-25.md): Luscombe 8E · S/N 4517 · Cancelled Nov 25, 1952 · Davis Leslie S
- [N94101](https://openairdocs.org/deregistered/N94101-1951-01-23.md): Erco 415-C · S/N 1424 · Cancelled Jan 23, 1951 · Standish V O
- [N27588](https://openairdocs.org/deregistered/N27588-1948-10-13.md): Taylorcraft BL-65 · S/N 2229 · Cancelled Oct 13, 1948 · King Richard A Cyril E Sheppard & Allen M Fleming
- [N48457](https://openairdocs.org/deregistered/N48457-1948-05-12.md): Ryan Aeronautical ST3KR · S/N 1314 · Cancelled May 12, 1948 · Love Cecil
- [N497N](https://openairdocs.org/deregistered/N497N-1933-05-08.md): Evans Glider PT2 · S/N 116 · Cancelled May 8, 1933 · Niederee W L
- [N421N](https://openairdocs.org/deregistered/N421N-1933-01-07.md): Yunker Y-1-165 · S/N 1 · Cancelled Jan 7, 1933 · Built 1929 · Beckwith Carrol
- [N423W](https://openairdocs.org/deregistered/N423W-1933-01-03.md): Roydon ROYDON GLIDER · S/N 106 · Cancelled Jan 3, 1933 · Clinesmith S C

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

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