# Cancelled registrations: Long Island, NY

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

Cancelled aircraft registrations in Long Island, NY.

Page 1 of 2 · 71 registrations

- [N8962R](https://openairdocs.org/deregistered/N8962R-2017-02-02.md): Aeronca 7FC · S/N 7FC390 · Cancelled Feb 2, 2017 · Revoked, pending cancellation · Built 1960 · Deer Park Avn Cntr Inc
- [N2106U](https://openairdocs.org/deregistered/N2106U-2013-08-07.md): Brantly B-2 · S/N 152 · Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1961 · Zissis George
- [N8PA](https://openairdocs.org/deregistered/N8PA-2013-02-27.md): Adikes SCORPION TOO · S/N 3289 · Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1975
- [N92972](https://openairdocs.org/deregistered/N92972-2012-11-19.md): Commonwealth 185 · S/N 1705 · Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1946
- [N722BH](https://openairdocs.org/deregistered/N722BH-1991-06-25.md): Beech A36 · S/N E444 · Cancelled Jun 25, 1991 · Triennial form not returned · Fairview Flyers
- [N6461K](https://openairdocs.org/deregistered/N6461K-1981-02-13.md): Republic RC-3 · S/N 712 · Cancelled Feb 13, 1981 · Hausman Leo
- [N8620H](https://openairdocs.org/deregistered/N8620H-1973-10-18.md): North American NAVION · S/N NAV-4-585 · Cancelled Oct 18, 1973 · Nicholas G Barry
- [N46851](https://openairdocs.org/deregistered/N46851-1970-07-02.md): Fairchild M-62A · S/N T43-7004 · Cancelled Jul 2, 1970 · Frogs Flying Field Inc
- [N69220](https://openairdocs.org/deregistered/N69220-1970-07-02.md): Consolidated Vultee BT-15 · S/N 9511 · Cancelled Jul 2, 1970 · Frogs Flying Field Inc
- [N1447L](https://openairdocs.org/deregistered/N1447L-1970-06-05.md): Beech A23 · S/N M-788 · Cancelled Jun 5, 1970 · Exported to Sweden · Built 1965 · Berkoski Robert S
- [N6828X](https://openairdocs.org/deregistered/N6828X-1967-12-15.md): Cessna 172A · S/N 47728 · Cancelled Dec 15, 1967 · Bridge Plaza Rental Corp
- [N674U](https://openairdocs.org/deregistered/N674U-1966-06-08.md): Grumman American Avn. G-164A · S/N 413 · Cancelled Jun 8, 1966 · Exported to Canada · Grumman Aircraft Engineering Corp
- [N1448L](https://openairdocs.org/deregistered/N1448L-1965-11-05.md): Beech A23 · S/N M-789 · Cancelled Nov 5, 1965 · Exported to Sweden · Berkoski Robert S
- [N3303P](https://openairdocs.org/deregistered/N3303P-1965-05-21.md): Piper PA-23-160 · S/N 23-1253 · Cancelled May 21, 1965 · Mattituck Aviation Corp
- [N85048](https://openairdocs.org/deregistered/N85048-1964-05-26.md): Aeronca 7AC · S/N 7AC-3775 · Cancelled May 26, 1964 · Edwards Flying Service Inc
- [N228N](https://openairdocs.org/deregistered/N228N-1964-05-14.md): Piper J3C-65S · S/N 12894 · Cancelled May 14, 1964 · Long Island Group New York Wing Civil Air Patrol
- [N2330D](https://openairdocs.org/deregistered/N2330D-1958-05-17.md): Cessna 170B · S/N 20482 · Cancelled May 17, 1958 · Exported to Germany · Gryl Frank J
- [N77843](https://openairdocs.org/deregistered/N77843-1958-03-10.md): Luscombe 8A · S/N 3570 · Cancelled Mar 10, 1958 · Built 1946 · Altman Paul
- [N1112P](https://openairdocs.org/deregistered/N1112P-1956-05-11.md): Piper PA-23 · S/N 23-122 · Cancelled May 11, 1956 · Exported to Venezuela · Teeny'S Construction Corporation
- [N42813](https://openairdocs.org/deregistered/N42813-1956-03-05.md): Piper J3C-65 · S/N 15131 · Cancelled Mar 5, 1956 · Riverhead Airpark Co Inc
- [N95452](https://openairdocs.org/deregistered/N95452-1956-02-27.md): Grumman J2F3 · S/N 511 · Cancelled Feb 27, 1956 · Pess Air
- [N4620E](https://openairdocs.org/deregistered/N4620E-1956-01-31.md): Aeronca 7DC · S/N 7DC-159 · Cancelled Jan 31, 1956 · East Hampton Airport
- [N51727](https://openairdocs.org/deregistered/N51727-1956-01-24.md): Ryan Aeronautical ST3KR · S/N 2060 · Cancelled Jan 24, 1956 · Vincent Marrone
- [N33795](https://openairdocs.org/deregistered/N33795-1955-10-24.md): Aeronca 65-TL · S/N L9471 · Cancelled Oct 24, 1955 · Burr Raymond And Burr Joseph
- [N2030K](https://openairdocs.org/deregistered/N2030K-1955-10-04.md): Luscombe 8E · S/N 4757 · Cancelled Oct 4, 1955 · Gooch Harold C Combs W Herbert
- [N4799M](https://openairdocs.org/deregistered/N4799M-1953-10-08.md): Piper PA-11 · S/N 11-313 · Cancelled Oct 8, 1953 · Built 1947 · Edgemere Aviation Corp
- [N4074H](https://openairdocs.org/deregistered/N4074H-1953-03-17.md): Piper PA-12 · S/N 12-3501 · Cancelled Mar 17, 1953 · Englert Frank J
- [N4078H](https://openairdocs.org/deregistered/N4078H-1951-12-28.md): Piper PA-12 · S/N 12-3504 · Cancelled Dec 28, 1951 · Englert Frank J
- [N1431V](https://openairdocs.org/deregistered/N1431V-1951-07-27.md): Curtiss Wright C-46A · S/N 446 · Cancelled Jul 27, 1951 · Exported to Brazil · Sun Chemical Corp
- [N4039K](https://openairdocs.org/deregistered/N4039K-1949-09-09.md): North American NAVION · S/N NAV-4-1039 · Cancelled Sep 9, 1949 · Deans F B
- [N49567](https://openairdocs.org/deregistered/N49567-1948-11-09.md): Piper J3C-65 · S/N 10318 · Cancelled Nov 9, 1948 · Charlotte Niles
- [N33455](https://openairdocs.org/deregistered/N33455-1948-09-19.md): Piper J3C-65S · S/N 5983 · Cancelled Sep 19, 1948 · Suburban Air Service Inc
- [N34714](https://openairdocs.org/deregistered/N34714-1948-08-17.md): Porterfield CP-65 · S/N 880 · Cancelled Aug 17, 1948 · Mcnary Aircraft Corp
- [N13895](https://openairdocs.org/deregistered/N13895-1948-07-26.md): Waco UKC · S/N 3838 · Cancelled Jul 26, 1948 · Blumenthal Belle
- [N14544](https://openairdocs.org/deregistered/N14544-1948-04-09.md): Aeronca C-3 · S/N A-438 · Cancelled Apr 9, 1948 · Ward Walter R
- [N901V](https://openairdocs.org/deregistered/N901V-1948-02-26.md): Curtiss H.S.L. 2 · S/N 266 · Cancelled Feb 26, 1948 · Built 1921 · Homer Wilson & Clifford Alleg
- [N6991H](https://openairdocs.org/deregistered/N6991H-1947-12-03.md): Piper J3C-65 · S/N 20236 · Cancelled Dec 3, 1947 · Built 1946 · Mid-Island Air Service
- [N20824](https://openairdocs.org/deregistered/N20824-1947-11-12.md): Piper J-3 · S/N 2124 · Cancelled Nov 12, 1947 · Edwards George W
- [N39174](https://openairdocs.org/deregistered/N39174-1947-04-08.md): North American SNJ-3 · S/N 77-4283 · Cancelled Apr 8, 1947 · Built 1946 · Robinson Robert H
- [N6831](https://openairdocs.org/deregistered/N6831-1947-04-08.md): Curtiss Robin 3PCLM · S/N G-3 · Cancelled Apr 8, 1947 · Frog'S Flying Field Inc
- [N87451](https://openairdocs.org/deregistered/N87451-1946-08-07.md): Republic RC-3 · S/N 1 · Cancelled Aug 7, 1946 · Built 1945 · Republic Aviation Corp
- [N16014](https://openairdocs.org/deregistered/N16014-1943-09-02.md): Douglas DC3-G102 · S/N 1552 · Cancelled Sep 2, 1943 · American Airlines Inc
- [N297H](https://openairdocs.org/deregistered/N297H-1943-08-27.md): Curtiss Wright FLEDGLING · S/N B-61 · Cancelled Aug 27, 1943 · Safair Inc
- [N29021](https://openairdocs.org/deregistered/N29021-1943-08-07.md): General G1-80 · S/N 8 · Cancelled Aug 7, 1943 · General Aircraft Corp
- [N796M](https://openairdocs.org/deregistered/N796M-1942-02-02.md): Curtiss Wright ROBIN J-1 · S/N 703 · Cancelled Feb 2, 1942 · Rockaway Airport Inc
- [N290H](https://openairdocs.org/deregistered/N290H-1941-08-15.md): Curtiss Wright FLEDGLING · S/N B-55 · Cancelled Aug 15, 1941 · Hebert Oscar P C/O Safair Inc
- [N8012](https://openairdocs.org/deregistered/N8012-1941-03-01.md): American Airplane & Engine PILGRIM FC-2 · S/N 163 · Cancelled Mar 1, 1941 · Roosevelt Field Inc
- [N25196](https://openairdocs.org/deregistered/N25196-1940-04-04.md): Brewster FLEET 2 · S/N 38 · Cancelled Apr 4, 1940 · Exported to Finland · Built 1940 · Brewster Aeronautical Corp
- [N2434](https://openairdocs.org/deregistered/N2434-1940-03-01.md): Piper E-2 · S/N 65 · Cancelled Mar 1, 1940 · Denny Daitz Flying Corp
- [N10834](https://openairdocs.org/deregistered/N10834-1939-05-17.md): Stinson JR. S · S/N 8028 · Cancelled May 17, 1939 · Denny Daitz Flying Corp

Next page: https://openairdocs.org/faa-place/NY/Long%20Island/earlier.md?page=2

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

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