# Cancelled registrations: Forest Hills, NY

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

Cancelled aircraft registrations in Forest Hills, NY.

- [N815JL](https://openairdocs.org/deregistered/N815JL-2022-07-30.md): Boeing 747-400 · S/N 29219 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Aero Intelligence Inc Trustee
- [N4624](https://openairdocs.org/deregistered/N4624-2019-12-20.md): Lockheed 1049G · S/N 4617 · Cancelled Dec 20, 2019 · Revoked, canceled · Leasing Consultants Incorporated
- [N508BB](https://openairdocs.org/deregistered/N508BB-2019-06-04.md): Boeing 747-400 · S/N 29031 · Cancelled Jun 4, 2019 · Exported to Antigua and Barbuda · Aero Intelligence Inc Trustee
- [N37045](https://openairdocs.org/deregistered/N37045-2018-03-16.md): Luscombe 8E · S/N 1706 · Cancelled Mar 16, 2018 · Revoked, canceled · Built 1941 · Ames James E
- [N71870](https://openairdocs.org/deregistered/N71870-2017-02-04.md): Luscombe 8A · S/N 3297 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Ames James E
- [N7199C](https://openairdocs.org/deregistered/N7199C-2017-02-04.md): Beech TC-45G · S/N 51-11504 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · Gardner Leo
- [N7208C](https://openairdocs.org/deregistered/N7208C-2017-02-04.md): Beech TC-45G · S/N 51-11569A · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · Gardner Leo
- [N8522R](https://openairdocs.org/deregistered/N8522R-2013-09-30.md): Bellanca 14-19-3 · S/N 4284 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1966 · Sturgeon Keith
- [N715MJ](https://openairdocs.org/deregistered/N715MJ-2013-06-18.md): Cessna 208B · S/N 208B0715 · Cancelled Jun 18, 2013 · Exported to Brazil · Mj Aviation Inc
- [N285SE](https://openairdocs.org/deregistered/N285SE-2012-08-27.md): Douglas DC3A · S/N 2177 · Cancelled Aug 27, 2012 · Sale reported, canceled · Built 1940
- [N341RL](https://openairdocs.org/deregistered/N341RL-2012-02-23.md): Beech C90A · S/N LJ-1287 · Cancelled Feb 23, 2012 · Exported to Brazil · Built 1991 · Mj Aviation Inc
- [N582JB](https://openairdocs.org/deregistered/N582JB-2008-12-19.md): Airbus A320-232 · S/N 2147 · Cancelled Dec 19, 2008 · Exported to Philippines · Built 2003 · Jetblue Airways Corp
- [N290JB](https://openairdocs.org/deregistered/N290JB-2008-11-24.md): Embraer ERJ 190-100 IGW · S/N 19000150 · Cancelled Nov 24, 2008 · Exported to Brazil · Built 2008 · Jetblue Airways Corp
- [N581JB](https://openairdocs.org/deregistered/N581JB-2008-11-24.md): Airbus A320-232 · S/N 2141 · Cancelled Nov 24, 2008 · Exported to Philippines · Built 2003 · Jetblue Airways Corp
- [N548JB](https://openairdocs.org/deregistered/N548JB-2008-11-07.md): Airbus A320-232 · S/N 1868 · Cancelled Nov 7, 2008 · Exported to Portugal · Built 2002 · Jetblue Airways Corp
- [N288JB](https://openairdocs.org/deregistered/N288JB-2008-09-29.md): Embraer ERJ 190-100 IGW · S/N 19000147 · Cancelled Sep 29, 2008 · Exported to Brazil · Built 2008 · Jetblue Airways Corp
- [N553JB](https://openairdocs.org/deregistered/N553JB-2008-05-28.md): Airbus A320-232 · S/N 1896 · Cancelled May 28, 2008 · Exported to Germany · Built 2002 · Jetblue Airways Corp
- [N543JB](https://openairdocs.org/deregistered/N543JB-2008-04-23.md): Airbus A320-232 · S/N 1823 · Cancelled Apr 23, 2008 · Exported to Germany · Built 2002 · Jetblue Airways Corp
- [N61474](https://openairdocs.org/deregistered/N61474-1998-12-28.md): Schweizer SA 2-37A · S/N 0011 · Cancelled Dec 28, 1998 · Registration pending
- [N7588A](https://openairdocs.org/deregistered/N7588A-1983-08-26.md): Boeing 707-123B · S/N 19338 · Cancelled Aug 26, 1983 · Guy America Airways Inc
- [N29310](https://openairdocs.org/deregistered/N29310-1972-05-30.md): Cessna 177 · S/N 17700805 · Cancelled May 30, 1972 · Exported to Iceland · George I Melter
- [N4745A](https://openairdocs.org/deregistered/N4745A-1971-06-08.md): Piper PA-22-150 · S/N 22-3889 · Cancelled Jun 8, 1971 · Harold Borg
- [N6022C](https://openairdocs.org/deregistered/N6022C-1971-01-06.md): Lockheed 749A-79 · S/N 2668 · Cancelled Jan 6, 1971 · Leasing Consultants Inc
- [N3495E](https://openairdocs.org/deregistered/N3495E-1965-10-13.md): Aeronca 7AC · S/N 7AC-6873 · Cancelled Oct 13, 1965 · William L Lawson
- [N88443](https://openairdocs.org/deregistered/N88443-1949-06-14.md): Piper J3C-65 · S/N 16065 · Cancelled Jun 14, 1949 · Engelen Alfred A
- [N159H](https://openairdocs.org/deregistered/N159H-1932-10-25.md): Sikorsky S-38-B · S/N 114-19 · Cancelled Oct 25, 1932 · Hutchinson George Robert
- [N9340](https://openairdocs.org/deregistered/N9340-1931-08-01.md): Arrow Aircraft & Motors ARROW SPORT · S/N 356 · Cancelled Aug 1, 1931 · Vernamae Rylands

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

This list as a web page: https://openairdocs.org/faa-place/NY/Forest%20Hills/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
