Skip to content

Cancelled registrations · 25

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

N1523PBeech F33A · S/N CE-1769Cancelled May 28, 2026 · Exported to Argentina · Built 1994 · Schmitt Rudy N48892Cessna 152 · S/N 15281034Cancelled May 28, 2026 · Exported to Argentina · Built 1977 · Schmitt Rudy N385AMCessna T206H · S/N T20609178Cancelled Dec 19, 2025 · Exported to Mexico · Built 2015 · Schmitt Rudy N728MBIsrael Aircraft Industries 1124A · S/N 419Cancelled Jun 3, 2023 · Built 1984 · Avalair Aircraft Management LLC N777PKPiper PA-31P · S/N 31P-7530001Cancelled May 27, 2023 · Registration pending, canceled N151CMMut Henry R T-51D · S/N M18XXXCOHK0218Cancelled Apr 24, 2023 · Built 2020 · Mut Henry R N54MCPiper PA-28-161 · S/N 28-7816208Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1977 · Hoffman Aviation Services LLC N2032HErcoupe 415-C · S/N 2655Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1946 · Sutton Sidney O N90XDarren STARDUSTER TOO · S/N 1Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1976 · Waters Norman R N1337FCessna 172G · S/N 17254832Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1966 · Weisinger Roy N42096Piper J3C-65 · S/N 14323Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1945 · Sutton Sidney O N72632Cessna 140 · S/N 9808Cancelled Feb 21, 2019 · Registration expired, pending cancellation · Built 1946 · Sutton Sidney O N4040BBalloon Works FIREFLY 7 · S/N 7811Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Built 1978 · Firth Leonard F N29790Taylorcraft BC12-65 · S/N 2638Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1941 · Sutton Sidney O N98WSCameron Balloons US V-77 · S/N 5584Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1989 · Firth Leonard F N564PFCameron Balloons US N-105 · S/N 5718Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1991 · Firth Leonard F N7751JLeonhardt T R/ Buck R L MJ77 · S/N 1Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1995 · Shawn James R N141BAColt Balloons 105-A · S/N 1224Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1988 · Firth Leonard F N8144KStinson 108-1 · S/N 108-1144Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1946 · Tidden George S N520RWWorthington William Scott ROTORWAY EXEC 90 · S/N 6839Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 2007 · Worthington William Scott N3870RCessna 172H · S/N 17255370Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1966 · First Takeoff LLC N7112UMooney M20E · S/N 354Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1964 · Sharon Carl G N67425Howard DGA-15P · S/N 1744Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1943 N8923CPiper PA-22-135 · S/N 22-1526Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1953 · Hagan Albert J N64LPRaven S55A · S/N S55A-1037Cancelled Jul 27, 2011 · Firth Leonard F

Back to Brookshire, TX