# Cancelled registrations: Connellsville, PA

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

Cancelled aircraft registrations in Connellsville, PA.

- [N25114](https://openairdocs.org/deregistered/N25114-2018-10-01.md): Luscombe 8 · S/N 1038 · Cancelled Oct 1, 2018 · Revoked, pending cancellation · Built 1939 · Anderson C Ronald
- [N896BP](https://openairdocs.org/deregistered/N896BP-2012-09-10.md): Prinkey Barry L SERIES V · S/N S96100197 · Cancelled Sep 10, 2012 · Registration pending, canceled
- [N4479](https://openairdocs.org/deregistered/N4479-2007-08-28.md): Jones Thomas RV-7 · S/N 71466 · Cancelled Aug 28, 2007 · Exported to Canada · Built 2006 · Jones Thomas
- [N5628T](https://openairdocs.org/deregistered/N5628T-2003-10-06.md): Cessna 172E · S/N 17251528 · Cancelled Oct 6, 2003 · Built 1964 · Reinhold Robert E
- [N183GT](https://openairdocs.org/deregistered/N183GT-1995-08-24.md): Enstrom F-28F · S/N 789 · Cancelled Aug 24, 1995 · Exported to Germany · Tedesco Manufacturing Co
- [N7852S](https://openairdocs.org/deregistered/N7852S-1973-03-22.md): Bell 206A · S/N 52 · Cancelled Mar 22, 1973 · Exported to United Kingdom · Keystone Aircraft Sales Inc
- [N420G](https://openairdocs.org/deregistered/N420G-1972-11-13.md): Beech 65-90 · S/N LJ-33 · Cancelled Nov 13, 1972 · Exported to Canada · Keystone Aircraft Sales Inc
- [N7239F](https://openairdocs.org/deregistered/N7239F-1972-08-14.md): Piper PA-28-140 · S/N 28-25151 · Cancelled Aug 14, 1972 · Keystone Aircraft Sales Inc
- [N88869](https://openairdocs.org/deregistered/N88869-1971-02-17.md): Cessna T-50 · S/N 6315 · Cancelled Feb 17, 1971 · Fayette Aviation
- [N8308Y](https://openairdocs.org/deregistered/N8308Y-1967-11-30.md): Piper PA-30 · S/N 30-1447 · Cancelled Nov 30, 1967 · Exported to South Africa · Built 1967 · The Lance Call Company Inc
- [N5167Y](https://openairdocs.org/deregistered/N5167Y-1967-10-05.md): Piper PA-23-250 · S/N 272209 · Cancelled Oct 5, 1967 · Exported to Zambia · Lance Call Company Inc
- [N5182Y](https://openairdocs.org/deregistered/N5182Y-1967-08-08.md): Piper PA-23-250 · S/N 27-2228 · Cancelled Aug 8, 1967 · Exported to Zambia · Lance Call Co Inc
- [N5255Y](https://openairdocs.org/deregistered/N5255Y-1967-06-05.md): Piper PA-23-250 · S/N 27-2316 · Cancelled Jun 5, 1967 · Exported to Zambia · Lance Call Co Inc
- [N8146Y](https://openairdocs.org/deregistered/N8146Y-1967-02-17.md): Piper PA-30 · S/N 30-1257 · Cancelled Feb 17, 1967 · Exported to Zambia · Lance Call Co Inc
- [N4715P](https://openairdocs.org/deregistered/N4715P-1965-10-05.md): Piper PA-23-250 · S/N 27-244 · Cancelled Oct 5, 1965 · Exported to Zambia · Lance Call Co Inc
- [N2204H](https://openairdocs.org/deregistered/N2204H-1949-03-13.md): Ercoupe 415-C · S/N 2827 · Cancelled Mar 13, 1949 · Built 1946 · Stevens Aviation Inc
- [N2776H](https://openairdocs.org/deregistered/N2776H-1948-04-19.md): Engineering & Research ERCOUPE 415-C · S/N 3401 · Cancelled Apr 19, 1948 · Stevens Aviation Inc
- [N91907](https://openairdocs.org/deregistered/N91907-1948-01-28.md): Piper PA-12 · S/N 12-16 · Cancelled Jan 28, 1948 · Connellsville Arpt Service Inc
- [N7476](https://openairdocs.org/deregistered/N7476-1933-02-03.md): Crawford A-1 · S/N 52 · Cancelled Feb 3, 1933 · Duggan H F

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

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