# Cancelled registrations: Shirley, NY

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

Cancelled aircraft registrations in Shirley, NY.

- [N9218J](https://openairdocs.org/deregistered/N9218J-2021-09-04.md): Piper PA-28-180 · S/N 28-3288 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1966 · R K B Flyers Inc
- [N5781H](https://openairdocs.org/deregistered/N5781H-2019-12-13.md): Piper PA-16 · S/N 16-396 · Cancelled Dec 13, 2019 · Revoked, canceled · Built 1949 · Heins Robert
- [N2103R](https://openairdocs.org/deregistered/N2103R-2018-02-07.md): Cessna 182G · S/N 18255303 · Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1964 · Johanntges Carl M
- [N6336N](https://openairdocs.org/deregistered/N6336N-2013-08-06.md): Champion 7GCAA · S/N 163 · Cancelled Aug 6, 2013 · Revoked, canceled · Built 1967 · Sky Sailors Inc
- [N7068G](https://openairdocs.org/deregistered/N7068G-2013-06-10.md): Cessna 172K · S/N 17258768 · Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1969
- [N6274M](https://openairdocs.org/deregistered/N6274M-2013-04-29.md): Stinson 108-3 · S/N 108-4274 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1948 · Spaulding Roger A
- [N7673U](https://openairdocs.org/deregistered/N7673U-2012-08-10.md): Cessna 150M · S/N 15077799 · Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1976
- [N413DC](https://openairdocs.org/deregistered/N413DC-2011-10-27.md): Piper PA-28-161 · S/N 2842218 · Cancelled Oct 27, 2011 · Exported to Australia · Built 2004 · Sport Flying USA Inc
- [N9561U](https://openairdocs.org/deregistered/N9561U-2009-09-17.md): Grumman American Avn. AA-1C · S/N AA1C0034 · Cancelled Sep 17, 2009 · Registration revoked · Built 1977 · Northfield Aviation Services Co Inc
- [N9520F](https://openairdocs.org/deregistered/N9520F-2004-09-20.md): Hughes 269B · S/N 580362 · Cancelled Sep 20, 2004 · Built 1968 · Tomaino John
- [N5029L](https://openairdocs.org/deregistered/N5029L-2001-05-22.md): Bellanca 7GCBC · S/N 1061-78 · Cancelled May 22, 2001 · Triennial form not returned · Brookfield Aviation Inc
- [N8612V](https://openairdocs.org/deregistered/N8612V-1994-06-08.md): Bellanca 7KCAB · S/N 50375 · Cancelled Jun 8, 1994 · Triennial form not returned · Mid Island Air Svc Inc
- [N2851A](https://openairdocs.org/deregistered/N2851A-1992-03-02.md): Piper PA-34-200T · S/N 347970282 · Cancelled Mar 2, 1992 · Exported to Greece · Alpha Sigma Aviation Ltd
- [N6004L](https://openairdocs.org/deregistered/N6004L-1976-06-24.md): Piper PA-31 · S/N 31-311 · Cancelled Jun 24, 1976 · Four Winds Air Service Ltd
- [N1884Y](https://openairdocs.org/deregistered/N1884Y-1970-04-14.md): Cessna 172C · S/N 17249484 · Cancelled Apr 14, 1970 · Coraci Anthony
- [N2472D](https://openairdocs.org/deregistered/N2472D-1965-05-18.md): Cessna 170B · S/N 20624 · Cancelled May 18, 1965 · Clark James 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 = 'NY' AND d.registrant_city = 'SHIRLEY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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