# Cancelled registrations: Flushing, NY

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

Cancelled aircraft registrations in Flushing, NY.

Page 1 of 2 · 60 registrations

- [N28620](https://openairdocs.org/deregistered/N28620-2019-09-16.md): Luscombe 8C · S/N 1449 · Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1940 · Lantay Frank
- [N1420L](https://openairdocs.org/deregistered/N1420L-2019-08-05.md): Beech A23 · S/N M-813 · Cancelled Aug 5, 2019 · Sale reported, canceled · Built 1965
- [N3701S](https://openairdocs.org/deregistered/N3701S-2018-09-07.md): Cessna 172E · S/N 17250901 · Cancelled Sep 7, 2018 · Sale reported, canceled · Built 1963
- [N3295V](https://openairdocs.org/deregistered/N3295V-2018-05-18.md): Beech 35 · S/N D-746 · Cancelled May 18, 2018 · Revoked, canceled · Built 1947 · Miller Robert L
- [N66888](https://openairdocs.org/deregistered/N66888-2018-03-12.md): BDC Aero Industrie PUMA LSA · S/N AB-59-20-614 · Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Polytech International Resources Corp
- [N910MH](https://openairdocs.org/deregistered/N910MH-2018-01-29.md): Aero Commander 1121 · S/N 45 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1965 · College Of Aeronautics
- [N923TS](https://openairdocs.org/deregistered/N923TS-2018-01-29.md): Boeing 727-225 · S/N 20441 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc DBA Usair Shuttle
- [N795K](https://openairdocs.org/deregistered/N795K-2018-01-24.md): Beech 65-90 · S/N LJ-95 · Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1965 · College Of Aeronautics
- [N30923](https://openairdocs.org/deregistered/N30923-2018-01-10.md): Cessna 177B · S/N 17701548 · Cancelled Jan 10, 2018 · Third renewal notice · Built 1970 · Mei-Chu Corp
- [N2279K](https://openairdocs.org/deregistered/N2279K-2016-08-17.md): Piper PA-18 · S/N 18-2110 · Cancelled Aug 17, 2016 · Third renewal notice · Built 1952 · College Of Aeronautics
- [N927TS](https://openairdocs.org/deregistered/N927TS-2015-05-13.md): Boeing 727-227 · S/N 20837 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1973 · Shuttle Inc DBA
- [N1916D](https://openairdocs.org/deregistered/N1916D-2014-12-22.md): Beech C35 · S/N D-3165 · Cancelled Dec 22, 2014 · Revoked, canceled · Built 1952 · Costas Emanuel J
- [N89807](https://openairdocs.org/deregistered/N89807-2014-11-20.md): Cessna 152 · S/N 15282876 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1978 · Aer Aisling Ltd DBA
- [N7021C](https://openairdocs.org/deregistered/N7021C-2013-11-14.md): Piper PA-34-200T · S/N 34-7670082 · Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1975 · College Of Aeronautics
- [N67451](https://openairdocs.org/deregistered/N67451-2013-10-29.md): Cessna 152 · S/N 15281842 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1978 · Sunset Enterprises Inc
- [N9708U](https://openairdocs.org/deregistered/N9708U-2013-08-21.md): Grumman American Avn. AA-5A · S/N AA5A-0108 · Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1976
- [N1148W](https://openairdocs.org/deregistered/N1148W-2013-08-05.md): Bell 47J-2A · S/N 3125 · Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1964 · Charles M Trojahn Inc
- [N9177Y](https://openairdocs.org/deregistered/N9177Y-2013-07-08.md): Beech B-55 · S/N TF-22 · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · College Of Aeronautics
- [N922TS](https://openairdocs.org/deregistered/N922TS-2013-05-15.md): Boeing 727-225 · S/N 20415 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc DBA
- [N84TS](https://openairdocs.org/deregistered/N84TS-2013-05-10.md): Crawford Timothy L LONG-EZ · S/N RAF-476 · Cancelled May 10, 2013 · Sale reported, canceled · Built 1984
- [N701CC](https://openairdocs.org/deregistered/N701CC-2013-05-03.md): Beech H-18 · S/N BA-740 · Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1966 · Moonlight Express Corp
- [N14BP](https://openairdocs.org/deregistered/N14BP-2013-03-25.md): Piper PA-23-250 · S/N 27-4279 · Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1969
- [N2745Y](https://openairdocs.org/deregistered/N2745Y-2013-02-21.md): Beech 95 · S/N TD-103 · Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1958 · College Of Aeronautics
- [N42749](https://openairdocs.org/deregistered/N42749-2013-01-30.md): Cessna 182L · S/N 18259174 · Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1968
- [N22685](https://openairdocs.org/deregistered/N22685-2012-08-31.md): Cessna 150H · S/N 15068448 · Cancelled Aug 31, 2012 · Registration expired, pending cancellation · Built 1968 · College Of Aeronautics
- [N3404P](https://openairdocs.org/deregistered/N3404P-2008-06-30.md): Piper PA-23-160 · S/N 23-1368 · Cancelled Jun 30, 2008 · Triennial form not returned · Built 1958 · College Of Aeronautics
- [N52DH](https://openairdocs.org/deregistered/N52DH-1999-10-18.md): Hall STEEN SKYBOLT · S/N 1 · Cancelled Oct 18, 1999 · Exported to Ireland · O Sullivan Brian G
- [N404N](https://openairdocs.org/deregistered/N404N-1998-03-26.md): Cessna 404 · S/N 4040855 · Cancelled Mar 26, 1998 · Exported to India · Lefer Blanc Inc
- [N7274N](https://openairdocs.org/deregistered/N7274N-1996-03-18.md): Cessna 310 · S/N 582171 · Cancelled Mar 18, 1996 · Triennial form not returned · College Of Aeronautics
- [N12928](https://openairdocs.org/deregistered/N12928-1993-09-09.md): Cessna 172M · S/N 17262380 · Cancelled Sep 9, 1993 · Exported to Israel · El Rom Inc
- [N89427](https://openairdocs.org/deregistered/N89427-1980-06-25.md): Cessna 152 · S/N 152-82740 · Cancelled Jun 25, 1980 · Exported to Canada · Aer Aisling Ltd
- [N428PA](https://openairdocs.org/deregistered/N428PA-1977-05-12.md): Boeing 707-321B · S/N 19363 · Cancelled May 12, 1977 · Exported to South Korea · Built 1967 · Auerbach Frank Trustee
- [N7467C](https://openairdocs.org/deregistered/N7467C-1971-06-28.md): North American AT-6D · S/N 121-41912 · Cancelled Jun 28, 1971 · Flight Safety Inc
- [N82054](https://openairdocs.org/deregistered/N82054-1971-05-10.md): Aeronca 7AC · S/N 7AC-680 · Cancelled May 10, 1971 · Edwards Flying Service Inc
- [N15659](https://openairdocs.org/deregistered/N15659-1970-09-02.md): Fairchild 24 C8C · S/N 2713 · Cancelled Sep 2, 1970 · Chaarles T Hartzog
- [N83196](https://openairdocs.org/deregistered/N83196-1970-08-24.md): Aeronca 7AC · S/N 7AC-1857 · Cancelled Aug 24, 1970 · Edwards Flying Service Inc
- [N2654B](https://openairdocs.org/deregistered/N2654B-1970-07-13.md): Aero Commander 560 · S/N 154 · Cancelled Jul 13, 1970 · Built 1954 · Academy Of Aeronautics
- [N8828W](https://openairdocs.org/deregistered/N8828W-1970-06-30.md): Piper PA-28-235 · S/N 28-10376 · Cancelled Jun 30, 1970 · Speed'S Flying Service Inc
- [N1888J](https://openairdocs.org/deregistered/N1888J-1970-06-08.md): Piper PA-28-140 · S/N 28-24333 · Cancelled Jun 8, 1970 · Built 1968 · Flight Safety Inc
- [N20609](https://openairdocs.org/deregistered/N20609-1965-05-21.md): Fairchild 24 J · S/N 3511 · Cancelled May 21, 1965 · Speeds Flying Service Inc
- [N3831M](https://openairdocs.org/deregistered/N3831M-1965-05-20.md): Piper PA-12 · S/N 12-2748 · Cancelled May 20, 1965 · Speeds Flying Service Inc
- [N9925R](https://openairdocs.org/deregistered/N9925R-1964-08-12.md): Beech B95 · S/N TD-382 · Cancelled Aug 12, 1964 · Exported to Switzerland · Cossato Louis D
- [N2910P](https://openairdocs.org/deregistered/N2910P-1964-06-01.md): Piper PA-22S-150 · S/N 22-3178 · Cancelled Jun 1, 1964 · Frank Lantay
- [N69206](https://openairdocs.org/deregistered/N69206-1959-12-23.md): Boeing PT-17 · S/N 75-1665 · Cancelled Dec 23, 1959 · Lokey Charles Martin
- [N270M](https://openairdocs.org/deregistered/N270M-1958-04-08.md): Beech D18S · S/N A-954 · Cancelled Apr 8, 1958 · Exported to Sweden · Transaero Inc
- [N603D](https://openairdocs.org/deregistered/N603D-1958-04-08.md): Beech D18S · S/N A-599 · Cancelled Apr 8, 1958 · Exported to Sweden · Transaero Inc
- [N1269C](https://openairdocs.org/deregistered/N1269C-1957-10-04.md): Piper PA-22-135 · S/N 22-1067 · Cancelled Oct 4, 1957 · Exported to Germany · Speeds Flying Service Inc
- [N16224](https://openairdocs.org/deregistered/N16224-1953-05-12.md): Waco ZQC-6 · S/N 4430 · Cancelled May 12, 1953 · Built 1936 · Speeds Flying Service Inc
- [N21311](https://openairdocs.org/deregistered/N21311-1950-01-26.md): Aeronca 65-LA · S/N L-1168 · Cancelled Jan 26, 1950 · Built 1938 · Heiligmann Alan K / Reilly Bernard J
- [N1208V](https://openairdocs.org/deregistered/N1208V-1949-06-16.md): Boeing E75(N2S-5) · S/N 75-5213 · Cancelled Jun 16, 1949 · Yarnall Edward S

Next page: https://openairdocs.org/faa-place/NY/Flushing/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 = 'FLUSHING'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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