# Cancelled registrations: Anthony, KS

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

Cancelled aircraft registrations in Anthony, KS.

- [N4047Y](https://openairdocs.org/deregistered/N4047Y-2019-05-04.md): Balloon Works FIREFLY 7 · S/N 7907 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1979 · Wilcox Herbert L DBA
- [N25086](https://openairdocs.org/deregistered/N25086-2018-12-04.md): Piper J4A · S/N 4807 · Cancelled Dec 4, 2018 · Revoked, canceled · Built 1939 · Whitaker Roy W
- [N2325B](https://openairdocs.org/deregistered/N2325B-2018-09-13.md): Piccard AX-7 · S/N 13 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Wilcox Herbert L
- [N7106N](https://openairdocs.org/deregistered/N7106N-2018-09-13.md): Balloon Works FIREFLY 7 · S/N F7-405 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1987 · Wilcox Herbert
- [N14S](https://openairdocs.org/deregistered/N14S-2018-04-19.md): Stokes CONDOR 56 · S/N CONHAB7 · Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1973 · Balloons Aloft
- [N74045](https://openairdocs.org/deregistered/N74045-2018-03-29.md): Balloon Works FIREFLY 8B · S/N F8B-041 · Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Wilcox Herbert L
- [N76HW](https://openairdocs.org/deregistered/N76HW-2018-03-29.md): Wilcox HW · S/N HW3 · Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1976 · Wilcox Herbert L
- [N2081F](https://openairdocs.org/deregistered/N2081F-2018-03-20.md): Balloon Works FIREFLY 6B · S/N 6632 · Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1976 · Balloons Aloft
- [N2459H](https://openairdocs.org/deregistered/N2459H-2018-03-12.md): Balloon Works FIREFLY 6B · S/N 6721 · Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1978 · Wilcox Herbert L
- [N9084U](https://openairdocs.org/deregistered/N9084U-2018-03-07.md): Balloon Works FIREFLY 7B-15 · S/N F7B-325 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1991 · Wilcox Herbert L
- [N57740](https://openairdocs.org/deregistered/N57740-2013-04-23.md): Piper PA-36-285 · S/N 36-7660055 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1976 · Copenhaver Tracy K
- [N731WP](https://openairdocs.org/deregistered/N731WP-2013-02-21.md): Cessna A188B · S/N 18803216 · Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1978
- [N5723K](https://openairdocs.org/deregistered/N5723K-2013-02-01.md): Raven S55A · S/N S55A-736 · Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1980
- [N4827R](https://openairdocs.org/deregistered/N4827R-2012-08-27.md): Cessna 188B · S/N 18802346 · Cancelled Aug 27, 2012 · Sale reported, pending cancellation · Built 1975
- [N9579G](https://openairdocs.org/deregistered/N9579G-1978-05-19.md): Cessna 188B · S/N 18801544 · Cancelled May 19, 1978 · Copenhaver T K
- [N4611Y](https://openairdocs.org/deregistered/N4611Y-1972-01-04.md): Piper PA-25-235 · S/N 25-4311 · Cancelled Jan 4, 1972 · Built 1967 · Linn Kenneth
- [N64485](https://openairdocs.org/deregistered/N64485-1956-02-17.md): Fairchild M-62C(PT-23A) · S/N 2423-AE · Cancelled Feb 17, 1956 · Southern Kansas Air Transit Inc
- [N85918](https://openairdocs.org/deregistered/N85918-1955-05-23.md): Aeronca 11AC · S/N 11AC-343 · Cancelled May 23, 1955 · Fankhauser Dale
- [N54224](https://openairdocs.org/deregistered/N54224-1955-03-04.md): Fairchild M-62A · S/N T40-423 · Cancelled Mar 4, 1955 · C L Harrison
- [N3869K](https://openairdocs.org/deregistered/N3869K-1952-03-31.md): Temco GC-1B · S/N 3569 · Cancelled Mar 31, 1952 · Mcneal Don
- [N2251E](https://openairdocs.org/deregistered/N2251E-1951-01-26.md): Aeronca 7AC · S/N 7AC-5825 · Cancelled Jan 26, 1951 · Wilcox J Howard
- [N2848K](https://openairdocs.org/deregistered/N2848K-1950-06-08.md): Luscombe 8A · S/N 5575 · Cancelled Jun 8, 1950 · Southern Kansas Air Transit Inc
- [N71589](https://openairdocs.org/deregistered/N71589-1949-10-03.md): Luscombe 8A · S/N 3016 · Cancelled Oct 3, 1949 · Cornick Glen D
- [N84514](https://openairdocs.org/deregistered/N84514-1949-03-18.md): Aeronca 7AC · S/N 3217 · Cancelled Mar 18, 1949 · Wilcox Howard J

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

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