# Cancelled registrations: West Orange, NJ

A list on [West Orange, NJ](https://openairdocs.org/faa-place/NJ/West%20Orange.md).

Cancelled aircraft registrations in West Orange, NJ.

- [N87394](https://openairdocs.org/deregistered/N87394-2018-05-21.md): Engineering & Research ERCOUPE 415-C · S/N 567 · Cancelled May 21, 2018 · Revoked, canceled · Built 1946 · Kraeuter Robert B
- [N90560](https://openairdocs.org/deregistered/N90560-2017-06-21.md): Yakovlev YAK-55 · S/N 870205 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Air Sport Russian Club Inc
- [N9025A](https://openairdocs.org/deregistered/N9025A-2015-05-06.md): Cessna 170B · S/N 18780 · Cancelled May 6, 2015 · Revoked, pending cancellation · Built 1949 · Soltes Richard
- [N5683A](https://openairdocs.org/deregistered/N5683A-2014-10-29.md): Cessna 172 · S/N 28283 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1956 · Lenz Daniel
- [N2102W](https://openairdocs.org/deregistered/N2102W-2012-07-06.md): Beech C23 · S/N M-1429 · Cancelled Jul 6, 2012 · Exported to Canada · Built 1973 · Jnl Aviation LLC
- [N154AA](https://openairdocs.org/deregistered/N154AA-2008-08-29.md): Ul-Airo AIRO 5 · S/N A5-001 · Cancelled Aug 29, 2008 · Exported to Germany · Lala Mahesh L
- [N163AA](https://openairdocs.org/deregistered/N163AA-2008-08-29.md): Ul-Airo AIRO 1 · S/N A004 · Cancelled Aug 29, 2008 · Exported to Germany · Lala Mahesh L
- [N8FH](https://openairdocs.org/deregistered/N8FH-2007-12-20.md): Cessna 310Q · S/N 310Q1035 · Cancelled Dec 20, 2007 · Triennial form not returned · Built 1974 · Holland Frank L
- [N931LW](https://openairdocs.org/deregistered/N931LW-2000-10-24.md): Williams Lester H 532ELITE AIR COMMAND · S/N 1 · Cancelled Oct 24, 2000 · Triennial form not returned · Williams Lester H
- [N221CW](https://openairdocs.org/deregistered/N221CW-1998-08-10.md): Robinson Helicopter R22 BETA · S/N 2060 · Cancelled Aug 10, 1998 · Triennial form not returned · Southport Aircraft Corporation
- [N111DS](https://openairdocs.org/deregistered/N111DS-1973-06-05.md): Cessna 411 · S/N 411-0042 · Cancelled Jun 5, 1973 · Schapira David
- [N4282V](https://openairdocs.org/deregistered/N4282V-1970-09-01.md): Cessna 170 · S/N 18698 · Cancelled Sep 1, 1970 · Soltes Richard
- [N97381](https://openairdocs.org/deregistered/N97381-1968-06-27.md): Stinson 108 · S/N 108-381 · Cancelled Jun 27, 1968 · Exported to Canada · Built 1946 · Kraft George W
- [N59849](https://openairdocs.org/deregistered/N59849-1961-03-28.md): Fairchild 24 C8E · S/N 2837 · Cancelled Mar 28, 1961 · Francis J Quinn Jr
- [N183V](https://openairdocs.org/deregistered/N183V-1934-07-01.md): Cessna CG-2 · S/N 55 · Cancelled Jul 1, 1934 · Langley Aero Club
- [N58279](https://openairdocs.org/deregistered/N58279-undated.md): Cessna T-50 · S/N 5623 · Cancellation date not recorded · Winans Sheldon

## 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 = 'NJ' AND d.registrant_city = 'WEST ORANGE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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