# Cancelled registrations: Port Washington, NY

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

Cancelled aircraft registrations in Port Washington, NY.

- [N7068T](https://openairdocs.org/deregistered/N7068T-2022-08-03.md): Smith Keith T PULSAR SERIES III · S/N P97040520 · Cancelled Aug 3, 2022 · Exported to New Zealand · Built 2003 · Sandul Sandy A
- [N8438F](https://openairdocs.org/deregistered/N8438F-2018-12-19.md): Cessna 401 · S/N 401-0286 · Cancelled Dec 19, 2018 · Registration expired, pending cancellation · Built 1968 · Hagedorn Aviation Inc
- [N6384E](https://openairdocs.org/deregistered/N6384E-2015-05-20.md): Crosby Joseph E ZODIAC 601 HDS · S/N 64008 · Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1999 · All Media Associates Inc
- [N18AU](https://openairdocs.org/deregistered/N18AU-2014-05-22.md): Cessna 404 · S/N 404-0823 · Cancelled May 22, 2014 · Hagedorn Aviation Inc
- [N9514A](https://openairdocs.org/deregistered/N9514A-2013-05-23.md): Mastrocinque BENSEN B-8M · S/N 1 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Mastrocinque Nicholas
- [N2831Y](https://openairdocs.org/deregistered/N2831Y-2012-09-24.md): Piper PA-28-236 · S/N 28-7911195 · Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1979 · Small Irwin Roy
- [N95HP](https://openairdocs.org/deregistered/N95HP-2008-02-15.md): Beech A36TC · S/N EA-195 · Cancelled Feb 15, 2008 · Exported to Brazil · Built 1981 · Port Alloys Corp
- [N758TD](https://openairdocs.org/deregistered/N758TD-1980-07-28.md): Cessna R172K · S/N R1723340 · Cancelled Jul 28, 1980 · Exported to Iceland · Ventura Air Services Inc
- [N28907](https://openairdocs.org/deregistered/N28907-1971-09-14.md): Luscombe 8 · S/N 1649 · Cancelled Sep 14, 1971 · Port Washington Sea Plane Base Inc
- [N2237T](https://openairdocs.org/deregistered/N2237T-1971-05-07.md): Cessna A185E · S/N 185-1391 · Cancelled May 7, 1971 · Exported to Canada · Shore Line Air Service Inc
- [N4270P](https://openairdocs.org/deregistered/N4270P-1964-04-28.md): Piper PA-23-160 · S/N 23-1749 · Cancelled Apr 28, 1964 · Exported to Canada · Hobart A H Cook
- [N1300H](https://openairdocs.org/deregistered/N1300H-1961-10-05.md): Aeronca S15AC · S/N 15AC-324 · Cancelled Oct 5, 1961 · William Paul Deyo
- [N3864C](https://openairdocs.org/deregistered/N3864C-1959-02-17.md): Cessna 180 · S/N 31012 · Cancelled Feb 17, 1959 · Exported to Canada · Langerman Howard
- [N8887B](https://openairdocs.org/deregistered/N8887B-1959-01-19.md): Cessna 172 · S/N 36587 · Cancelled Jan 19, 1959 · Exported to Philippines · Ventura Air Service
- [N3510C](https://openairdocs.org/deregistered/N3510C-1957-05-06.md): Cessna 170B · S/N 26553 · Cancelled May 6, 1957 · Exported to United Kingdom · Ventura Air Service
- [N98293](https://openairdocs.org/deregistered/N98293-1956-03-22.md): Piper J3C-65 · S/N 18659 · Cancelled Mar 22, 1956 · Stenholm Evan B
- [N87469](https://openairdocs.org/deregistered/N87469-1955-11-15.md): Republic RC-3 · S/N 19 · Cancelled Nov 15, 1955 · Exported to Canada · Port Washington Seaplane Base Inc
- [N6136K](https://openairdocs.org/deregistered/N6136K-1954-09-07.md): Republic RC-3 · S/N 322 · Cancelled Sep 7, 1954 · Exported to Bahamas · Sands Point Seaplane Base Inc
- [N14208](https://openairdocs.org/deregistered/N14208-1941-06-24.md): Douglas DOLPHIN 12 · S/N 1284 · Cancelled Jun 24, 1941 · Built 1934 · Vanderbilt George
- [N903V](https://openairdocs.org/deregistered/N903V-1934-09-15.md): Savoia Marchetti S-56 · S/N 33 · Cancelled Sep 15, 1934 · Ferri Frank 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 = 'PORT WASHINGTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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