# Cancelled registrations: Bradford, PA

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

Cancelled aircraft registrations in Bradford, PA.

- [N9014D](https://openairdocs.org/deregistered/N9014D-2022-09-24.md): Spear J/Neilly T M AERO TRIKE SAFARI · S/N 146 · Cancelled Sep 24, 2022 · Registration expired, pending cancellation · Neilly Tom M
- [N152MP](https://openairdocs.org/deregistered/N152MP-2011-08-09.md): Mooney M20L · S/N 26-0032 · Cancelled Aug 9, 2011 · Exported to Germany · Lucarelli J L DBA
- [N1XF](https://openairdocs.org/deregistered/N1XF-2010-01-14.md): Piper PA-24-260 · S/N 24-4479 · Cancelled Jan 14, 2010 · Triennial form not returned · Built 1966 · Daggett Robert
- [N173AB](https://openairdocs.org/deregistered/N173AB-2004-07-15.md): Morrow William S SCAMP-A WT-S3 · S/N BM-01 · Cancelled Jul 15, 2004 · Triennial form not returned · Built 1980 · Crisman Edward H
- [N4055S](https://openairdocs.org/deregistered/N4055S-1977-03-04.md): Beech E-55 · S/N TE-1010 · Cancelled Mar 4, 1977 · Zuckerman Marvin Et Al
- [N84677](https://openairdocs.org/deregistered/N84677-1964-05-18.md): Aeronca 7AC · S/N 7AC-3388 · Cancelled May 18, 1964 · Exported to Canada · Stack Frank E
- [N9337K](https://openairdocs.org/deregistered/N9337K-1960-05-06.md): Stinson 108-2 · S/N 108-2337 · Cancelled May 6, 1960 · Exported to Canada · Miller Richard
- [N29256](https://openairdocs.org/deregistered/N29256-1952-03-26.md): Culver LCA · S/N 124 · Cancelled Mar 26, 1952 · Built 1940 · Brown Hebert R
- [N51314](https://openairdocs.org/deregistered/N51314-1952-01-02.md): Fairchild M-62A · S/N T43-7162 · Cancelled Jan 2, 1952 · Diller Louis J
- [N2468E](https://openairdocs.org/deregistered/N2468E-1951-09-07.md): Aeronca 7AC · S/N 7AC-6047 · Cancelled Sep 7, 1951 · Mountain View Flying Service
- [N93748](https://openairdocs.org/deregistered/N93748-1949-06-14.md): Ercoupe 415-C · S/N 1071 · Cancelled Jun 14, 1949 · Built 1946 · Mountain View Flying Service
- [N16840](https://openairdocs.org/deregistered/N16840-1938-09-18.md): Fairchild 24 C8E · S/N 2836 · Cancelled Sep 18, 1938 · Greene Howard H
- [N15080](https://openairdocs.org/deregistered/N15080-1937-01-22.md): Taylor E-2 · S/N 219 · Cancelled Jan 22, 1937 · Taylor Aircraft Co
- [N16605](https://openairdocs.org/deregistered/N16605-1937-01-22.md): Taylor J-2 · S/N 620 · Cancelled Jan 22, 1937 · Taylor Aircraft Co Inc
- [N13868](https://openairdocs.org/deregistered/N13868-1936-09-16.md): Stinson SR-5A · S/N 9242-A · Cancelled Sep 16, 1936 · Built 1934 · Greene H H
- [N3058](https://openairdocs.org/deregistered/N3058-1936-04-03.md): Waco GXE · S/N 773 · Cancelled Apr 3, 1936 · Built 1927 · Beeman Andrew J
- [N14756](https://openairdocs.org/deregistered/N14756-1936-03-13.md): Taylorcraft H-2 · S/N 149 · Cancelled Mar 13, 1936 · Taylor Aircraft Co Inc
- [N2141](https://openairdocs.org/deregistered/N2141-1934-08-26.md): Travel Air 2000 · S/N 8 · Cancelled Aug 26, 1934 · Greene Howard H
- [N5E](https://openairdocs.org/deregistered/N5E-1934-04-30.md): Taylorcraft B-2 · S/N 15 · Cancelled Apr 30, 1934 · Taylorcraft Aircraft Corporation
- [N7303](https://openairdocs.org/deregistered/N7303-1933-01-11.md): Taylor Brothers CHUMMY · S/N 7 · Cancelled Jan 11, 1933 · Taylor Brothers Aircraft Corp
- [N1143](https://openairdocs.org/deregistered/N1143-1930-03-14.md): Curtiss Wright JN4C · S/N 3411 · Cancelled Mar 14, 1930 · Bradford Flying Club
- [N9929](https://openairdocs.org/deregistered/N9929-1929-10-17.md): Travel Air S-6000-B · S/N 1080 · Cancelled Oct 17, 1929 · Emery William H Jr
- [N15078](https://openairdocs.org/deregistered/N15078-undated.md): Piper E-2 · S/N 217 · Cancellation date not recorded · Taylor Aircraft Co

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

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