# Cancelled registrations: Bristol, PA

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

Cancelled aircraft registrations in Bristol, PA.

- [N28426](https://openairdocs.org/deregistered/N28426-2024-06-29.md): Grumman American Avn. AA-5B · S/N AA5B0606 · Cancelled Jun 29, 2024 · Revoked, canceled · Built 1977 · Hortman Aviation Inc
- [N60048](https://openairdocs.org/deregistered/N60048-2020-04-03.md): Consolidated Vultee BT-13B (SNV-2) · S/N 79577 · Cancelled Apr 3, 2020 · Revoked, canceled · Built 1944 · Engle Flying Svc Inc
- [N3624A](https://openairdocs.org/deregistered/N3624A-2019-12-13.md): Piper PA-22-135 · S/N 22-1882 · Cancelled Dec 13, 2019 · Revoked, canceled · Built 1953 · Engle Flying Service Inc
- [N9627L](https://openairdocs.org/deregistered/N9627L-2018-04-10.md): Grumman American Avn. AA-1B · S/N AA1B-0127 · Cancelled Apr 10, 2018 · Revoked, canceled · Built 1973 · Hortman Aviation Inc
- [N9352L](https://openairdocs.org/deregistered/N9352L-2018-04-06.md): American AA-1A · S/N AA1A-0052 · Cancelled Apr 6, 2018 · Revoked, canceled · Built 1971 · Hortman Aviation Inc
- [N60317](https://openairdocs.org/deregistered/N60317-2017-11-21.md): Fairchild M-62A · S/N 262SL · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Engle Flying Svc Inc
- [N75040](https://openairdocs.org/deregistered/N75040-2017-02-04.md): Piper PA-28-151 · S/N 28-7615239 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Hortman Aviation Inc
- [N3546U](https://openairdocs.org/deregistered/N3546U-2014-10-02.md): Piper PA-31-350 · S/N 31-8052010 · Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1979 · Hortman Aviation Inc
- [N8444P](https://openairdocs.org/deregistered/N8444P-2013-09-17.md): Piper PA-24-400 · S/N 26-23 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1964 · Lane Dispatching And Warehousing Inc
- [N1470N](https://openairdocs.org/deregistered/N1470N-2012-06-21.md): Piper J3C-65 · S/N 23138 · Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1947
- [N7615C](https://openairdocs.org/deregistered/N7615C-2012-02-02.md): Beech C-45G · S/N 51-11481 · Cancelled Feb 2, 2012 · Revoked, pending cancellation · Built 1953 · Engle Flying Svc Inc
- [N60239](https://openairdocs.org/deregistered/N60239-2011-05-19.md): Cessna T-50 · S/N 2286 · Cancelled May 19, 2011 · Revoked, pending cancellation · Built 1940 · Engle Flying Svc Inc
- [N9673L](https://openairdocs.org/deregistered/N9673L-2009-09-29.md): Grumman American Avn. AA-1B · S/N AA1B-0173 · Cancelled Sep 29, 2009 · Registration revoked · Built 1973 · Hortman Aviation Inc
- [N5193M](https://openairdocs.org/deregistered/N5193M-1997-10-29.md): Beech B19 · S/N MB879 · Cancelled Oct 29, 1997 · Schmidt Elaine C
- [N2056C](https://openairdocs.org/deregistered/N2056C-1977-07-13.md): Beech 95 · S/N TD-244 · Cancelled Jul 13, 1977 · Major William G
- [N76422](https://openairdocs.org/deregistered/N76422-1975-06-10.md): Cessna 140 · S/N 10848 · Cancelled Jun 10, 1975 · Peirce Joseph B
- [N810Y](https://openairdocs.org/deregistered/N810Y-1974-10-29.md): Great Lakes 2T-1A · S/N 197 · Cancelled Oct 29, 1974 · Hamilton George W And William B Denight
- [N5507J](https://openairdocs.org/deregistered/N5507J-1974-07-23.md): Piper PA-32-260 · S/N 32980 · Cancelled Jul 23, 1974 · Hortman Aviation Inc
- [N9249L](https://openairdocs.org/deregistered/N9249L-1972-10-18.md): American AA-1A · S/N AA1A-0149 · Cancelled Oct 18, 1972 · Hortman Aviation Inc
- [N23916](https://openairdocs.org/deregistered/N23916-1971-12-10.md): Aeronca 65-C · S/N C-5759 · Cancelled Dec 10, 1971 · Built 1939 · Engle Flying Service Inc
- [N3288N](https://openairdocs.org/deregistered/N3288N-1971-07-15.md): Piper J3C-65 · S/N 22484 · Cancelled Jul 15, 1971 · Engle Flying Service
- [N38339](https://openairdocs.org/deregistered/N38339-1965-05-20.md): Piper J3C-65 · S/N 6947 · Cancelled May 20, 1965 · Smith Englebert G
- [N30238](https://openairdocs.org/deregistered/N30238-1955-10-20.md): Piper J3C-65 · S/N 4717 · Cancelled Oct 20, 1955 · Built 1940 · Orourke Francis J Et Al
- [N47144](https://openairdocs.org/deregistered/N47144-1953-11-09.md): Laister-Kauffman LK-10A · S/N 16 · Cancelled Nov 9, 1953 · Replogle Edward H
- [N91090](https://openairdocs.org/deregistered/N91090-1949-05-17.md): Stearman-Hammond Y-1S · S/N 1 · Cancelled May 17, 1949 · Kaiser Fleetwings Inc
- [N37010](https://openairdocs.org/deregistered/N37010-1942-09-18.md): Fleetwings 36 · S/N 36-1 · Cancelled Sep 18, 1942 · Fleetwings Inc
- [N6635](https://openairdocs.org/deregistered/N6635-1934-08-08.md): Trump F L TRUMP MODEL 1 · S/N 1 · Cancelled Aug 8, 1934 · Built 1927 · Trump Frederic L
- [N969V](https://openairdocs.org/deregistered/N969V-1933-02-03.md): Curtiss Aeroplane & Motor TEAL · S/N G-1 · Cancelled Feb 3, 1933 · Keystone Aircraft Corp
- [N970V](https://openairdocs.org/deregistered/N970V-1932-12-21.md): Curtiss Aeroplane & Motor TEAL · S/N G-2 · Cancelled Dec 21, 1932 · Keystone Aircraft Corp
- [N340W](https://openairdocs.org/deregistered/N340W-1930-06-27.md): Keystone K84 COMMUTER · S/N 321 · Cancelled Jun 27, 1930 · Built 1930 · Keystone Aircraft Corp
- [N7962](https://openairdocs.org/deregistered/N7962-1930-06-23.md): Keystone K-78 (PATRICIAN) · S/N 186 · Cancelled Jun 23, 1930 · Keystone Aircraft Corp
- [N2612](https://openairdocs.org/deregistered/N2612-1930-05-06.md): Poast VOLKSPLANE VP-2 · S/N 333 · Cancelled May 6, 1930 · Hall Charles Ward

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

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