# Cancelled registrations: Plainfield, NJ

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

Cancelled aircraft registrations in Plainfield, NJ.

- [N5727X](https://openairdocs.org/deregistered/N5727X-2022-12-03.md): Cessna 320 · S/N 320-0027 · Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1961 · Golden Arrow Transportation Co Inc
- [N73856](https://openairdocs.org/deregistered/N73856-2015-12-12.md): Cessna 172N · S/N 17267724 · Cancelled Dec 12, 2015 · Second renewal notice · Built 1976 · Eisenstein Irving N
- [N1162](https://openairdocs.org/deregistered/N1162-2012-05-10.md): Knight Twister JUNIOR · S/N BB-100 · Cancelled May 10, 2012 · First renewal notice · Built 1968 · Gordon Roger P
- [N79425](https://openairdocs.org/deregistered/N79425-1998-12-16.md): Cessna 172K · S/N 17258076 · Cancelled Dec 16, 1998 · Triennial form not returned · Eisenstein Irving N
- [N29180](https://openairdocs.org/deregistered/N29180-1973-06-11.md): Cessna TU206C · S/N U206-1146 · Cancelled Jun 11, 1973 · Exported to Bolivia · Andes Evangelical Mission
- [N2042U](https://openairdocs.org/deregistered/N2042U-1970-12-17.md): Maule M-4-220C · S/N 2030C · Cancelled Dec 17, 1970 · Andes Evangelical Mission
- [N78210](https://openairdocs.org/deregistered/N78210-1958-07-09.md): Globe GC-1B · S/N 2210 · Cancelled Jul 9, 1958 · Haine Edgar A
- [N80217](https://openairdocs.org/deregistered/N80217-1955-02-02.md): Beech D18S · S/N A-197 · Cancelled Feb 2, 1955 · Exported to Canada · Built 1946 · Rawson Motors Inc
- [N9446E](https://openairdocs.org/deregistered/N9446E-1955-01-06.md): Aeronca 11AC · S/N 11AC-1083 · Cancelled Jan 6, 1955 · Stanley Kloc And Richard P Vaiconis
- [N5805N](https://openairdocs.org/deregistered/N5805N-1953-01-14.md): Consolidated Vultee PBY-5A · S/N 48380 · Cancelled Jan 14, 1953 · Exported to Canada · Rawson Motors Inc
- [N1117V](https://openairdocs.org/deregistered/N1117V-1952-11-05.md): North American SNJ-3 · S/N 78-7064 · Cancelled Nov 5, 1952 · Press Nat
- [N86620](https://openairdocs.org/deregistered/N86620-1951-11-26.md): Grumman G-44A · S/N 1446 · Cancelled Nov 26, 1951 · Exported to Chile · Rawson Motors Inc
- [N4035K](https://openairdocs.org/deregistered/N4035K-1951-04-30.md): North American NAVION · S/N NAV41035 · Cancelled Apr 30, 1951 · Dowser George
- [N18874](https://openairdocs.org/deregistered/N18874-1948-08-10.md): Aeronca K · S/N K-138 · Cancelled Aug 10, 1948 · Plainfield Flying Club
- [N14656](https://openairdocs.org/deregistered/N14656-1948-07-27.md): Aeronca C-3 · S/N A-542 · Cancelled Jul 27, 1948 · Fordham Thomas A
- [N9328](https://openairdocs.org/deregistered/N9328-1936-06-05.md): Arrow Aircraft & Motors ARROW SPORT · S/N 344 · Cancelled Jun 5, 1936 · Tri County Aeronautical Club Inc
- [N870Y](https://openairdocs.org/deregistered/N870Y-1934-09-10.md): Mead Gliders MEAD GLIDER · S/N PA-1 · Cancelled Sep 10, 1934 · Built 1930 · Marinac J G
- [N8136](https://openairdocs.org/deregistered/N8136-1930-06-27.md): Travel Air B-4000 · S/N 897 · Cancelled Jun 27, 1930 · Allen Albert J

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

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