Cancelled registrations · 24

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

N3583ECessna 172N · S/N 17271597Cancelled Nov 10, 2020 · Exported to Canada · Built 1978 · Wharton Brooks N2924WPiper PA-28-161 · S/N 28-7916546Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1979 · Texas State Technical College West Texas N3205ZPiper PA-22-150 · S/N 227145Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Howard John T N7550FChampion 7GCAA · S/N 205-70Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1969 · Wharton Brooks A N9789SRockwell International 695 · S/N 95037Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1980 · Sweetwater Drilling Co Inc N6827SAero Commander 680 · S/N 680-441-113Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1957 · Mcelmurray Joe B N5757PPiper PA-24-250 · S/N 24-833Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1959 N53341Consolidated Vultee BT-13A · S/N 9447Cancelled Jul 21, 2008 · Triennial form not returned · Built 1943 · Lukins Floyd N6638GCessna 150L · S/N 15072138Cancelled Sep 20, 1997 · U S Flight Academy Intl Inc N717EPiper PA-23-250 · S/N 272414Cancelled Jan 25, 1995 · Texas State Technical College N51TMTurner/Martin TURNER-MARTIN · S/N TM1Cancelled May 20, 1992 · Triennial form not returned · Turner Benjamin B N732KHCessna 210L · S/N 21061569Cancelled Nov 14, 1985 · Big Country Oil Co N5631NMaule M-5-235C · S/N 7248CCancelled Apr 19, 1983 · Davis E Richard N4767NConvair BT-13A · S/N 5330Cancelled Apr 13, 1971 · Gus Fowler N7596KPiper PA-18 · S/N 18-313Cancelled Aug 23, 1956 · Exported to Mexico · Boyce James R N1278DCessna 170A · S/N 19854Cancelled Feb 11, 1953 · Ollie William Cox Jr N36035Taylorcraft BC12-65 · S/N 3000Cancelled Aug 1, 1951 · Built 1941 · Taylor Pontiac Co N4127VCessna 170 · S/N 18459Cancelled Jul 30, 1951 · Cox Billy N4613NHoward DGA-15P · S/N 1782Cancelled Jul 30, 1951 · Taylor Buddy N7905HPiper PA-12 · S/N 12-809Cancelled Jul 30, 1951 · Alexander Garnet N36932Aeronca 65-TAC · S/N 2351Cancelled Apr 17, 1951 · Eder A J N78005Globe GC-1B · S/N 2035Cancelled Mar 12, 1951 · Brooks Packing Co N92720Piper PA-12 · S/N 12-156Cancelled Mar 12, 1951 · Alexander Garnet N330Aeronca 50-C · S/N C1268Cancelled Mar 30, 1943 · Built 1938 · Herndon J W Jr

Back to Sweetwater, TX