OpenAirDocs.org
Bristol, PA

Cancelled registrations · 32

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 = 'PA' AND d.registrant_city = 'BRISTOL'
  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.

N28426Grumman American Avn. AA-5B · S/N AA5B0606Cancelled Jun 29, 2024 · Revoked, canceled · Built 1977 · Hortman Aviation IncN60048Consolidated Vultee BT-13B (SNV-2) · S/N 79577Cancelled Apr 3, 2020 · Revoked, canceled · Built 1944 · Engle Flying Svc IncN3624APiper PA-22-135 · S/N 22-1882Cancelled Dec 13, 2019 · Revoked, canceled · Built 1953 · Engle Flying Service IncN9627LGrumman American Avn. AA-1B · S/N AA1B-0127Cancelled Apr 10, 2018 · Revoked, canceled · Built 1973 · Hortman Aviation IncN9352LAmerican AA-1A · S/N AA1A-0052Cancelled Apr 6, 2018 · Revoked, canceled · Built 1971 · Hortman Aviation IncN60317Fairchild M-62A · S/N 262SLCancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Engle Flying Svc IncN75040Piper PA-28-151 · S/N 28-7615239Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Hortman Aviation IncN3546UPiper PA-31-350 · S/N 31-8052010Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1979 · Hortman Aviation IncN8444PPiper PA-24-400 · S/N 26-23Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1964 · Lane Dispatching And Warehousing IncN1470NPiper J3C-65 · S/N 23138Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1947N7615CBeech C-45G · S/N 51-11481Cancelled Feb 2, 2012 · Revoked, pending cancellation · Built 1953 · Engle Flying Svc IncN60239Cessna T-50 · S/N 2286Cancelled May 19, 2011 · Revoked, pending cancellation · Built 1940 · Engle Flying Svc IncN9673LGrumman American Avn. AA-1B · S/N AA1B-0173Cancelled Sep 29, 2009 · Registration revoked · Built 1973 · Hortman Aviation IncN5193MBeech B19 · S/N MB879Cancelled Oct 29, 1997 · Schmidt Elaine CN2056CBeech 95 · S/N TD-244Cancelled Jul 13, 1977 · Major William GN76422Cessna 140 · S/N 10848Cancelled Jun 10, 1975 · Peirce Joseph BN810YGreat Lakes 2T-1A · S/N 197Cancelled Oct 29, 1974 · Hamilton George W And William B DenightN5507JPiper PA-32-260 · S/N 32980Cancelled Jul 23, 1974 · Hortman Aviation IncN9249LAmerican AA-1A · S/N AA1A-0149Cancelled Oct 18, 1972 · Hortman Aviation IncN23916Aeronca 65-C · S/N C-5759Cancelled Dec 10, 1971 · Built 1939 · Engle Flying Service IncN3288NPiper J3C-65 · S/N 22484Cancelled Jul 15, 1971 · Engle Flying ServiceN38339Piper J3C-65 · S/N 6947Cancelled May 20, 1965 · Smith Englebert GN30238Piper J3C-65 · S/N 4717Cancelled Oct 20, 1955 · Built 1940 · Orourke Francis J Et AlN47144Laister-Kauffman LK-10A · S/N 16Cancelled Nov 9, 1953 · Replogle Edward HN91090Stearman-Hammond Y-1S · S/N 1Cancelled May 17, 1949 · Kaiser Fleetwings IncN37010Fleetwings 36 · S/N 36-1Cancelled Sep 18, 1942 · Fleetwings IncN6635Trump F L TRUMP MODEL 1 · S/N 1Cancelled Aug 8, 1934 · Built 1927 · Trump Frederic LN969VCurtiss Aeroplane & Motor TEAL · S/N G-1Cancelled Feb 3, 1933 · Keystone Aircraft CorpN970VCurtiss Aeroplane & Motor TEAL · S/N G-2Cancelled Dec 21, 1932 · Keystone Aircraft CorpN340WKeystone K84 COMMUTER · S/N 321Cancelled Jun 27, 1930 · Built 1930 · Keystone Aircraft CorpN7962Keystone K-78 (PATRICIAN) · S/N 186Cancelled Jun 23, 1930 · Keystone Aircraft CorpN2612Poast VOLKSPLANE VP-2 · S/N 333Cancelled May 6, 1930 · Hall Charles Ward
Back to Bristol, PA