# Cancelled registrations: Kenmore, NY

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

Cancelled aircraft registrations in Kenmore, NY.

- [N881AV](https://openairdocs.org/deregistered/N881AV-2022-01-11.md): R4robotics R4 COMPACT ROLLER · S/N R4CR0720202 · Cancelled Jan 11, 2022 · Sale reported, canceled
- [N666NZ](https://openairdocs.org/deregistered/N666NZ-2018-05-31.md): 3D Robotics SOLO · S/N 121B · Cancelled May 31, 2018 · Sale reported, canceled
- [N29577](https://openairdocs.org/deregistered/N29577-2018-03-23.md): Taylorcraft BF · S/N 2420 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1940 · Caneen Jerome A
- [N39369](https://openairdocs.org/deregistered/N39369-2017-11-18.md): Aeronca 65-TAC · S/N C4342TA · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1942 · Hollands Ted B
- [N5798M](https://openairdocs.org/deregistered/N5798M-2012-08-27.md): Cessna 310P · S/N 310P0098 · Cancelled Aug 27, 2012 · Revoked, canceled · Built 1969 · Harold Laverne Bucholtz Inc
- [N50972](https://openairdocs.org/deregistered/N50972-1984-07-10.md): Cessna 172L · S/N 17259681 · Cancelled Jul 10, 1984 · Exported to Canada · Kenebuc Buffalo Inc
- [N6579K](https://openairdocs.org/deregistered/N6579K-1974-10-11.md): Republic RC-3 · S/N 852 · Cancelled Oct 11, 1974 · Nichols Donald Edward
- [N27733](https://openairdocs.org/deregistered/N27733-1970-12-31.md): Stinson 10A · S/N 7672 · Cancelled Dec 31, 1970 · Favale Frank S
- [N3667E](https://openairdocs.org/deregistered/N3667E-1967-02-08.md): Aeronca 7AC · S/N 7AC-6980 · Cancelled Feb 8, 1967 · Exported to Canada · Transit Acft Salvage & Repair Corp
- [N35174](https://openairdocs.org/deregistered/N35174-1965-05-20.md): Piper J3L-65 · S/N 6163 · Cancelled May 20, 1965 · Frank S Favale
- [N9621K](https://openairdocs.org/deregistered/N9621K-1961-05-04.md): Stinson 108-2 · S/N 2621 · Cancelled May 4, 1961 · Exported to Canada · Transit Aircraft Salvage & Repair Corp
- [N5605H](https://openairdocs.org/deregistered/N5605H-1959-08-26.md): Piper PA-16 · S/N 16-212 · Cancelled Aug 26, 1959 · Exported to Canada · Built 1949 · Favale Frank S
- [N51885](https://openairdocs.org/deregistered/N51885-1955-10-24.md): Fairchild PT-19A · S/N T42-3578 · Cancelled Oct 24, 1955 · Built 1942 · Hall Ralph Gordon
- [N75120](https://openairdocs.org/deregistered/N75120-1955-10-24.md): Consolidated Vultee BT-15 · S/N 7630 · Cancelled Oct 24, 1955 · William George Hawkins
- [N92510](https://openairdocs.org/deregistered/N92510-1949-07-15.md): Piper PA-12 · S/N 12-33 · Cancelled Jul 15, 1949 · Bensen Richard K
- [N80788](https://openairdocs.org/deregistered/N80788-1949-05-26.md): Globe GC-1A · S/N 191 · Cancelled May 26, 1949 · Washburn Lloyd
- [N29340](https://openairdocs.org/deregistered/N29340-1948-11-08.md): Waco UPF-7 · S/N 5367 · Cancelled Nov 8, 1948 · Benson Richard K
- [N30706](https://openairdocs.org/deregistered/N30706-1943-05-01.md): Piper J3C-65 · S/N 5056 · Cancelled May 1, 1943 · Built 1940 · Benson Richard A
- [N15887](https://openairdocs.org/deregistered/N15887-1940-09-01.md): Porterfield 35V · S/N 200 · Cancelled Sep 1, 1940 · Holloway Robert L
- [N12527](https://openairdocs.org/deregistered/N12527-1938-06-01.md): Beazley Nicholas 8G · S/N K-57 · Cancelled Jun 1, 1938 · Built 1932 · Thompson Harold J
- [N781Y](https://openairdocs.org/deregistered/N781Y-1935-08-17.md): Moles Howard R/Kerr John A MOLES/KERR SPECIAL · S/N 1 · Cancelled Aug 17, 1935 · Built 1931 · Moles Howard R & Kerr John A

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

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