# Cancelled registrations: Deer Park, NY

A list on [Deer Park, NY](https://openairdocs.org/faa-place/NY/Deer%20Park.md).

Cancelled aircraft registrations in Deer Park, NY.

- [N263MP](https://openairdocs.org/deregistered/N263MP-2013-09-27.md): Pecchio Martin L MARCHETTI 263MP · S/N 045992 · Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Pecchio Martin L
- [N3390U](https://openairdocs.org/deregistered/N3390U-2013-08-13.md): Cessna 182F · S/N 18254790 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1963 · Hipp Vincent
- [N64279](https://openairdocs.org/deregistered/N64279-2013-04-29.md): Dehavilland BEAVER U-6A · S/N 54-1717 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1954 · Lewis A Wilson Technical Center
- [N65823](https://openairdocs.org/deregistered/N65823-2013-02-13.md): Schweizer SGS 2-33A · S/N 323 · Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1974
- [N4291A](https://openairdocs.org/deregistered/N4291A-2012-11-21.md): Piper L-21A · S/N 18-923 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Lewis A Wilson Technical Center
- [N31612](https://openairdocs.org/deregistered/N31612-2012-11-06.md): Cessna U-3A · S/N 58-2179 · Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1958 · Board Of Cooperative Educational Services
- [N1508K](https://openairdocs.org/deregistered/N1508K-1994-01-11.md): Balloon Works FIREFLY 7 · S/N 11196 · Cancelled Jan 11, 1994 · Triennial form not returned · Sklute Kenneth L
- [N6336R](https://openairdocs.org/deregistered/N6336R-1974-05-09.md): Piper PA-28-140 · S/N 28-21505 · Cancelled May 9, 1974 · Allied Airmotive Inc
- [N7079F](https://openairdocs.org/deregistered/N7079F-1972-08-30.md): Cessna 150 · S/N 15063679 · Cancelled Aug 30, 1972 · Exported to Germany · Built 1966 · Allied Airmotive Inc
- [N29333](https://openairdocs.org/deregistered/N29333-1972-06-29.md): Cessna 177 · S/N 17700819 · Cancelled Jun 29, 1972 · Hayman William
- [N46657](https://openairdocs.org/deregistered/N46657-1972-02-25.md): Cessna 172K · S/N 17257415 · Cancelled Feb 25, 1972 · Mid Island Air Service Inc
- [N22823](https://openairdocs.org/deregistered/N22823-1972-01-25.md): Cessna 150H · S/N 15068543 · Cancelled Jan 25, 1972 · Mid-Island Air Service Inc
- [N8094S](https://openairdocs.org/deregistered/N8094S-1970-07-07.md): Cessna 150F · S/N 15061694 · Cancelled Jul 7, 1970 · Allied Airmotive Inc
- [N5144L](https://openairdocs.org/deregistered/N5144L-1970-06-30.md): Piper PA-28-180 · S/N 28-4429 · Cancelled Jun 30, 1970 · Mid Island Air Service Inc
- [N6191T](https://openairdocs.org/deregistered/N6191T-1970-06-30.md): Cessna 150E · S/N 15060891 · Cancelled Jun 30, 1970 · Mid-Island Air Service Inc
- [N8317S](https://openairdocs.org/deregistered/N8317S-1970-06-30.md): Cessna 182H · S/N 18256417 · Cancelled Jun 30, 1970 · Mid-Island Air Service Inc
- [N94118](https://openairdocs.org/deregistered/N94118-1970-04-24.md): Ercoupe 415-C · S/N 1441 · Cancelled Apr 24, 1970 · Built 1946 · Deer Park Airport Inc
- [N98135](https://openairdocs.org/deregistered/N98135-1955-10-17.md): Piper J-3 · S/N 18290 · Cancelled Oct 17, 1955 · Built 1946 · Mid-Island Air Service

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

This list as a web page: https://openairdocs.org/faa-place/NY/Deer%20Park/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
