# Cancelled registrations: Huntington, NY

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

Cancelled aircraft registrations in Huntington, NY.

- [N3481H](https://openairdocs.org/deregistered/N3481H-2019-11-29.md): Engineering & Research ERCOUPE 415-C · S/N 4106 · Cancelled Nov 29, 2019 · Revoked, canceled · Built 1946 · Read William S
- [N77690](https://openairdocs.org/deregistered/N77690-2017-11-21.md): Fairchild 24R-46 · S/N R46390 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Chouteau Azby A
- [N29VE](https://openairdocs.org/deregistered/N29VE-2014-09-29.md): Ica Brasov IS-29D2 · S/N 86 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1977 · Salek Karel
- [N200ZZ](https://openairdocs.org/deregistered/N200ZZ-2013-09-19.md): Martin Edward W ROTORWAY EXEC · S/N RW-3101 · Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Martin Edward W
- [N124B](https://openairdocs.org/deregistered/N124B-2013-06-11.md): Bunnell George R MONERAI S · S/N 248 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1984 · Bunnell George R
- [N37326](https://openairdocs.org/deregistered/N37326-2013-06-07.md): Balloon Works FIREFLY 7 · S/N F7-112 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Allen Linda D
- [N9433Z](https://openairdocs.org/deregistered/N9433Z-2013-05-22.md): Grumman TBM-3E · S/N 91586 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1957 · Friends For Long Islands Heritage
- [N872L](https://openairdocs.org/deregistered/N872L-2012-11-14.md): Beech E18S · S/N BA-349 · Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1958
- [N199MG](https://openairdocs.org/deregistered/N199MG-1991-02-28.md): Gordon Craig TEENIE TWO · S/N 510537 · Cancelled Feb 28, 1991 · Triennial form not returned · Gordon Craig A
- [N3033J](https://openairdocs.org/deregistered/N3033J-1983-09-04.md): Piper PA-32R-301 · S/N 32R-8013016 · Cancelled Sep 4, 1983 · Minton Betty Ann
- [N22653](https://openairdocs.org/deregistered/N22653-1975-08-29.md): Cessna 150H · S/N 15068429 · Cancelled Aug 29, 1975 · Freda Richard
- [N5116T](https://openairdocs.org/deregistered/N5116T-1973-11-12.md): Champion 7ECA · S/N 433 · Cancelled Nov 12, 1973 · Paris E Robert
- [N1349K](https://openairdocs.org/deregistered/N1349K-1970-11-30.md): Luscombe 8A · S/N 4076 · Cancelled Nov 30, 1970 · Gordon Mccreary
- [N118A](https://openairdocs.org/deregistered/N118A-1970-11-23.md): Lockheed 749A-79 · S/N 2615 · Cancelled Nov 23, 1970 · Airline Management & Investment Inc
- [N8294K](https://openairdocs.org/deregistered/N8294K-1970-06-25.md): Stinson 108 · S/N 1081294 · Cancelled Jun 25, 1970 · Armellino Richard A
- [N3309P](https://openairdocs.org/deregistered/N3309P-1961-05-31.md): Piper PA-23-160 · S/N 23-1260 · Cancelled May 31, 1961 · Exported to Canada · Daley Francis A
- [N7619A](https://openairdocs.org/deregistered/N7619A-1959-05-18.md): Cessna 180 · S/N 32516 · Cancelled May 18, 1959 · Exported to Canada · Hazelhurst Corp
- [N4025K](https://openairdocs.org/deregistered/N4025K-1948-04-26.md): North American NAVION · S/N NAV-4-1025 · Cancelled Apr 26, 1948 · Driscoll Dave
- [N455V](https://openairdocs.org/deregistered/N455V-1940-06-04.md): American Eagle 230 · S/N 1014 · Cancelled Jun 4, 1940 · Built 1930 · Piscopo John R

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

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