OpenAirDocs.org
Bridgeport, TX

Cancelled registrations · 16

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N757GMBeech C35 · S/N D-3239Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1952N257BColonial C-1 · S/N 17Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1956 · Love Harold DN8585MBeech P35 · S/N D-7207Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1963 · Read MichaelN31773Gentry John K CHINOOK PLUS 2 · S/N 02282XSCancelled Jan 18, 2018 · Registration expired, pending cancellation · Cornell Henry FN3154PPiper PA-23 · S/N 23-1085Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1957 · Bridgeport Flight Training Center IncN475ARCessna 310K · S/N 310K0148Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1966 · Bridgeport Flight Trng Cir IncN5697PPiper PA-24-250 · S/N 24-770Cancelled Jan 31, 2007 · Built 1959 · Eaton Billy JN2931RCessna 310G · S/N 310G0131Cancelled Mar 27, 2003 · Triennial form undeliverable · Built 1962 · Bridgeport Flight Training CenterN52MACessna 152 · S/N 152-83231Cancelled Mar 27, 2003 · Triennial form undeliverable · Bridgeport Flight Training Ctr IncN6306HCessna 152 · S/N 15284153Cancelled Mar 27, 2003 · Triennial form undeliverable · Built 1979 · Bridgeport Flight Training CenterN69073Cessna 152 · S/N 15282473Cancelled Mar 27, 2003 · Second triennial mailing, no response · Built 1978 · Bridgeport Flight Training Center IncN152KSCessna 152 · S/N 15285650Cancelled Dec 5, 1997 · Exported to Chile · Bridgeport Flight Training Ctr IncN4140PPiper PA-23-160 · S/N 231621Cancelled Aug 14, 1995 · Triennial form not returned · Bridgeport Flight Training CenterN2078PPiper PA-23 · S/N 23665Cancelled Aug 12, 1995 · Triennial form not returned · Bridgeport Flight Train Center IncN19317Cessna 150L · S/N 15074332Cancelled Jun 15, 1994 · Bridgeport Flight Train Center IncN17294Cessna 150L · S/N 15073707Cancelled Nov 4, 1982 · Administratively canceled · Pedigo William E DBA
Back to Bridgeport, TX