# Cancelled registrations: Ambler, PA

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

Cancelled aircraft registrations in Ambler, PA.

- [N432CP](https://openairdocs.org/deregistered/N432CP-2023-10-03.md): Cirrus Design SR22 · S/N 3254 · Cancelled Oct 3, 2023 · Built 2008 · Mueller Harold P III
- [N5166S](https://openairdocs.org/deregistered/N5166S-2023-03-10.md): Piper PA-28-180 · S/N 28-7105020 · Cancelled Mar 10, 2023 · Registration expired, pending cancellation · Built 1970 · Patel J C
- [N5942X](https://openairdocs.org/deregistered/N5942X-2019-12-10.md): Brantly B-2 · S/N 80 · Cancelled Dec 10, 2019 · Revoked, pending cancellation · Built 1961 · Kite Helicopter Corp
- [N591LE](https://openairdocs.org/deregistered/N591LE-2019-05-01.md): Robinson Helicopter R22 · S/N 2591 · Cancelled May 1, 2019 · Registration expired, pending cancellation · Built 1996 · Breitenbach Kristine C
- [N6VT](https://openairdocs.org/deregistered/N6VT-2017-07-12.md): Beech A23A · S/N M-980 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1966 · Frick Robert E
- [N1014J](https://openairdocs.org/deregistered/N1014J-2017-02-04.md): Aero Commander 112 · S/N 14 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Commonwealth Aviation Distributors I
- [N75286](https://openairdocs.org/deregistered/N75286-2013-05-08.md): Piper PA-28-140 · S/N 28-7625211 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · Turner Field Inc
- [N2499D](https://openairdocs.org/deregistered/N2499D-1982-11-16.md): Piper PA-38-112 · S/N 38-79A0335 · Cancelled Nov 16, 1982 · Built 1978 · Turner Field Inc
- [N526M](https://openairdocs.org/deregistered/N526M-1966-02-11.md): Beech D35 · S/N D-3527 · Cancelled Feb 11, 1966 · Krebs Richard E
- [N5966X](https://openairdocs.org/deregistered/N5966X-1962-12-14.md): Brantly B-2 · S/N 108 · Cancelled Dec 14, 1962 · Exported to Canada · Kite Helicopter Corp
- [N6793D](https://openairdocs.org/deregistered/N6793D-1961-04-20.md): Brantly B-2 · S/N 17 · Cancelled Apr 20, 1961 · Exported to Canada · Kite Helicopter Corp
- [N2181D](https://openairdocs.org/deregistered/N2181D-1954-03-01.md): Beech D35 · S/N D-3528 · Cancelled Mar 1, 1954 · Wings Inc
- [N91553](https://openairdocs.org/deregistered/N91553-1952-08-28.md): North American NAVION A · S/N NAV-4-329 · Cancelled Aug 28, 1952 · Exported to Canada · Wings Inc
- [N32769](https://openairdocs.org/deregistered/N32769-1947-01-17.md): Piper J-3 · S/N 5604 · Cancelled Jan 17, 1947 · Wings Fields Inc
- [N2273](https://openairdocs.org/deregistered/N2273-1940-06-20.md): Waco AVN-8 · S/N 5104 · Cancelled Jun 20, 1940 · Built 1938 · Wings Field Inc
- [N76934](https://openairdocs.org/deregistered/N76934-undated.md): Cessna 140 · S/N 11376 · Cancellation date not recorded · Built 1946 · Little Corp

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

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