# Cancelled registrations: Lindenhurst, NY

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

Cancelled aircraft registrations in Lindenhurst, NY.

- [N3036X](https://openairdocs.org/deregistered/N3036X-2024-05-04.md): Cessna 150F · S/N 15064436 · Cancelled May 4, 2024 · Revoked, canceled · Built 1966 · Belrose Jorden
- [N10VG](https://openairdocs.org/deregistered/N10VG-2022-11-05.md): Gates Lear Jet 25B · S/N 125 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1973 · N10vg LLC
- [N847LL](https://openairdocs.org/deregistered/N847LL-2021-10-02.md): Blade 250 CFX · S/N 0548262815 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Legerlotz Brian R
- [N851ML](https://openairdocs.org/deregistered/N851ML-2021-10-02.md): Horizon Hobby BLADE 330X · S/N 0548212881 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Legerlotz Brian R
- [N4201P](https://openairdocs.org/deregistered/N4201P-2019-11-25.md): Piper PA-23-160 · S/N 23-1690 · Cancelled Nov 25, 2019 · Revoked, pending cancellation · Built 1959 · Cook Hobart A Associated
- [N52080](https://openairdocs.org/deregistered/N52080-2018-09-07.md): Consolidated Vultee BT-13A · S/N 5515 · Cancelled Sep 7, 2018 · Revoked, canceled · Built 1942 · Beute Walter
- [N85390](https://openairdocs.org/deregistered/N85390-2018-05-21.md): Aeronca 7AC · S/N 7AC4130 · Cancelled May 21, 2018 · Revoked, canceled · Built 1947 · Castelli Sebastian
- [N3996A](https://openairdocs.org/deregistered/N3996A-2018-04-05.md): Para-Copter M7LPC · S/N 107 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1956 · Para Copter Inc
- [N3997A](https://openairdocs.org/deregistered/N3997A-2018-04-05.md): Para-Gyro HYDRO-COPTER · S/N 77PGHC · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1956 · Para Copter Inc
- [N3998A](https://openairdocs.org/deregistered/N3998A-2018-04-05.md): Para-Gyro FLYING BOAT · S/N 26PGFB · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1956 · Para Gyro Inc
- [N404GJ](https://openairdocs.org/deregistered/N404GJ-2018-01-18.md): British Aerospace BAE JETSTREAM 3101 · S/N 754 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1987 · Northeast Air And Sea Services LLC
- [N186Y](https://openairdocs.org/deregistered/N186Y-2015-01-15.md): Cessna 182J · S/N 18257021 · Cancelled Jan 15, 2015 · Exported to Russia · Built 1966 · Laboratory Flying Club Inc
- [N3154G](https://openairdocs.org/deregistered/N3154G-2014-12-22.md): North American T-28A · S/N 491581 · Cancelled Dec 22, 2014 · Revoked, canceled · Built 1959 · Unique Screw Machine Corp
- [N19394](https://openairdocs.org/deregistered/N19394-2014-09-10.md): Cessna 150L · S/N 15074389 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1973 · Heavy Metal Air LLC
- [N1249Y](https://openairdocs.org/deregistered/N1249Y-2013-04-10.md): Cessna 150B · S/N 15059649 · Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1962 · Zullo Thomas L
- [N36509](https://openairdocs.org/deregistered/N36509-1992-05-18.md): Piper PA-28-161 · S/N 287816643 · Cancelled May 18, 1992 · Triennial form not returned · Demaria Frank J
- [N3642J](https://openairdocs.org/deregistered/N3642J-1972-03-30.md): Cessna 150G · S/N 15064942 · Cancelled Mar 30, 1972 · Built 1966 · Piazza Joseph C/Hollender Charles K
- [N97875](https://openairdocs.org/deregistered/N97875-1957-06-14.md): Stinson 108-1 · S/N 108-875 · Cancelled Jun 14, 1957 · Exported to Germany · Aircraftsmen Inc
- [N8363A](https://openairdocs.org/deregistered/N8363A-1957-05-28.md): Cessna 170B · S/N 25215 · Cancelled May 28, 1957 · Exported to Germany · Marino John & Pardocchi Alfred
- [N6656A](https://openairdocs.org/deregistered/N6656A-1957-05-20.md): Cessna 172 · S/N 28756 · Cancelled May 20, 1957 · Exported to Germany · Aircraftsmen Inc
- [N1440N](https://openairdocs.org/deregistered/N1440N-1953-03-09.md): Piper J3C-65 · S/N 22968 · Cancelled Mar 9, 1953 · Built 1947 · Lyons Flying Service Inc

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

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