# Cancelled registrations: Red Bank, NJ

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

Cancelled aircraft registrations in Red Bank, NJ.

- [N226GC](https://openairdocs.org/deregistered/N226GC-2018-03-13.md): Boeing 737-217 · S/N 22659 · Cancelled Mar 13, 2018 · Registration expired, pending cancellation · G Capital Investments LLC
- [N41692](https://openairdocs.org/deregistered/N41692-1997-03-05.md): Bellanca 7GCBC · S/N 59273 · Cancelled Mar 5, 1997 · Triennial form not returned · Gotthardt William H
- [N3437](https://openairdocs.org/deregistered/N3437-1979-04-23.md): Beech 3NM · S/N CA-184 · Cancelled Apr 23, 1979 · Exported to Chile · Joel Ribler
- [N6595L](https://openairdocs.org/deregistered/N6595L-1974-08-15.md): Piper PA-31-310 · S/N 31523 · Cancelled Aug 15, 1974 · Exported to Italy · Rowan Industries Inc
- [N19273](https://openairdocs.org/deregistered/N19273-1972-08-09.md): Piper PA-23-250 · S/N 27-3289 · Cancelled Aug 9, 1972 · Mcclees Peter J
- [N4652P](https://openairdocs.org/deregistered/N4652P-1970-06-23.md): Piper PA-23-250 · S/N 27-175 · Cancelled Jun 23, 1970 · Red Bank Airport Inc
- [N8846B](https://openairdocs.org/deregistered/N8846B-1967-11-20.md): Cessna 172 · S/N 36546 · Cancelled Nov 20, 1967 · Red Bank Arpt Inc
- [N2151D](https://openairdocs.org/deregistered/N2151D-1965-05-21.md): Beech D35 · S/N D-3501 · Cancelled May 21, 1965 · Air Taxi Co
- [N2995V](https://openairdocs.org/deregistered/N2995V-1961-04-18.md): Beech 35 · S/N D-393 · Cancelled Apr 18, 1961 · Air Taxi Company
- [N690B](https://openairdocs.org/deregistered/N690B-1961-03-30.md): Beech A35 · S/N D-1693 · Cancelled Mar 30, 1961 · Air Taxi Co
- [N5215P](https://openairdocs.org/deregistered/N5215P-1959-02-17.md): Piper PA-24 · S/N 24-241 · Cancelled Feb 17, 1959 · Exported to Germany · Red Bank Airport Inc
- [N87561](https://openairdocs.org/deregistered/N87561-1955-06-20.md): Republic RC-3 · S/N 123 · Cancelled Jun 20, 1955 · Exported to Canada · Red Bank Airport Inc
- [N3222B](https://openairdocs.org/deregistered/N3222B-1955-01-18.md): Piper PA-22-135 · S/N 22-2050 · Cancelled Jan 18, 1955 · Exported to Kenya · Red Bank Arpt Inc
- [N8252K](https://openairdocs.org/deregistered/N8252K-1954-05-13.md): Stinson 108-1 · S/N 108-1252 · Cancelled May 13, 1954 · Hiltner Edward B
- [N1333C](https://openairdocs.org/deregistered/N1333C-1954-02-01.md): Piper PA-22-135 · S/N 22-1125 · Cancelled Feb 1, 1954 · Exported to Japan · Red Bank Arpt Inc
- [N32043](https://openairdocs.org/deregistered/N32043-1949-08-22.md): Waco UPF-7 · S/N 5674 · Cancelled Aug 22, 1949 · Built 1941 · Red Bank Airport Inc
- [N40149](https://openairdocs.org/deregistered/N40149-1949-08-22.md): Stinson 108 · S/N 108-79 · Cancelled Aug 22, 1949 · Red Bank Airport Inc
- [N69592](https://openairdocs.org/deregistered/N69592-1949-08-22.md): Cessna T-50 · S/N 1186 · Cancelled Aug 22, 1949 · Built 1941 · Red Bank Airport Inc
- [N92448](https://openairdocs.org/deregistered/N92448-1949-04-22.md): Piper J3C-65 · S/N 16916 · Cancelled Apr 22, 1949 · Red Bank Airport Inc
- [N14704](https://openairdocs.org/deregistered/N14704-1939-10-01.md): Mead Gliders MEAD GLIDER · S/N 525 · Cancelled Oct 1, 1939 · Red Bank
- [N932V](https://openairdocs.org/deregistered/N932V-1939-04-15.md): Phillips Robert J PHILLIPS · S/N 90V473 · Cancelled Apr 15, 1939 · Phillips Robert J
- [N863N](https://openairdocs.org/deregistered/N863N-1934-06-24.md): Bellanca CH300 PACEMAKER · S/N 186 · Cancelled Jun 24, 1934 · Aerial Explorations 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 = 'RED BANK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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