Cancelled registrations · 22

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 = 'MT' AND d.registrant_city = 'CHESTER' 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 = 'MT' AND d.registrant_city = 'CHESTER'
  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 = 'MT' AND d.registrant_city = 'CHESTER'
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.

N154BBRobinson Helicopter R22 BETA · S/N 3119Cancelled Feb 14, 2022 · Exported to Australia · Hendrickson Tyrel N95518Taylorcraft BC12-D · S/N 7818Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1946 · Snyder Dennis G N39283Taylorcraft BC12-D · S/N 6537Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1945 · Snyders Dent Shop N43869Taylorcraft BCS12-D · S/N 7528Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1946 · Snyders Dent Shop Inc N43868Taylorcraft BC12-D · S/N 7527Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1946 · Snyder Dennis G N110JRFenger Joel/Fenger Ruth JR 400 BOSS EAGLE · S/N JR-001-02Cancelled May 30, 2013 · Registration expired, pending cancellation · Fenger Joel N7304ACessna 172 · S/N 29404Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1956 · Layton Steven L N8812LEagle EAGLE DW-1 · S/N DW-1-0075-82Cancelled Jul 1, 2011 · Exported to Australia · Built 1982 N8805YEagle EAGLE DW-1 · S/N DW-1-0037-81Cancelled Sep 22, 2008 · Exported to Australia · Fenger Joel H N88012Bellanca DW-1 · S/N DW-1-0013-80Cancelled Aug 29, 2008 · Exported to Australia · Built 1980 · Fenger Joel H N8802BBellanca DW-1 · S/N DW-1-0014-80Cancelled Aug 29, 2008 · Exported to Australia · Built 1980 · Fenger Joel H N88103Eagle EAGLE DW-1 · S/N DW-1-0067-82Cancelled Aug 29, 2008 · Exported to Australia · Built 1982 · Fenger Joel H N8810YEagle EAGLE DW-1 · S/N DW-1-0065-82Cancelled Aug 29, 2008 · Exported to Australia · Built 1982 · Fenger Joel H N9638GCessna A188B · S/N 18801574Cancelled Aug 20, 2002 · Exported to Uruguay · Built 1974 · Ag Air Inc N2687NCessna 120 · S/N 12945Cancelled Oct 30, 1981 · Built 1947 · Colbry Earl T N3153XCessna A188B · S/N 18801948TCancelled Mar 4, 1981 · Exported to Mexico · Ag Air Inc N2153APiper PA-18-135 · S/N 18-1867Cancelled Feb 13, 1974 · Kolstad Clark E N5885HPiper PA-16 · S/N 16-506Cancelled Jan 4, 1971 · Bill W Fraser N4880APiper PA-18A · S/N 18-4979Cancelled Aug 20, 1957 · Piro Lester J N98117Piper J3C-65 · S/N 18272Cancelled Jul 1, 1949 · Wigen Robert N2313KLuscombe 8A · S/N 5040Cancelled Nov 20, 1947 · Rockman Lloyd H N2129Advance WACO 9 · S/N 606FCancelled Aug 10, 1939 · Built 1926 · Teel Joseph Homer

Back to Chester, MT