# Cancelled registrations: Bridgeport, TX

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

Cancelled aircraft registrations in Bridgeport, TX.

- [N757GM](https://openairdocs.org/deregistered/N757GM-2018-06-26.md): Beech C35 · S/N D-3239 · Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1952
- [N257B](https://openairdocs.org/deregistered/N257B-2018-05-03.md): Colonial C-1 · S/N 17 · Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1956 · Love Harold D
- [N8585M](https://openairdocs.org/deregistered/N8585M-2018-03-07.md): Beech P35 · S/N D-7207 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1963 · Read Michael
- [N31773](https://openairdocs.org/deregistered/N31773-2018-01-18.md): Gentry John K CHINOOK PLUS 2 · S/N 02282XS · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Cornell Henry F
- [N3154P](https://openairdocs.org/deregistered/N3154P-2015-05-08.md): Piper PA-23 · S/N 23-1085 · Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1957 · Bridgeport Flight Training Center Inc
- [N475AR](https://openairdocs.org/deregistered/N475AR-2012-12-13.md): Cessna 310K · S/N 310K0148 · Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1966 · Bridgeport Flight Trng Cir Inc
- [N5697P](https://openairdocs.org/deregistered/N5697P-2007-01-31.md): Piper PA-24-250 · S/N 24-770 · Cancelled Jan 31, 2007 · Built 1959 · Eaton Billy J
- [N2931R](https://openairdocs.org/deregistered/N2931R-2003-03-27.md): Cessna 310G · S/N 310G0131 · Cancelled Mar 27, 2003 · Triennial form undeliverable · Built 1962 · Bridgeport Flight Training Center
- [N52MA](https://openairdocs.org/deregistered/N52MA-2003-03-27.md): Cessna 152 · S/N 152-83231 · Cancelled Mar 27, 2003 · Triennial form undeliverable · Bridgeport Flight Training Ctr Inc
- [N6306H](https://openairdocs.org/deregistered/N6306H-2003-03-27.md): Cessna 152 · S/N 15284153 · Cancelled Mar 27, 2003 · Triennial form undeliverable · Built 1979 · Bridgeport Flight Training Center
- [N69073](https://openairdocs.org/deregistered/N69073-2003-03-27.md): Cessna 152 · S/N 15282473 · Cancelled Mar 27, 2003 · Second triennial mailing, no response · Built 1978 · Bridgeport Flight Training Center Inc
- [N152KS](https://openairdocs.org/deregistered/N152KS-1997-12-05.md): Cessna 152 · S/N 15285650 · Cancelled Dec 5, 1997 · Exported to Chile · Bridgeport Flight Training Ctr Inc
- [N4140P](https://openairdocs.org/deregistered/N4140P-1995-08-14.md): Piper PA-23-160 · S/N 231621 · Cancelled Aug 14, 1995 · Triennial form not returned · Bridgeport Flight Training Center
- [N2078P](https://openairdocs.org/deregistered/N2078P-1995-08-12.md): Piper PA-23 · S/N 23665 · Cancelled Aug 12, 1995 · Triennial form not returned · Bridgeport Flight Train Center Inc
- [N19317](https://openairdocs.org/deregistered/N19317-1994-06-15.md): Cessna 150L · S/N 15074332 · Cancelled Jun 15, 1994 · Bridgeport Flight Train Center Inc
- [N17294](https://openairdocs.org/deregistered/N17294-1982-11-04.md): Cessna 150L · S/N 15073707 · Cancelled Nov 4, 1982 · Administratively canceled · Pedigo William E DBA

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

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