Skip to content

Cancelled registrations · 242

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 = 'IA' AND d.registrant_city = 'DES MOINES' 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 = 'IA' AND d.registrant_city = 'DES MOINES'
  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 = 'IA' AND d.registrant_city = 'DES MOINES'
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.

N438PLRasmussen Paul SUPER KOALA · S/N SK083Cancelled Sep 14, 2025 · Built 1998 · Rasmussen Paul J N9419KStinson 108-2 · S/N 108-2419Cancelled Aug 13, 2022 · Built 1947 · Broer Marc W N4055TBalloon Works FIREFLY 7 · S/N 10136Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1980 · King Gary D N426VRussell LINCOLN PETE · S/N 1Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1978 · Grove Kevin W N5761White J-B-8-M GYROCOPTER · S/N DRM1Cancelled Apr 10, 2020 · Revoked, canceled · White John M N82126Gulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 524BCancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1979 · Todd Scott A N8983WPiper PA-28-235 · S/N 28-10562Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Built 1964 · Teko Air LLC N83523Aeronca 7AC · S/N 7AC-2196Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Mcwilliams E V Jr N1172VBeech D17S · S/N 6893Cancelled Aug 29, 2019 · Revoked, canceled · Built 1944 · Casady Richard N1126YCessna 150B · S/N 15059526Cancelled Apr 12, 2019 · Revoked, canceled · Built 1962 · Mcdonough C H N203RMPipistrel SW VIRUS · S/N 313 VSW 100Cancelled Jun 11, 2018 · Exported to Argentina · Built 2009 · Hubbell Michael C N86907Bellanca 14-13 · S/N 1269Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Iowa Gen Svc Inc N5305JCameron Balloons US C-60 · S/N 6156Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1998 · Pfeifer Grant S N37DCCline Daniel A TERATORN TIERRA II · S/N 11562Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1987 · Shreck Robert R N60294Shreffler Donald R MINI MAX 1300Z · S/N MK29Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2009 · Shreffler Donald R N2089HBalloon Works FIREFLY 6B · S/N 6704Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1977 · Clemons Bill J N73CRBeech A60 · S/N P-222Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1973 · Duke Aircraft Corp Trustee N586BCBeech B200 · S/N BB-1223Cancelled May 24, 2017 · Registration expired, pending cancellation · Blue Cross And Blue Shield Of Iowa N5985CBeech D35 · S/N D-3410Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1952 · Randell Conrad Wesley N3611UBalloon Works FIREFLY 7-B · S/N F7B-073Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1983 · Clemons Benji J N8691LRaven Industries RX6 · S/N RX6-156Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1975 · Tallant David E N15059Balloon Works FIREFLY 7 · S/N 11147Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Corbin Daniel L N1526GBalloon Works FIREFLY 7-B · S/N 11104Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1981 · Clemons Benjamen J N50BUOliver A Bruce RV6-A · S/N 24441Cancelled Apr 1, 2014 · Second renewal notice · Built 2000 · Doyle Bob R DBA N23KKKoenig James M GLASAIR I-RG · S/N 640RCancelled Nov 1, 2013 · Registration expired, pending cancellation · Koenig James M N5985Hiller H-23D · S/N 58-5459Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1958 · Des Moines Independent Coummunity School District N7166XNational Ballooning 752-12 · S/N 01213Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Nutting Robert H Jr N1046RRaven S55A · S/N S55A-234Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1975 · Zino Mark E N196PHLearjet 45 · S/N 056Cancelled Aug 23, 2013 · Exported to Australia · Built 1999 · E I Du Pont De Nemours And Co N8653HAxtell Dwight A TBT06 T-BIRD II · S/N TB-1001Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1994 N65122Stokes JS56C · S/N HB495Cancelled Aug 6, 2013 · Revoked, canceled · Built 1975 · Harry Ferguson Inc N71256Luscombe 8A · S/N 2683Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1946 N71181Silvaire LUSCOMBE 8A · S/N 2608Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1946 · Crucheiow John F N989TPCessna 182J · S/N 18257006Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1966 · Kalwishky David L N431NANorth American T-39A · S/N 60-3488Cancelled May 21, 2013 · Registration expired, pending cancellation · Des Moines Educational Resource Ctr N8551MCessna 337E · S/N 33701251Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1969 · Des Moines Public Schools N777REPiper PA-32-300 · S/N 32-7440047Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1973 · F I S Leaseplan Inc N90380Noltze Carl J RAND KR-1 · S/N 507Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1980 N771SUWegner KR-2 · S/N 5521Cancelled Feb 26, 2013 · Sale reported, canceled N3142KGreat Planes Skyriders EIPPER MX-II · S/N 4028Cancelled Nov 29, 2012 · Sale reported, pending cancellation · Built 1982 N4067YBalloon Works FIREFLY 7 · S/N 10031Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1979 · Ford Gary T N3708CStinson L-5 · S/N 3830Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Independent School District N3197Piccard AX-6 · S/N 103Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1968 · Ebeling Robert L N3441MMeyers Industries 200 · S/N 1Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1953 N9642BCessna 172RG · S/N 172RG0938Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1981 N51233Fairchild M-62A · S/N T-42-1482Cancelled Aug 10, 2012 · Revoked, canceled · Built 1942 · Argene T Rose N9152YBeech B-55 · S/N TF-48Cancelled Aug 9, 2012 · Registration pending, canceled · Built 1965 N7940QCessna 310Q · S/N 310Q0623Cancelled Jul 19, 2012 · Registration pending, canceled · Built 1972 N143BBeech G35 · S/N D-4410Cancelled Jul 6, 2012 · Registration expired, pending cancellation · Built 1955 · Borgen Arden L N1339QCessna 150L · S/N 15072639Cancelled Jun 21, 2012 · Registration expired, pending cancellation · Built 1971 · Iowa Aviation Inc

Back to Des Moines, IA