# Cancelled registrations: Bedminster, NJ

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

Cancelled aircraft registrations in Bedminster, NJ.

- [N44055](https://openairdocs.org/deregistered/N44055-2021-05-08.md): Piper PA-28-140 · S/N 28-7425386 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1974 · Somerset Air Service Inc
- [N4319F](https://openairdocs.org/deregistered/N4319F-2020-05-01.md): Piper PA-28-140 · S/N 28-7725007 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1976 · Somerset Air Service Inc
- [N360FM](https://openairdocs.org/deregistered/N360FM-2015-05-06.md): Morelli Frank J LANCAIR 360 · S/N 551 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1993 · Morelli Frank J
- [N9516T](https://openairdocs.org/deregistered/N9516T-2013-09-30.md): Cameron Balloons US V-77 · S/N 5646 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1990 · Lyman Jon
- [N6514Z](https://openairdocs.org/deregistered/N6514Z-2013-04-30.md): Piper PA-25-235 · S/N 25-2044 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1962 · Fly For Fun Inc
- [N6139J](https://openairdocs.org/deregistered/N6139J-2013-04-26.md): Piper PA-28-140 · S/N 28-7625222 · Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1976 · Somerset Air Service Inc
- [N6183J](https://openairdocs.org/deregistered/N6183J-2013-04-26.md): Piper PA-28-140 · S/N 28-7625228 · Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1976 · Somerset Air Service Inc
- [N44261](https://openairdocs.org/deregistered/N44261-2012-11-29.md): Piper PA-28-140 · S/N 28-7425398 · Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1974 · Somerset Air Service Inc
- [N43073](https://openairdocs.org/deregistered/N43073-2012-11-26.md): Piper PA-28-140 · S/N 28-7425329 · Cancelled Nov 26, 2012 · Registration expired, pending cancellation · Built 1974 · Somerset Air Service Inc
- [N40396](https://openairdocs.org/deregistered/N40396-2012-11-15.md): Balloon Works FIREFLY 7 · S/N 7832 · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1979 · Harvin Harold Gordon
- [N90393](https://openairdocs.org/deregistered/N90393-1991-04-25.md): Smith AEROSTAR 600 · S/N 600224095 · Cancelled Apr 25, 1991 · Triennial form not returned · Gianchiglia Albert T
- [N9723W](https://openairdocs.org/deregistered/N9723W-1975-05-06.md): Piper PA-28-140 · S/N 28-23201 · Cancelled May 6, 1975 · Somerset Air Service Inc
- [N341JG](https://openairdocs.org/deregistered/N341JG-1975-04-01.md): Ercoupe 415-C · S/N 3532 · Cancelled Apr 1, 1975 · Edward R Emmons
- [N4312P](https://openairdocs.org/deregistered/N4312P-1965-05-20.md): Piper PA-23-160 · S/N 23-1813 · Cancelled May 20, 1965 · Sommerset Air Service Inc
- [N4332C](https://openairdocs.org/deregistered/N4332C-1965-05-20.md): American Champion 7EC · S/N 7EC-343 · Cancelled May 20, 1965 · Somerset Air Service Inc
- [N73012](https://openairdocs.org/deregistered/N73012-1950-09-28.md): Cessna 140 · S/N 10217 · Cancelled Sep 28, 1950 · Somerset Air Service 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 = 'BEDMINSTER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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