# Cancelled registrations: Williamsville, NY

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

Cancelled aircraft registrations in Williamsville, NY.

- [N71171](https://openairdocs.org/deregistered/N71171-2018-02-02.md): Raven Industries S-66A · S/N S66A-106 · Cancelled Feb 2, 2018 · Registration expired, pending cancellation · Built 1980 · Corey Thomas J
- [N508CT](https://openairdocs.org/deregistered/N508CT-2015-06-16.md): Flight Design CTSW · S/N 06-10-06 · Cancelled Jun 16, 2015 · First renewal notice · Built 2006 · Schnabel John A
- [N18717](https://openairdocs.org/deregistered/N18717-2014-09-10.md): Cessna 150L · S/N 15074057 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1972 · Ranger Terry L
- [N6217U](https://openairdocs.org/deregistered/N6217U-2013-08-05.md): Mooney M20C · S/N 2056 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1962 · Hiestand Harry E
- [N9689](https://openairdocs.org/deregistered/N9689-2013-05-23.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1222 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1974 · Baird Albert R
- [N5788F](https://openairdocs.org/deregistered/N5788F-2012-11-13.md): Piper PA-28-140 · S/N 28-25095 · Cancelled Nov 13, 2012 · Exported to Canada · Built 1968 · Oneil Erik M
- [N224JK](https://openairdocs.org/deregistered/N224JK-2012-08-30.md): Kozak KR-2 · S/N 514 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1977 · Kozak Julian
- [N117HS](https://openairdocs.org/deregistered/N117HS-2003-02-04.md): Beech 58TC · S/N TK-21 · Cancelled Feb 4, 2003 · Triennial form not returned · Built 1976 · 270 West Main Inc
- [N12JD](https://openairdocs.org/deregistered/N12JD-1998-08-05.md): Daley-Flybaby 1A · S/N 697 · Cancelled Aug 5, 1998 · Registration revoked · Daley Joseph F
- [N1352D](https://openairdocs.org/deregistered/N1352D-1995-07-11.md): Cessna 170A · S/N 20105 · Cancelled Jul 11, 1995 · Triennial form not returned · Sikora John W
- [N9242K](https://openairdocs.org/deregistered/N9242K-1994-06-27.md): Piper PA-28R-200 · S/N 28R7635228 · Cancelled Jun 27, 1994 · Triennial form not returned · Gordy Robert Stephen
- [N4364L](https://openairdocs.org/deregistered/N4364L-1980-10-02.md): Cessna 172G · S/N 17254439 · Cancelled Oct 2, 1980 · Built 1966 · Buddenhagen Theodore F
- [N8529R](https://openairdocs.org/deregistered/N8529R-1970-06-10.md): Bellanca 14-19-3A · S/N 4291 · Cancelled Jun 10, 1970 · Attea Martin P
- [N2550E](https://openairdocs.org/deregistered/N2550E-1967-06-19.md): Aeronca 7AC · S/N 7AC-6133 · Cancelled Jun 19, 1967 · Exported to Canada · Richard D Kolczynski
- [N4894M](https://openairdocs.org/deregistered/N4894M-1963-11-15.md): Piper PA-11 · S/N 11-418 · Cancelled Nov 15, 1963 · Exported to Canada · Williamsville Flying Club Inc
- [N11753](https://openairdocs.org/deregistered/N11753-1948-07-16.md): Monocoupe 90A · S/N A-684 · Cancelled Jul 16, 1948 · Schmitt Peter J
- [N38819](https://openairdocs.org/deregistered/N38819-1948-06-08.md): Piper J3L-65 · S/N 7305 · Cancelled Jun 8, 1948 · Built 1941 · Brophy Vincent Ernest
- [N530W](https://openairdocs.org/deregistered/N530W-1948-03-26.md): Universal Moulded Products MONOCOUPE 90 · S/N 593 · Cancelled Mar 26, 1948 · De Yoreo Silvio F

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

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