# Cancelled registrations: Bloomfield, NJ

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

Cancelled aircraft registrations in Bloomfield, NJ.

- [N1031E](https://openairdocs.org/deregistered/N1031E-2014-09-08.md): Clauser Richard L SCHREDER HP-18 · S/N 87 · Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Kelly Richard J
- [N5713W](https://openairdocs.org/deregistered/N5713W-2013-04-23.md): Raven Industries W100LB · S/N W100LB-101 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1979 · Viacom Inc
- [N19088](https://openairdocs.org/deregistered/N19088-1983-08-02.md): Cessna 150L · S/N 15074159 · Cancelled Aug 2, 1983 · Administratively canceled · Costello Robert
- [N7470W](https://openairdocs.org/deregistered/N7470W-1975-05-09.md): Piper PA-28-180 · S/N 28-1373 · Cancelled May 9, 1975 · Hirsch Edwin P
- [N5779](https://openairdocs.org/deregistered/N5779-1974-08-29.md): Bensen B-8M · S/N 2170555 · Cancelled Aug 29, 1974 · Garner Robert W
- [N666K](https://openairdocs.org/deregistered/N666K-1964-09-29.md): Ryan Aeronautical ST3KR · S/N 1486 · Cancelled Sep 29, 1964 · Sturtevant John Charles
- [N3813N](https://openairdocs.org/deregistered/N3813N-1963-02-28.md): Beech 35 · S/N D1042 · Cancelled Feb 28, 1963 · Allan Air Inc
- [N2101N](https://openairdocs.org/deregistered/N2101N-1962-03-14.md): Cessna 140 · S/N 12337 · Cancelled Mar 14, 1962 · Built 1947 · Essex County Voc & Tech High School
- [N46003](https://openairdocs.org/deregistered/N46003-1961-03-28.md): Aeronca 0-58B · S/N 5342 · Cancelled Mar 28, 1961 · Wessex Wings Inc
- [N46327](https://openairdocs.org/deregistered/N46327-1957-10-07.md): Piper J3C-65 · S/N G-201 · Cancelled Oct 7, 1957 · Exported to Canada · Niosi Nicholas
- [N72073](https://openairdocs.org/deregistered/N72073-1956-11-07.md): Luscombe 8A · S/N 3500 · Cancelled Nov 7, 1956 · Harry Spaeth
- [N1046E](https://openairdocs.org/deregistered/N1046E-1955-10-18.md): Aeronca 7AC · S/N 7AC-4597 · Cancelled Oct 18, 1955 · Dieterle George
- [N1533V](https://openairdocs.org/deregistered/N1533V-1955-10-05.md): Aeronca 0-58B · S/N 058B11803 · Cancelled Oct 5, 1955 · Maglio Albert D
- [N49913](https://openairdocs.org/deregistered/N49913-1953-11-03.md): Laister-Kauffman LK-10A · S/N 119 · Cancelled Nov 3, 1953 · Orban Stephen George
- [N36785](https://openairdocs.org/deregistered/N36785-1948-09-14.md): Stinson 10A · S/N 8085 · Cancelled Sep 14, 1948 · Built 1941 · Geyer William H
- [N34505](https://openairdocs.org/deregistered/N34505-1948-08-16.md): Aeronca 65-CA · S/N CA15171 · Cancelled Aug 16, 1948 · Built 1941 · Otto Aviation Corp
- [N25931](https://openairdocs.org/deregistered/N25931-1948-07-15.md): Piper J3F-60 · S/N 3879 · Cancelled Jul 15, 1948 · Dutcher Murray C
- [N105E](https://openairdocs.org/deregistered/N105E-1948-01-29.md): Curtiss-Robertson ROBIN · S/N 59 · Cancelled Jan 29, 1948 · John E Reinhardt & Thomas W Diecks
- [N46153](https://openairdocs.org/deregistered/N46153-undated.md): Aeronca 65-TAC · S/N F-4242TA · Cancellation date not recorded · Built 1942 · Otto Aviation Corp

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

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