# Cancelled registrations: New Brunswick, NJ

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

Cancelled aircraft registrations in New Brunswick, NJ.

- [N683EN](https://openairdocs.org/deregistered/N683EN-2019-11-04.md): DJI INSPIRE 1 · S/N W13DCD06030451 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · New Brunswick Development Corp
- [N769TR](https://openairdocs.org/deregistered/N769TR-2019-11-04.md): DJI PHANTOM 2 · S/N PH646085119 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgers The State University Of New Jersey
- [N769VS](https://openairdocs.org/deregistered/N769VS-2019-11-04.md): DJI S1000+ · S/N 03P0015107 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgersthe State University Of New Jersey
- [N769ZU](https://openairdocs.org/deregistered/N769ZU-2019-11-04.md): DJI PHANTOM 4 · S/N 07DDD460A10636 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgers The State University Of New Jersey
- [N176RV](https://openairdocs.org/deregistered/N176RV-2019-05-04.md): DJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF26016200 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Vanecek Robert J
- [N578NR](https://openairdocs.org/deregistered/N578NR-2018-12-11.md): Steadidrone PTY QU4D X · S/N SDMAPQU4DX004 · Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Rutgers The State University Of New Jersey
- [N93965](https://openairdocs.org/deregistered/N93965-2017-07-12.md): Ercoupe 415-C · S/N 1288 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1946 · Jinotti Walter J
- [N70748](https://openairdocs.org/deregistered/N70748-2013-05-03.md): Piper J3C-65 · S/N 17765 · Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Hadley Aircraft Inc
- [N42872](https://openairdocs.org/deregistered/N42872-2012-09-17.md): Piper J3C-65 · S/N 15203 · Cancelled Sep 17, 2012 · Revoked, canceled · Built 1945 · Hadley Arcft Inc
- [N4268Q](https://openairdocs.org/deregistered/N4268Q-1982-07-20.md): Cessna 172L · S/N 17260168 · Cancelled Jul 20, 1982 · Exported to Canada · Built 1971 · Moore Dennis
- [N322EG](https://openairdocs.org/deregistered/N322EG-1970-06-29.md): Navion NAVION A · S/N NAV41953 · Cancelled Jun 29, 1970 · Built 1949 · Nierenberg Richard Et Al
- [N37500](https://openairdocs.org/deregistered/N37500-1963-11-05.md): Lockheed 18 · S/N 2251 · Cancelled Nov 5, 1963 · Built 1942 · Johnson And Johnson
- [N97804](https://openairdocs.org/deregistered/N97804-1959-10-23.md): Stinson 108-1 · S/N 108-804 · Cancelled Oct 23, 1959 · Walter Gingrich
- [N58499](https://openairdocs.org/deregistered/N58499-1956-02-14.md): Taylorcraft DCO-65 · S/N L-5658 · Cancelled Feb 14, 1956 · Gianchiglia Louis & Henry Hansen
- [N23398](https://openairdocs.org/deregistered/N23398-1955-10-06.md): Piper J3L · S/N 3132 · Cancelled Oct 6, 1955 · Built 1939 · Smith Robert Henry
- [N2191E](https://openairdocs.org/deregistered/N2191E-1953-01-27.md): Aeronca 7AC · S/N 7AC-5765 · Cancelled Jan 27, 1953 · Ondre Michael G
- [N80332](https://openairdocs.org/deregistered/N80332-1952-11-07.md): Beech D18S · S/N A-242 · Cancelled Nov 7, 1952 · Exported to Canada · Triangle Conduit & Cable Co Inc
- [N716Y](https://openairdocs.org/deregistered/N716Y-1950-08-31.md): New Standard D-29A · S/N 1034 · Cancelled Aug 31, 1950 · Built 1931 · Brittingham Nathaniel 3rd
- [N19839](https://openairdocs.org/deregistered/N19839-1948-05-07.md): Taylorcraft A · S/N 344 · Cancelled May 7, 1948 · Built 1937 · Meltz Robert E DBA Meltz Aircraft Co
- [N28K](https://openairdocs.org/deregistered/N28K-1948-04-29.md): New Standard D-25 · S/N 147 · Cancelled Apr 29, 1948 · Sold
- [N51754](https://openairdocs.org/deregistered/N51754-1947-10-16.md): Fairchild M-62A · S/N T40-157 · Cancelled Oct 16, 1947 · Aeromotive Corp Of Nj Inc
- [N18956](https://openairdocs.org/deregistered/N18956-1944-04-20.md): Lockheed 12A · S/N 1244 · Cancelled Apr 20, 1944 · Built 1937 · Johnson And Johnson
- [N15737](https://openairdocs.org/deregistered/N15737-1938-04-15.md): Aeronca C-3 · S/N A-636 · Cancelled Apr 15, 1938 · Unger Aircraft Inc
- [N42K](https://openairdocs.org/deregistered/N42K-1935-08-01.md): Bird A · S/N 1072 · Cancelled Aug 1, 1935 · Fisher Fredrick G Jr
- [N217H](https://openairdocs.org/deregistered/N217H-1930-09-09.md): US Aircraft Corp Of NJ SP-7 · S/N 4 · Cancelled Sep 9, 1930 · United States Aircraft Co Of New Jersey
- [N601H](https://openairdocs.org/deregistered/N601H-1930-06-27.md): Travel Air B-4000 · S/N 1168 · Cancelled Jun 27, 1930 · Unger Aircraft Inc
- [N9837](https://openairdocs.org/deregistered/N9837-1930-05-28.md): Travel Air B-4000 · S/N 1061 · Cancelled May 28, 1930 · Runyon Walter P Jr
- [N468N](https://openairdocs.org/deregistered/N468N-1930-01-31.md): Travel Air B-4000 · S/N 1369 · Cancelled Jan 31, 1930 · Allen Albert J
- [N1242](https://openairdocs.org/deregistered/N1242-1929-03-01.md): Waco 9 · S/N 263 · Cancelled Mar 1, 1929 · Built 1927 · Reynolds Airways 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 = 'NEW BRUNSWICK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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