# Cancelled registrations: Hackettstown, NJ

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

Cancelled aircraft registrations in Hackettstown, NJ.

- [N431PS](https://openairdocs.org/deregistered/N431PS-2017-10-26.md): Fouga CM 170 MAGISTER · S/N 431 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Red Star Aviation Museum
- [N6057Y](https://openairdocs.org/deregistered/N6057Y-2014-12-03.md): Eagle Balloons C-7 · S/N E83744 · Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1983 · Dilillo John A
- [N2133Q](https://openairdocs.org/deregistered/N2133Q-2014-09-16.md): Cessna 177RG · S/N 177RG0533 · Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1974 · Conde James O
- [N1257U](https://openairdocs.org/deregistered/N1257U-2014-09-03.md): Cessna 172M · S/N 17266952 · Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1976 · Schwanda Donald
- [N6429H](https://openairdocs.org/deregistered/N6429H-2014-04-15.md): Piper J3C-65 · S/N 19612 · Cancelled Apr 15, 2014 · Exported to New Zealand · Built 1946 · Hunt Robert T
- [N9915Q](https://openairdocs.org/deregistered/N9915Q-2013-10-28.md): Saville Thomas A SAVILLE HUMMER-A · S/N 0078A · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Saville Thomas A
- [N68020](https://openairdocs.org/deregistered/N68020-2013-10-23.md): Dimaria BD-4D · S/N 430 · Cancelled Oct 23, 2013 · Revoked, canceled · Built 1970 · Dimaria Ralph A
- [N511EB](https://openairdocs.org/deregistered/N511EB-2013-04-18.md): Cessna 150L · S/N 15073391 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1972 · Brady Eleanor
- [N502AG](https://openairdocs.org/deregistered/N502AG-2013-04-01.md): Construcciones Aeronauticas C.A.S.A. 1.131E · S/N E3B-502 · Cancelled Apr 1, 2013 · Sale reported, canceled
- [N835HW](https://openairdocs.org/deregistered/N835HW-2010-12-15.md): Dehavilland DH115 VAMPIRE · S/N 973 · Cancelled Dec 15, 2010 · Exported to Canada · Built 1958 · Red Star Aviation Museum Inc
- [N71AA](https://openairdocs.org/deregistered/N71AA-2008-04-28.md): Cessna 210K · S/N 21059359 · Cancelled Apr 28, 2008 · Exported to Venezuela · Built 1976 · Rodriguez Arsenio
- [N43744](https://openairdocs.org/deregistered/N43744-1995-03-01.md): Piper PA-28-161 · S/N 287816018 · Cancelled Mar 1, 1995 · Triennial form not returned · Bond Aviation Inc
- [N65BB](https://openairdocs.org/deregistered/N65BB-1980-09-03.md): Cameron Balloons O-84 · S/N 174 · Cancelled Sep 3, 1980 · Exported to Sweden · M&M/Mars Inc
- [N1340B](https://openairdocs.org/deregistered/N1340B-1971-08-13.md): Luscombe 8A · S/N 5967 · Cancelled Aug 13, 1971 · Schroeder Hans J
- [N6895H](https://openairdocs.org/deregistered/N6895H-1960-01-29.md): Piper J3C-65 · S/N 20123 · Cancelled Jan 29, 1960 · Built 1946 · Bartholomew Howard R
- [N73519](https://openairdocs.org/deregistered/N73519-1956-03-16.md): Cessna T-50 · S/N 3537 · Cancelled Mar 16, 1956 · Baker Harold
- [N13852](https://openairdocs.org/deregistered/N13852-1955-10-19.md): Stinson SR-5E · S/N 9228A · Cancelled Oct 19, 1955 · Built 1934 · Gordon Harry
- [N44V](https://openairdocs.org/deregistered/N44V-1948-04-06.md): Granville Brothers GEE BEE A · S/N P-7 · Cancelled Apr 6, 1948 · Built 1930 · Hackettstown Flyers 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 = 'HACKETTSTOWN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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