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 = 'UT' AND d.registrant_city = 'PRICE' 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 = 'UT' AND d.registrant_city = 'PRICE'
  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 = 'UT' AND d.registrant_city = 'PRICE'
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.

N2382PPiper PA-22-150 · S/N 22-2773Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1955 · Freidt Brooks R N367NCessna T210L · S/N 21060325Cancelled Jan 31, 2019 · Second renewal notice · Built 1974 · Arrow West Aviation Inc N9825MCessna T207A · S/N 20700739Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1981 · Slickrock Air Guides Inc N732YLCessna 210M · S/N 21061880Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1977 · Price Bail Bonding Inc N8945VCessna 172M · S/N 17264301Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1974 · Love-Less Ash Co N7060TCessna 172 · S/N 46660Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1959 · Campbell Robert L N71276Cessna 182M · S/N 18259558Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1969 · Love-Less Ash Co N4990YMessick Richard G SCORPION 133 · S/N RW2727Cancelled Sep 5, 2012 · Sale reported, pending cancellation N389ESCessna 172R · S/N 17280119Cancelled Aug 8, 2012 · First renewal notice · Built 1997 · Arrow West Aviation Inc N2609DPiper PA-38-112 · S/N 38-79A0393Cancelled Apr 22, 2004 · Second triennial mailing, no response · Madsen Edward K N25074First Fighter GRP Flying Club W.A.R. FW 190 · S/N 75Cancelled Oct 7, 1996 · Triennial form not returned · Clark Keith J N5003UBell 206B · S/N 2444Cancelled Jun 12, 1992 · Summit Helicopter Systems Inc N8912NPiper PA-32-300 · S/N 3240701Cancelled Feb 10, 1992 · Triennial form not returned · Henderson G Wilson N18687Cessna 150L · S/N 15074042Cancelled Apr 15, 1982 · Administratively canceled · Keppler Richard J N88244Piper J3C-65 · S/N 15861Cancelled Apr 29, 1974 · Lucky Seven Flg Clb N63325Consolidated Vultee BT-15 · S/N 2623Cancelled Oct 25, 1955 · Anderson Charles Lee Jr N64401Fairchild M-62A · S/N T41603Cancelled Oct 13, 1955 · Mabbuttdarwin N1753VCessna 120 · S/N 13938Cancelled Jun 2, 1950 · Carbon Emery Flying Service N1702VCessna 120 · S/N 13886Cancelled Jun 3, 1949 · Carbon Emery Flying Service N89704Cessna 140 · S/N 8753Cancelled Dec 4, 1947 · Reed E J N8769Swallow TP · S/N 169Cancelled May 26, 1936 · Lund Jimmie N901MMoth 60-GM · S/N 102Cancelled Dec 9, 1935 · Built 1929 · Fletcher John N10663Skyriders Glider Club MEAD PRIMARY GLIDER · S/N 1Cancelled Apr 19, 1934 · Skyriders Glider Club N11477Waco QDC · S/N 3545Cancelled Jan 21, 1934 · Built 1931 · Ferguson C R

Back to Price, UT