# Cancelled registrations: New Castle, PA

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

Cancelled aircraft registrations in New Castle, PA.

- [N8972A](https://openairdocs.org/deregistered/N8972A-2022-02-05.md): Beech C35 · S/N D-2726 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Gregal Michael J
- [N15JT](https://openairdocs.org/deregistered/N15JT-2013-06-14.md): Cessna 150L · S/N 15072074 · Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1970
- [N31070](https://openairdocs.org/deregistered/N31070-2013-02-07.md): Piper J3L-65 · S/N 5296 · Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1940 · Bucker John B
- [N22856](https://openairdocs.org/deregistered/N22856-2011-08-08.md): Cessna 150H · S/N 15068565 · Cancelled Aug 8, 2011 · Sale reported, pending cancellation · Built 1968
- [N2777V](https://openairdocs.org/deregistered/N2777V-2009-07-20.md): Beech D50E · S/N DH-305 · Cancelled Jul 20, 2009 · Registration revoked · Built 1960 · Castle Aviation Co
- [N6044U](https://openairdocs.org/deregistered/N6044U-2007-08-25.md): Cameron Balloons US V-77 · S/N 5495 · Cancelled Aug 25, 2007 · Triennial form not returned · Built 1989 · Lta Unlimited
- [N3090J](https://openairdocs.org/deregistered/N3090J-2004-11-24.md): Cessna 150E · S/N 15061190 · Cancelled Nov 24, 2004 · Sale reported · Built 1965
- [N5994X](https://openairdocs.org/deregistered/N5994X-1999-08-24.md): Brantly B-2 · S/N 139 · Cancelled Aug 24, 1999 · Exported to Canada · Built 1961 · Stiles William H
- [N1470T](https://openairdocs.org/deregistered/N1470T-1999-04-14.md): Piper PA-28-140 · S/N 28-7225527 · Cancelled Apr 14, 1999 · Haski Aviation Of Pennsylvania Inc
- [N201MA](https://openairdocs.org/deregistered/N201MA-1992-10-30.md): Piper PA-28-140 · S/N 2826771 · Cancelled Oct 30, 1992 · Thompson Gregory A
- [N2749U](https://openairdocs.org/deregistered/N2749U-1971-11-23.md): Cessna 172D · S/N 172-50349 · Cancelled Nov 23, 1971 · Built 1963 · Castle Aviation Co Inc
- [N3643Q](https://openairdocs.org/deregistered/N3643Q-1970-09-04.md): Beech A23-19 · S/N MB-263 · Cancelled Sep 4, 1970 · Castle Flying Club Inc
- [N1279V](https://openairdocs.org/deregistered/N1279V-1965-05-18.md): Klockner K-2 · S/N 101 · Cancelled May 18, 1965 · Herman Richard Klockner
- [N6708M](https://openairdocs.org/deregistered/N6708M-1957-07-11.md): Stinson 108-3 · S/N 108-4708 · Cancelled Jul 11, 1957 · Castle Flying Club Inc
- [N38019](https://openairdocs.org/deregistered/N38019-1956-03-02.md): Piper J4E · S/N 4-1526 · Cancelled Mar 2, 1956 · Built 1941 · Kent Don L
- [N85481](https://openairdocs.org/deregistered/N85481-1956-02-23.md): Aeronca 7AC · S/N 7AC-4221 · Cancelled Feb 23, 1956 · Wilson Findley C DBA Wilson Aviation Co
- [N69903](https://openairdocs.org/deregistered/N69903-1956-02-20.md): Consolidated Vultee SNV-1 · S/N 10019 · Cancelled Feb 20, 1956 · Lundy Arthur
- [N47102](https://openairdocs.org/deregistered/N47102-1955-11-18.md): Fairchild M-62A · S/N T42-1487 · Cancelled Nov 18, 1955 · Hoover James L
- [N46130](https://openairdocs.org/deregistered/N46130-1955-11-17.md): Taylorcraft DC-65 · S/N 5114 · Cancelled Nov 17, 1955 · Farone Frank J
- [N51938](https://openairdocs.org/deregistered/N51938-1955-10-13.md): Fairchild M-62C · S/N T42-1684 · Cancelled Oct 13, 1955 · Built 1942 · Alexander George E
- [N46495](https://openairdocs.org/deregistered/N46495-1955-10-12.md): Fairchild M-62A · S/N T42-3381 · Cancelled Oct 12, 1955 · Built 1942 · Malizia Frank
- [N32330](https://openairdocs.org/deregistered/N32330-1955-10-07.md): Porterfield LP-65 · S/N 788 · Cancelled Oct 7, 1955 · Built 1940 · Broschart Joseph Francis
- [N46423](https://openairdocs.org/deregistered/N46423-1955-08-03.md): Fairchild M-62A · S/N T43-5451 · Cancelled Aug 3, 1955 · Built 1943 · Cameron Gerald W
- [N21980](https://openairdocs.org/deregistered/N21980-1955-03-18.md): Northwestern PORTERFIELD CP-50 · S/N 563 · Cancelled Mar 18, 1955 · Shaffer Richard A
- [N47065](https://openairdocs.org/deregistered/N47065-1954-05-24.md): Fairchild M-62A · S/N T43-5997 · Cancelled May 24, 1954 · Penn Aero Service Inc
- [N2010E](https://openairdocs.org/deregistered/N2010E-1952-02-19.md): Aeronca 7AC · S/N 7AC-5580 · Cancelled Feb 19, 1952 · Wilson Findley C DBA Wilson Aviation Co
- [N8661K](https://openairdocs.org/deregistered/N8661K-1951-09-07.md): Stinson 108-1 · S/N 108-1661 · Cancelled Sep 7, 1951 · Hawk Roger
- [N946V](https://openairdocs.org/deregistered/N946V-1950-02-20.md): Bird BK · S/N 2016-68 · Cancelled Feb 20, 1950 · Built 1931 · Walter Karl G.
- [N2012E](https://openairdocs.org/deregistered/N2012E-1949-09-09.md): Aeronca 7AC · S/N 7AC-5582 · Cancelled Sep 9, 1949 · Wilson Findley C DBA Wilson Aviation Co
- [N96804](https://openairdocs.org/deregistered/N96804-1949-06-23.md): Taylorcraft BC12-D · S/N 9104 · Cancelled Jun 23, 1949 · Wilson Aviation Co
- [N51918](https://openairdocs.org/deregistered/N51918-1949-02-10.md): Fairchild M-62A · S/N T41-1247 · Cancelled Feb 10, 1949 · Built 1945 · Wilson Maxine DBA Wilson Aviation
- [N22288](https://openairdocs.org/deregistered/N22288-1948-06-08.md): Taylorcraft BL · S/N 1238 · Cancelled Jun 8, 1948 · Morgan Warren E & Grant H Brundage
- [N95K](https://openairdocs.org/deregistered/N95K-1940-10-01.md): Waco GXE · S/N 769 · Cancelled Oct 1, 1940 · Built 1927 · Love Robert Greer
- [N2684](https://openairdocs.org/deregistered/N2684-1938-12-15.md): Gilkey SPORT · S/N 1 · Cancelled Dec 15, 1938 · Gilkey Lynn W
- [N5217](https://openairdocs.org/deregistered/N5217-1930-09-17.md): Ryan B1 · S/N 105 · Cancelled Sep 17, 1930 · New Castle Aircraft Inc
- [N3856](https://openairdocs.org/deregistered/N3856-1929-04-19.md): Travel Air Mfg 2000 · S/N 318 · Cancelled Apr 19, 1929 · New Castle Aircraft 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 = 'PA' AND d.registrant_city = 'NEW CASTLE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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