# Cancelled registrations: Bedford, PA

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

Cancelled aircraft registrations in Bedford, PA.

- [N303LD](https://openairdocs.org/deregistered/N303LD-2018-07-06.md): Beech F33A · S/N CE-1462 · Cancelled Jul 6, 2018 · Exported to Canada · Built 1990 · Bullitt Air LLC
- [N7372V](https://openairdocs.org/deregistered/N7372V-2018-01-08.md): Bellanca 17-30 · S/N 30226 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1969 · Moreland William L
- [N88323](https://openairdocs.org/deregistered/N88323-2017-06-07.md): Piper J3C-65 · S/N 15941 · Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1946 · Philbrick Richard E
- [N9305J](https://openairdocs.org/deregistered/N9305J-2013-05-22.md): Piper PA-28-180 · S/N 28-3397 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1966 · Taylor Dennis Y
- [N4855Z](https://openairdocs.org/deregistered/N4855Z-2013-05-08.md): Piper PA-22-108 · S/N 22-8430 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Griifith Jerry M
- [N86123](https://openairdocs.org/deregistered/N86123-2013-03-07.md): Aeronca 11BC · S/N 11AC-550 · Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946
- [N77RL](https://openairdocs.org/deregistered/N77RL-2011-07-19.md): Cessna 414A · S/N 414A0211 · Cancelled Jul 19, 2011 · Built 1978 · Fort Bedford Air Inc
- [N61941](https://openairdocs.org/deregistered/N61941-1995-08-16.md): Cessna 172M · S/N 17264901 · Cancelled Aug 16, 1995 · Triennial form not returned · Bun Air Corp
- [N25933](https://openairdocs.org/deregistered/N25933-1980-12-01.md): Cessna 152 · S/N 15280865 · Cancelled Dec 1, 1980 · Exported to Canada · Built 1977 · Bun Air Corp
- [N27629](https://openairdocs.org/deregistered/N27629-1965-05-21.md): Taylorcraft BL-65 · S/N 2271 · Cancelled May 21, 1965 · Built 1940 · Demose Paul W
- [N46307](https://openairdocs.org/deregistered/N46307-1965-05-20.md): Piper J3C-65 · S/N G-49 · Cancelled May 20, 1965 · Paul W De Moss
- [N713D](https://openairdocs.org/deregistered/N713D-1957-11-29.md): Beech C35 · S/N D-2984 · Cancelled Nov 29, 1957 · Blair-Fedford Airways Inc
- [N86102](https://openairdocs.org/deregistered/N86102-1956-07-24.md): Aeronca 11AC · S/N 11AC-528 · Cancelled Jul 24, 1956 · Exported to Canada · Built 1946 · Armstrong Joseph E
- [N2715E](https://openairdocs.org/deregistered/N2715E-1951-03-02.md): Aeronca 7AC · S/N 7AC-6295 · Cancelled Mar 2, 1951 · Bedford Airways
- [N51943](https://openairdocs.org/deregistered/N51943-1949-02-15.md): Fairchild M-62A · S/N T42-3862 · Cancelled Feb 15, 1949 · Built 1945 · Studebaker E G
- [N654Y](https://openairdocs.org/deregistered/N654Y-1935-08-06.md): Aeronca C-2 · S/N A-96 · Cancelled Aug 6, 1935 · Blackburn Norman L
- [N4454](https://openairdocs.org/deregistered/N4454-1934-11-01.md): Fairchild KR-31 · S/N 138 · Cancelled Nov 1, 1934 · James Fungaroli Jr

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

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