Skip to content

Cancelled registrations · 19

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 = 'SD' AND d.registrant_city = 'CUSTER' 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 = 'SD' AND d.registrant_city = 'CUSTER'
  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 = 'SD' AND d.registrant_city = 'CUSTER'
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.

N130ZXBuckeye 582 DREAM MACHINE · S/N 3809Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1997 · Biltoft Wayne R N9000GAerostar International S-66A · S/N S66A-3047Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1991 · Flying Circus Inc N2804JRaven S-60A · S/N S60A-399Cancelled May 6, 2019 · Registration expired, pending cancellation · Steve Bauer DBA N142WLMcafee Wayne A CHALLENGER II SPEC · S/N CH2-10032382Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2009 · Mcafee Wayne A N135JEWinter James R WINTER/SPENCERAIRCAR · S/N 135Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Winter James R N2867WAerostar International S-77A · S/N S77A-3002Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1986 · Black Hills Balloons Inc N31405Bell 47G-3B-1 · S/N 3545Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 1967 · Dakota Rotors LLC N26361Aeronca 65-C · S/N C8250Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1940 · Uecker R W N21JEStinson 108-2 · S/N 108-3150Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1947 · Winter James R N97680Stinson 108 · S/N 108-680Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1946 · Winter James R N54704Raven Industries RX6 · S/N RX6-101Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1974 N202Sessi Midget Mustang SK-1 · S/N 501Cancelled Jun 28, 2011 · Registration pending, pending cancellation · Built 1969 N9625ACessna 140A · S/N 15477Cancelled Nov 29, 2007 · Exported to Canada · Built 1950 · Mcintyre Lawrence G N13JKBotsford KELEHER LARK JK-1A · S/N 189Cancelled Oct 25, 2004 · Triennial form not returned · Built 1987 · Botsford Jack M N28171Aerostar International S-77A · S/N S77A-3004Cancelled Sep 15, 2000 · Triennial form not returned · Black Hills Balloons N108DDStinson/Winter James 108-3 · S/N R108-4171Cancelled Dec 3, 1999 · Winter James R N39048Grumman American Avn. AA-1C · S/N AA1C0202Cancelled Jan 22, 1999 · Triennial form not returned · Holst Gary C N17391Dehavilland Canada U6A · S/N 52-6139Cancelled Sep 21, 1979 · Exported to Canada · Southwestern Civil Preparedness District N72353Cessna 140 · S/N 9537Cancelled Jan 26, 1965 · Hauptmann Roger

Back to Custer, SD