# Cancelled registrations: Jackson Heights, NY

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

Cancelled aircraft registrations in Jackson Heights, NY.

- [N30478](https://openairdocs.org/deregistered/N30478-2019-11-04.md): Piper J3L-65 · S/N 4860 · Cancelled Nov 4, 2019 · Revoked, pending cancellation · Built 1940 · Lamberti George A
- [N916TS](https://openairdocs.org/deregistered/N916TS-2017-03-21.md): Boeing 727-254 · S/N 20437 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc
- [N913TS](https://openairdocs.org/deregistered/N913TS-2017-03-10.md): Boeing 727-254 · S/N 20250 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1969 · Shuttle Inc
- [N919TS](https://openairdocs.org/deregistered/N919TS-2013-07-30.md): Boeing 727-225 · S/N 20447 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc
- [N914TS](https://openairdocs.org/deregistered/N914TS-2013-06-27.md): Boeing 727-254 · S/N 20251 · Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc
- [N918TS](https://openairdocs.org/deregistered/N918TS-2013-05-15.md): Boeing 727-225 · S/N 20445 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc
- [N6513R](https://openairdocs.org/deregistered/N6513R-2013-04-30.md): Beech B19 · S/N MB-725 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1974 · East Coast Aviation Inc
- [N912TS](https://openairdocs.org/deregistered/N912TS-2013-04-09.md): Boeing 727-254 · S/N 20438 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle Inc
- [N902TS](https://openairdocs.org/deregistered/N902TS-1997-06-09.md): Boeing 727-25 · S/N 18267 · Cancelled Jun 9, 1997 · Triennial form not returned · Shuttle Inc
- [N915TS](https://openairdocs.org/deregistered/N915TS-1997-05-13.md): Boeing 727-254 · S/N 20252 · Cancelled May 13, 1997 · Shuttle Inc
- [N901TS](https://openairdocs.org/deregistered/N901TS-1996-02-01.md): Boeing 727-25 · S/N 18257 · Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle Inc
- [N903TS](https://openairdocs.org/deregistered/N903TS-1996-02-01.md): Boeing 727-25 · S/N 18272 · Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle Inc
- [N908TS](https://openairdocs.org/deregistered/N908TS-1996-02-01.md): Boeing 727-214 · S/N 19685 · Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle Inc
- [N911TS](https://openairdocs.org/deregistered/N911TS-1996-02-01.md): Boeing 727-214 · S/N 19689 · Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle Inc
- [N909TS](https://openairdocs.org/deregistered/N909TS-1995-05-23.md): Boeing 727-214 · S/N 19686 · Cancelled May 23, 1995 · Triennial form not returned · Shuttle Inc
- [N8117N](https://openairdocs.org/deregistered/N8117N-1995-05-22.md): Boeing 727-25 · S/N 18268 · Cancelled May 22, 1995 · Triennial form not returned · Shuttle Inc
- [N904TS](https://openairdocs.org/deregistered/N904TS-1994-08-08.md): Boeing 727-25 · S/N 18291 · Cancelled Aug 8, 1994 · Exported to Democratic Republic of the Congo · Shuttle Inc
- [N910TS](https://openairdocs.org/deregistered/N910TS-1993-03-26.md): Boeing 727-214 · S/N 19687 · Cancelled Mar 26, 1993 · Exported to Belgium · Shuttle Inc
- [N7400P](https://openairdocs.org/deregistered/N7400P-1970-06-26.md): Piper PA-24-250 · S/N 24-2584 · Cancelled Jun 26, 1970 · Dot-Well Inc
- [N2597J](https://openairdocs.org/deregistered/N2597J-1968-03-20.md): Cessna 150E · S/N 15061097 · Cancelled Mar 20, 1968 · Exported to Germany · Masin Joseph V
- [N3784S](https://openairdocs.org/deregistered/N3784S-1968-03-20.md): Cessna 172E · S/N 17250984 · Cancelled Mar 20, 1968 · Exported to Germany · Masin Joseph V
- [N5623R](https://openairdocs.org/deregistered/N5623R-1968-03-20.md): Cessna 172F · S/N 17253239 · Cancelled Mar 20, 1968 · Exported to Germany · Built 1965 · Masin Joseph
- [N9226W](https://openairdocs.org/deregistered/N9226W-1967-07-13.md): Piper PA-28-235 · S/N 28-10894 · Cancelled Jul 13, 1967 · Exported to Belgium · Masin Joseph V
- [N7582D](https://openairdocs.org/deregistered/N7582D-1967-03-31.md): Piper PA-18-150 · S/N 18-5878 · Cancelled Mar 31, 1967 · Exported to Germany · Masin Joseph V
- [N3373Z](https://openairdocs.org/deregistered/N3373Z-1967-03-09.md): Piper PA-18-150 · S/N 18-7246 · Cancelled Mar 9, 1967 · Exported to Germany · Masin Joseph V
- [N111C](https://openairdocs.org/deregistered/N111C-1965-06-16.md): Mooney M-18L · S/N 72 · Cancelled Jun 16, 1965 · Dot Will Inc
- [N301B](https://openairdocs.org/deregistered/N301B-1957-11-05.md): Beech G35 · S/N D-4640 · Cancelled Nov 5, 1957 · Danko John F
- [N90C](https://openairdocs.org/deregistered/N90C-1955-08-19.md): Douglas DC3 · S/N 2199 · Cancelled Aug 19, 1955 · Exported to Colombia · American Airlines Inc
- [N9235H](https://openairdocs.org/deregistered/N9235H-1950-04-13.md): Howard DGA-15P · S/N 781 · Cancelled Apr 13, 1950 · Patecell Ted C
- [N9240H](https://openairdocs.org/deregistered/N9240H-1950-04-13.md): Howard DGA-15P · S/N 764 · Cancelled Apr 13, 1950 · Patecell Ted C
- [N16017](https://openairdocs.org/deregistered/N16017-1943-02-23.md): Douglas DC3-G102 · S/N 1555 · Cancelled Feb 23, 1943 · American Airlines Inc
- [N14966](https://openairdocs.org/deregistered/N14966-1941-07-22.md): Douglas DC2 · S/N 1406 · Cancelled Jul 22, 1941 · Built 1935 · American Airlines Inc
- [N14278](https://openairdocs.org/deregistered/N14278-1941-06-05.md): Douglas DC2 · S/N 1311 · Cancelled Jun 5, 1941 · Built 1934 · American Airlines Inc
- [N14279](https://openairdocs.org/deregistered/N14279-1941-06-05.md): Douglas DC2 · S/N 1312 · Cancelled Jun 5, 1941 · American Airlines Inc
- [N14282](https://openairdocs.org/deregistered/N14282-1940-12-11.md): Douglas DC2 · S/N 1315 · Cancelled Dec 11, 1940 · Exported to India · American Airlines Inc
- [N14283](https://openairdocs.org/deregistered/N14283-1940-12-11.md): Douglas DC2 · S/N 1316 · Cancelled Dec 11, 1940 · Exported to United Kingdom · Built 1934 · American Airlines Inc
- [N10175](https://openairdocs.org/deregistered/N10175-1932-05-15.md): Aeronca C-2 · S/N A-51 · Cancelled May 15, 1932 · Hall Roy M
- [N691](https://openairdocs.org/deregistered/N691-1930-02-28.md): George Francis Myers ANNULAR · S/N M A 6 · Cancelled Feb 28, 1930 · George Francie Myers

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

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