Skip to content

Sioux Falls, SD

Cancelled registrations · 227

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 = 'SIOUX FALLS' 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 = 'SIOUX FALLS'
  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 = 'SIOUX FALLS'
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.

N5241NHart Doug K KITFOX III · S/N 1172Cancelled Aug 14, 2026 · Registration pending, canceled · Built 2006 N606GJCessna 680 · S/N 680-0206Cancelled May 6, 2025 · Exported to Mexico · Westwind Ventures LLC N717RHGulfstream Aerospace GVI (G650ER) · S/N 6191Cancelled Jan 31, 2025 · Exported to Canada · Built 2016 · Rh Rise LLC N169WBTextron 208B · S/N 208B5295Cancelled Jan 22, 2025 · Exported to Canada · Built 2016 · Billion Air LLC N6643YBeech V35B · S/N D-10264Cancelled Jun 27, 2023 · Built 1979 · Breit James A N107EHRobinson Helicopter R44 II · S/N 10423Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Mn Helicopters Inc N9056DBalloon Works FIREFLY 7-15 · S/N F7-727Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1991 · Burgers Stanley P N90397Raven Industries RALLY RX7 · S/N RX7-3275Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1992 · Blankers Joel T N6327YAerostar International RAVEN S49A · S/N S49A-3018Cancelled Dec 24, 2022 · Built 1990 · 605 Balloons Ride LLC N4090NAerostar International S-60A · S/N S60A-3229Cancelled Jun 30, 2022 · 605 Balloon Ride LLC N11045Hauser Dane T AEROTRIKESAFARITUNDR · S/N 001Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2009 · Stewart Karl M N75191Piper PA-28-181 · S/N 28-7690310Cancelled Aug 10, 2020 · Built 1976 · Haraldson Comet N44EZOwens-Devries VERI EZE · S/N 1139Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Osman William R N605SFDJI PV331 · S/N PH645480305 V 3 0Cancelled Nov 4, 2019 · Registration expired, pending cancellation · M & H Real Estate Inc N7085MRobinson Helicopter R44 · S/N 0430Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1998 · Ride The Sky Helicopters N60187Cessna 150J · S/N 15070133Cancelled Oct 31, 2019 · Registration expired, pending cancellation · Built 1969 · Hotel Alpha Charlie LLC N747YADJI INSPIRE 1 RAW · S/N W21ADB24020295Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Aerial Horizons Uas LLC N6745VBeech 58P · S/N TJ-272Cancelled Mar 15, 2019 · Built 1980 · Meyer Vaughn N3520MPiper PA-12S · S/N 12-2095Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1947 · Phillips Gerry N1967NCirrus Design SR22T · S/N 0031Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 2010 · Mwbs Holdings LLC N248MEDiamond Aircraft Ind DA20-C1 · S/N C0267Cancelled Jan 8, 2018 · First renewal notice · Built 2004 · Aaf Incorporated N2917KLuscombe 8A · S/N 5644Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Hybertson H L DBA N337XYCessna T337H · S/N 33701930Cancelled Dec 11, 2017 · Exported to Canada · Apollonia Leasing Company LLC N2652HEngineering & Research ERCOUPE 415-C · S/N 3277Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1946 · Schuer Richard C N3769CSchlueter-Oien CW JR REPLICA MOD · S/N SO-1002Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1980 · Oien Hemming O N51455Aerostar International S-64A · S/N S64A-EXP3001Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1998 · Aerostar International Inc N90296Aerostar International RAVEN S49A · S/N S49A-3127Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1992 · Aerostar International Inc N5415ZPiper PA-22-108 · S/N 22-9188Cancelled May 22, 2017 · Registration expired, pending cancellation · Schuer Richard C N9653ZIntermountain CALLAIR A-9 · S/N 1043Cancelled Feb 13, 2017 · Revoked, canceled · Built 1963 · Gustafson R E DBA N903SHBell 230 · S/N 23002Cancelled Dec 28, 2016 · Built 1994 · Sanford Health N563WKDJI INSPIRE 1 · S/N W13DBL21020274Cancelled Nov 15, 2016 · Aerial Horizons Uas LLC N722XDDJI INSPIRE 1 · S/N W13DCC17020025Cancelled Nov 15, 2016 · Aerial Horizons Uas LLC N722YLDJI SPREADINGWINGS S1000 · S/N 02Q0021311Cancelled Nov 15, 2016 · Aerial Horizons Uas LLC N12455Cessna 414A · S/N 414A1207Cancelled Feb 24, 2016 · First renewal notice · Built 1985 · Mitchell Flyboys LLC N2910RRaven Industries RALLY RX7 · S/N RX7-101Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1978 · Aeronauts Ltd N43748Taylorcraft BC12-D · S/N 7407Cancelled Dec 24, 2014 · Registration expired, pending cancellation · Built 1946 · Schuer Richard C N81TMMonnin Thomas J VARIEZE · S/N 867Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Monnin Thomas J N9069TCessna 182C · S/N 52969Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1960 · Hunter Jerome H N71572Luscombe 8A · S/N 2999Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1946 · Hunter Paul J N894CTDiamond Aircraft Ind DA20-C1 · S/N C0094Cancelled Feb 21, 2014 · Ken Graham Ph D Inc N6320YAerostar International RAVEN S49A · S/N S49A-3012Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Aerostar International Inc N6349VAerostar International W100LB · S/N W100LB-3001Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1990 · Aerostar International Inc N6347UAerostar International RAVEN S-47A · S/N S47A-3001Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1990 · Aerostar International Inc N6303GAerostar International RX 8 · S/N RX8-3069Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Aerostar International Inc N6364XAerostar International RAVEN S49A · S/N S49A-3100Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1991 · Burgers Stanley P N59SHHyde William R SEA HAWK · S/N 59Cancelled Aug 21, 2013 · Sale reported, canceled N4514ZPiper PA-22-108 · S/N 22-8016Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1960 · Schuer Richard C N216TBWarth Dennis J CLASSIC SPT AC S-18 · S/N 245Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 2005 · Baloun Aviation LLC N6479APiper PA-38-112 · S/N 38-78A0435Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1978 · Cre Corporation N437TGComp Terry L KR-2S · S/N 1103Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Comp Terry L

Back to Sioux Falls, SD