Cancelled registrations · 26

Query with 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 = 'PAMPA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'PAMPA'
  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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N554ALBell 412 · S/N 33017Cancelled Oct 27, 2023 · Exported to Canada · Built 1981 · Hudson Flight Limited LLC N339MGBell Helicopter Textron Canada 206L-4 · S/N 52265Cancelled Jan 9, 2019 · Exported to Chile · Built 2001 · Hudson Flight Limited LLC N95548Taylorcraft BC12-D · S/N 7848Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Martin Stephen E N37857Porterfield CP-65 · S/N 1004Cancelled Nov 22, 2017 · Revoked, canceled · Built 1941 · Top Of Texas Flying Club N41FCBrown Fred G 2R65 · S/N 348856Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Brown Fred G N335HBell 212 · S/N 35046Cancelled Oct 9, 2012 · Exported to Dominican Republic · Built 1991 · Hudson Flight Limited LLC N705LHBell 212 · S/N 30892Cancelled Oct 8, 2009 · Exported to Canada · Built 1978 · Hudson Flight Ltd LLC N706LHBell 212 · S/N 31178Cancelled Oct 8, 2009 · Exported to Canada · Built 1981 · Hudson Flight Ltd LLC N63380Cessna 150M · S/N 15077271Cancelled Jan 30, 2007 · Exported to Mexico · Built 1975 · Pritchett Douglas C N555TBeech V35A · S/N D-8643Cancelled Jun 10, 2005 · Triennial form not returned · Built 1967 · Worley Walter L Jr N1256RBellanca 17-30A · S/N 30396Cancelled Oct 3, 2001 · Harrison Donald A N15491Piper PA-28-180 · S/N 287305083Cancelled May 5, 1992 · Triennial form not returned · Hood Jack R N1271WWeatherly 201B · S/N 626Cancelled Feb 28, 1992 · Triennial form not returned · S & H Aerial Spraying Inc N24845Cessna 152 · S/N 15280408Cancelled May 10, 1983 · Built 1977 · Ekleberry Charles J N1921WBeech B19 · S/N MB590Cancelled Mar 23, 1983 · Administratively canceled N2255PPiper PA-23 · S/N 23-865Cancelled Sep 21, 1970 · Tanner Drilling Co N1272PPiper PA-23 · S/N 23-302Cancelled Sep 22, 1965 · Holt Brothers Drilling Company N2271GCessna 182B · S/N 51571Cancelled Feb 18, 1965 · W Wesley Lewis N37336Interstate S-1A · S/N 179Cancelled Oct 22, 1951 · Snoody C B Et Al N88346Piper J3C-65 · S/N 15964Cancelled May 2, 1951 · Pampa Flying Service N90104Cessna 140 · S/N 9165Cancelled Nov 21, 1949 · Hindman A J N89080Cessna 140 · S/N 8084Cancelled Apr 14, 1949 · Webb Roy A Jr N27522Taylorcraft BL-65 · S/N 2164Cancelled Jul 6, 1948 · Beeson Paul R & Russell A Chisholm N22313Aeronca 50-C · S/N C-3159Cancelled Dec 27, 1939 · Maddux Norman Forest N5041Swallow NEW SWALLOW · S/N S-4-PCancelled Jan 24, 1933 · Built 1924 · Bartgis R W Jr/Stansbury E A /Hobson W B N64893Cessna AT 17B · S/N 3348Cancellation date not recorded · Roy A Webb

Back to Pampa, TX