Skip to content

Cancelled registrations · 33

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

N22571Stinson HW75 · S/N 7168Cancelled May 1, 2023 · Built 1939 · Eckard Diane N141PWDJI INSPIRE 1 · S/N W13DCK24050760Cancelled Apr 1, 2023 · Registration expired, pending cancellation · City Of Burleson N935EKKirkpatrick Earl L SONEX - TAILWHEEL · S/N 1617Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 2019 · Kirkpatrick Earl L N4994LInfinity 582 · S/N IPP2064Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2002 · Harlow Wesley G N771CStinson 108-3 · S/N 108-3771Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1947 · Eckard Diane N1940XCessna 182H · S/N 18256040Cancelled May 21, 2019 · Built 1965 · Huffman Jacob M III N200ABGulfstream Aerospace G-1159A · S/N 393Cancelled May 10, 2019 · Built 1983 · Tst Holdings LLC N831KCDJI INSPIRE 1 · S/N W13DCD25030202Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Pinnacle Unmanned Aerial Systems LLC N8545WPiper PA-28-235 · S/N 28-10046Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1963 · Erickson John Bernard N439MMQuicksilver SPORT 2S · S/N 0189Cancelled Feb 15, 2018 · Sale reported, canceled N6575MStinson 108 · S/N 108-4575Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1948 · Peterson James T N61584Zerkle Roger L FSHER AERO CELEBRITY · S/N AV 1038Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1994 · Day Claude A N44GSSims RAND KR-1 · S/N 4503Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1978 · Bransom Jessie Rose N61RLBeech K35 · S/N D-5744Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1958 · Lewis Frederick E N4050TAble Joe R CHALLENGER 1 · S/N 394Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1994 · Morrow David D N6147NFowler Steve R SNO BIRD 532 · S/N 461-99-3431-RFCancelled May 6, 2015 · Registration expired, pending cancellation · Built 1991 · Fowler Steve R N3495XMooney M20F · S/N 670034Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1966 · Flournoy Richard L N69924Cessna 421B · S/N 421B0553Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1973 · Campbell John N4983BCessna 152 · S/N 15283738Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1979 · Tawil Hussein N6535ABishopper A · S/N BH-1Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1968 N2624CCessna 310 · S/N 35024Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1955 · T L Cross Aviation Inc N111PWages PANTHER · S/N 58WP-101Cancelled May 14, 2013 · Built 1957 · Wages Lisa G N610DDProbst BABY ACE D · S/N P-1919Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960 N2500SCessna 337C · S/N 337-0800Cancelled Sep 18, 2008 · Triennial form not returned · Built 1967 · Cross Thomas E Sr N309MAMitsubishi MU-2B-35 · S/N 602Cancelled Dec 13, 1996 · Topflight Turbines Inc N4ASSilvaggio CASSUTT 111M · S/N AMS02Cancelled Sep 12, 1995 · Triennial form not returned · Blakeney Terry N12RWWard PITTS SPECIAL WSC-1 · S/N 1589048Cancelled Apr 25, 1995 · Triennial form not returned · Macguire John C N9681QCessna 172M · S/N 17265765Cancelled Apr 10, 1991 · Triennial form not returned · Pickett Douglas S N2MNLaux PITTS MODEL S-1 · S/N L1Cancelled Jan 31, 1991 · Triennial form not returned · Edgerton Jeffry Scott N41378Piper J3C-65 · S/N 8036Cancelled Jul 11, 1984 · Built 1942 · Spinks M H Sr N337WCessna 337A · S/N 337-0432Cancelled Dec 18, 1981 · Built 1966 · Bowden Roy L Etal N6377JPiper PA-28-180 · S/N 28-4791Cancelled Oct 31, 1977 · Paxston Donald K N42272Piper J3C-65 · S/N 14522Cancelled Jun 8, 1965 · Built 1945 · Spinks M H Sr

Back to Burleson, TX