# Cancelled registrations: Montclair, NJ

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

Cancelled aircraft registrations in Montclair, NJ.

- [N95HB](https://openairdocs.org/deregistered/N95HB-2025-01-23.md): Barr Harry DR 107 · S/N ABJD-32 · Cancelled Jan 23, 2025 · Exported to Lithuania · Built 1998 · Max Aviation LLC
- [N1054S](https://openairdocs.org/deregistered/N1054S-2020-05-01.md): Piper PA-32R-301T · S/N 3257448 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2007 · Faherty Richard L
- [N97285](https://openairdocs.org/deregistered/N97285-2018-12-17.md): Stinson 108 · S/N 108-285 · Cancelled Dec 17, 2018 · Revoked, canceled · Built 1946 · Pinkham Richard E
- [N551TR](https://openairdocs.org/deregistered/N551TR-2018-05-30.md): DJI PHANTOM 2 · S/N PH645149431 · Cancelled May 30, 2018 · Sale reported, canceled
- [N51983](https://openairdocs.org/deregistered/N51983-2018-05-18.md): Piper J3C-65 · S/N 9699 · Cancelled May 18, 2018 · Revoked, canceled · Built 1942 · Teterboro Flying Club Inc
- [N9014N](https://openairdocs.org/deregistered/N9014N-2017-04-13.md): Hughes 269A · S/N 94-0316 · Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1964 · Kurtis Air Inc
- [N80599](https://openairdocs.org/deregistered/N80599-2014-11-19.md): Ewing B-8M · S/N E-1 · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Strenz Robert A
- [N26111](https://openairdocs.org/deregistered/N26111-2013-06-05.md): Hall B-8M · S/N 1913 · Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1976
- [N60236](https://openairdocs.org/deregistered/N60236-2012-08-30.md): Cessna T-50 · S/N 5129 · Cancelled Aug 30, 2012 · Revoked, canceled · Built 1945 · Pinkham Richard E
- [N925JS](https://openairdocs.org/deregistered/N925JS-2004-05-06.md): Diamond Aircraft Ind DA20-A1 · S/N 10280 · Cancelled May 6, 2004 · Exported to Germany · Built 1997 · Jbs Aircraft Leasing Six LLC
- [N1251P](https://openairdocs.org/deregistered/N1251P-1974-05-16.md): Piper PA-23-150 · S/N 23-277 · Cancelled May 16, 1974 · Essex Aviation Co Inc
- [N90091](https://openairdocs.org/deregistered/N90091-1972-11-28.md): Cessna 140 · S/N 9152 · Cancelled Nov 28, 1972 · Lowry Peter B
- [N3015V](https://openairdocs.org/deregistered/N3015V-1956-05-31.md): Beech 35 · S/N D-417 · Cancelled May 31, 1956 · Richard T Bethell
- [N193E](https://openairdocs.org/deregistered/N193E-1939-03-15.md): New Standard D-25 · S/N 102 · Cancelled Mar 15, 1939 · Miller A K
- [N7451](https://openairdocs.org/deregistered/N7451-1939-02-01.md): Eaglerock A-2 · S/N 618 · Cancelled Feb 1, 1939 · A K Miller
- [N868W](https://openairdocs.org/deregistered/N868W-1936-05-01.md): Aeromarine-Klemm L-26-B · S/N 3-82 · Cancelled May 1, 1936 · Miller A K
- [N7283](https://openairdocs.org/deregistered/N7283-1936-02-01.md): Atlantic FOKKER EXPERIMENTAL · S/N 1300 · Cancelled Feb 1, 1936 · Built 1928 · Miller A K
- [N863Y](https://openairdocs.org/deregistered/N863Y-1933-02-08.md): Hageman Edwin POWERED GLIDER · S/N 7 · Cancelled Feb 8, 1933 · Built 1930 · Hageman Edwin
- [N843W](https://openairdocs.org/deregistered/N843W-1933-02-06.md): Joseph Wallace WALLACE W-1 · S/N 131 · Cancelled Feb 6, 1933 · Wallace Joseph
- [N9102](https://openairdocs.org/deregistered/N9102-1930-03-28.md): New Standard D-24 · S/N 112 · Cancelled Mar 28, 1930 · Built 1929 · Aircrafters 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 = 'NJ' AND d.registrant_city = 'MONTCLAIR'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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