Skip to content

Cancelled registrations · 108

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 = 'RAPID CITY' 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 = 'RAPID CITY'
  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 = 'RAPID CITY'
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.

N131PSSpackman E Paul QUICKIE TWO · S/N 2520Cancelled Oct 18, 2025 · Registration pending, canceled · Built 2002 N74479Grumman American Avn. AA-5B · S/N AA5B-0245Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1976 · Gen3 Aviation LLC N748YDDJI PHANTOM 3 PROFESSION · S/N P76DCG06011274Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Pete Lien And Sons Inc N749EPSensefly EBEE · S/N EB-03-32104Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Pete Lien And Sons Inc N869FSJohn M Sanders ZENITH STOL CH 701 · S/N 7-4423Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2020 · Sanders John M N37617Mueller Immanuel-Craig-Keith W-8 · S/N 449Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1980 · Giles Brandan K N7LNThorp T-18 · S/N 176Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1970 · Brandiger Katherine M N6036FArbc Inc DBA Lindstrand 90A · S/N 5216Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2002 · Kross Robert C N29JCCrawford WICHAWK · S/N JHC-2Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1975 · Anderson Timothy L N35155Piper J3L-65 · S/N 6162Cancelled Nov 29, 2019 · Revoked, canceled · Built 1941 · Berenbach Eile D N639AGDJI PHANTOM 3 ADVANCED · S/N P76DCF30014179Cancelled Nov 8, 2019 · Sale reported, canceled N32341Porterfield LP-65 · S/N 799Cancelled Apr 22, 2019 · Revoked, canceled · Built 1940 · Wortman Norman G N3183KPiper J3C-65 · S/N 4269Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1940 · Brown Patrick W N3292ACessna 170B · S/N 25936Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1953 · Kovarik Peter M N40027Arnold James Lee TITAN TORNADO · S/N D98912COHK0309Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2005 · Arnold James L N76538Cessna 120 · S/N 10974Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Shelton Clifton L N9479EAeronca 11AC · S/N 11AC908Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Lindquist Arthur N9696EAeronca 11AC · S/N 11AC1340Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Ethier Joseph R N2613APiper PA-22-135 · S/N 22-892Cancelled Oct 28, 2017 · Revoked, canceled · Built 1952 · Crawford Harry C N3349NPiper J3C-65 · S/N 22548Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Imel Floyd N59HWWenger Harry V SOLITAIRE · S/N 1Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1988 · Shouldis Charles E N3716DBalloon Works FIREFLY 7 · S/N F7-222Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1985 · Post Robert W N347JBJaye James Ronald CHRISTEN EAGLE II · S/N JAYE 0001Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1985 · Olson Terry N162FSPatten Jeffery D ROTORWAY EXEC 162F · S/N J02-2010Cancelled Feb 6, 2014 · Exported to Russia · Built 2010 · Patten Jeffery D N79869Mooney M20E · S/N 532Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1964 · Riggan Martin Anthony N447RMMeyer Rodney J 447 · S/N 3001Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Meyer Rodney J N7976UCessna 172F · S/N 17251976Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1964 · Tech Laverne R N55341Boeing A75N1(PT17) · S/N 75-1449Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1941 · Hillenbrand John N7417CBalloon Works FIREFLY 8B · S/N F8B-056Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1986 · Barnes John P N8888VVeldhuizen Gerald F HIGHLANDER · S/N JAESC0125Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 2008 · Veldhuizen Gerald F N40356Raven S55A · S/N S55A-850Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Blanks Harry H N9927SBeech 95-B55 (T42A) · S/N TC-1589Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1973 · Chace Auctioneers Inc N17517Geisz CASSUTT III M · S/N 1-GAGCancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1976 · Bodine Douglas P N9687Shouldis Charles E B-8M · S/N 2Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Shouldis Charles E N1045BMooney M20A · S/N 1272Cancelled Sep 18, 2012 · Revoked, canceled · Built 1958 · Post Kenneth F N9729ZEldredge BG-12A · S/N 1Cancelled Aug 22, 2012 · Second renewal notice · Built 1961 · Prodan John N22530Cessna 150H · S/N 15068341Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1968 N8918SSauder Darrell W AVID FLYER HEAVYHAUL · S/N 720Cancelled Aug 10, 2012 · Sale reported, canceled N95224Cessna 172R · S/N 17280413Cancelled Jan 31, 2012 · Exported to Canada · Built 1998 · Hardrocker Flying Club Inc N1414WBoeing A75L300 · S/N 75-2079Cancelled May 31, 2011 · Registration pending, canceled · Built 1940 N1680PPiper PA-22-150 · S/N 22-2466Cancelled Apr 20, 2011 · Sale reported, pending cancellation · Built 1954 N341MGNeal Allen B S-200 · S/N 041Cancelled Aug 30, 2010 · Neal Allen B N595DLLevoy David Franklin KITFOX 5 · S/N 96100199Cancelled Aug 17, 2010 · Built 1998 · Patten Jeffery D N371WNNeal Allen B ELLIPSE · S/N 09.3Cancelled Apr 1, 2010 · Neal Allen B N2158RRaven S55A · S/N S55A-400Cancelled Oct 8, 2008 · Triennial form not returned · Built 1978 · Kross Robert C N2GFBell 206B · S/N 2651Cancelled May 28, 2008 · Exported to Argentina · Built 1979 · Sabre Investments Inc N97MJHovland Johnny R KITFOX III · S/N 1023Cancelled Dec 5, 2006 · Exported to Canada · Built 1997 · Hovland Johnny R N80SRRaven S55A · S/N S55A-634Cancelled Mar 23, 2006 · Triennial form not returned · Built 1980 · Summers Aero Services Ltd N54695Raven S55A · S/N S55A-183Cancelled Apr 27, 2005 · Triennial form not returned · Built 1974 · Kross Robert C N491APiper PA-28R-201 · S/N 2844050Cancelled Apr 26, 2004 · Exported to United Kingdom · Built 2001 · Kolbach & Associates Investigation Inc

Back to Rapid City, SD