# Cancelled registrations: Sayville, NY

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

Cancelled aircraft registrations in Sayville, NY.

- [N9898A](https://openairdocs.org/deregistered/N9898A-2018-02-08.md): Cessna 195 · S/N 7604 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1950 · Hunter Douglas
- [N92052](https://openairdocs.org/deregistered/N92052-2017-02-13.md): Piper J3C-65 · S/N 16485 · Cancelled Feb 13, 2017 · Revoked, canceled · Built 1946 · Long Island Sch Of Aero Inc
- [N5073L](https://openairdocs.org/deregistered/N5073L-2015-05-20.md): Threlkeld R James GYRO-KOPP-TERS · S/N GK0406TE22MS0017 · Cancelled May 20, 2015 · Registration pending, canceled · Built 2006
- [N84847](https://openairdocs.org/deregistered/N84847-2013-09-12.md): Allen Richard H SE5A REPLICA · S/N 074168 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Allen Richard H
- [N58146](https://openairdocs.org/deregistered/N58146-2012-08-27.md): Cessna T-50 · S/N 5857 · Cancelled Aug 27, 2012 · Revoked, canceled · Built 1944 · L I School Of Aeronautics Inc
- [N42DW](https://openairdocs.org/deregistered/N42DW-2003-02-10.md): Westin Douglas VARIEZE · S/N 1238 · Cancelled Feb 10, 2003 · Triennial form not returned · Built 1981 · Westin Douglas
- [N429FL](https://openairdocs.org/deregistered/N429FL-1994-02-07.md): Piper PA-28-140 · S/N 287125212 · Cancelled Feb 7, 1994 · Triennial form not returned · Mitchell William E
- [N5600S](https://openairdocs.org/deregistered/N5600S-1981-05-08.md): Beech V35 · S/N D-8151 · Cancelled May 8, 1981 · Faber Louis
- [N99775](https://openairdocs.org/deregistered/N99775-1976-04-09.md): Ames Industrial BD5J · S/N 012 · Cancelled Apr 9, 1976 · Built 1976 · Holmes Henry V
- [N94015](https://openairdocs.org/deregistered/N94015-1973-06-25.md): Engineering & Research 415-C · S/N 1338 · Cancelled Jun 25, 1973 · Depontes August
- [N7833H](https://openairdocs.org/deregistered/N7833H-1965-05-20.md): Piper PA-12 · S/N 12-733 · Cancelled May 20, 1965 · Thomas Orourke Gallagher Inc
- [N41997](https://openairdocs.org/deregistered/N41997-1955-10-21.md): Curtiss Wright SNC-1 · S/N 4219 · Cancelled Oct 21, 1955 · W F Mcdonald
- [N78222](https://openairdocs.org/deregistered/N78222-1954-09-13.md): Globe GC-1B · S/N 2222 · Cancelled Sep 13, 1954 · Poulos Anthony M
- [N3699A](https://openairdocs.org/deregistered/N3699A-1954-07-19.md): Piper PA-18A-135 · S/N 18-3048 · Cancelled Jul 19, 1954 · Exported to Venezuela · Central Aviation & Marine Corp
- [N3697A](https://openairdocs.org/deregistered/N3697A-1954-04-19.md): Piper PA-18A-135 · S/N 18-3046 · Cancelled Apr 19, 1954 · Exported to Venezuela · Central Aviation & Marine Corp
- [N711M](https://openairdocs.org/deregistered/N711M-1933-02-01.md): Curtis Harvey H C-1 · S/N 724 · Cancelled Feb 1, 1933 · Long Island Flying Corp

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

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