Skip to content

Cancelled registrations · 146

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 = 'ND' AND d.registrant_city = 'MINOT' 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 = 'ND' AND d.registrant_city = 'MINOT'
  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 = 'ND' AND d.registrant_city = 'MINOT'
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.

N409SKBell Helicopter Textron Canada 407 · S/N 54527Cancelled Jun 26, 2025 · Exported to Panama · Built 2014 · Jf Aviation LLC N50TCessna T-50 · S/N 6548Cancelled Aug 30, 2023 · Built 1943 · Dakota Territory Air Museum N18158Cessna 150L · S/N 15073831Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1972 · Aitchison John F N6846WPiper PA-28-140 · S/N 28-20991Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1965 · Ouellette Dillon L N5711WPiper PA-28-150 · S/N 28-1197Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1963 · Nelson Erik N5049GBellanca 7ECA · S/N 1306-79Cancelled Jan 23, 2021 · Expired dealer · Built 1979 · Nelson Aircraft Sales Inc N9893PPiper PA-25-235 · S/N 25-7556200Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1975 · Brekhus Henry H N715YTDJI PHANTOM 3 ADVANCED · S/N P76DCJ23A20801Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Taney Engineering Inc N8182XCessna 172B · S/N 17248682Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 1961 · Affinity Homes Inc N98655Piper J3C-65 · S/N 18876Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1946 · Behrens Jeffrey R N4049ZPiper PA-18-150 · S/N 18-8016Cancelled Apr 5, 2018 · Revoked, canceled · Built 1963 · Howard Robert L N949MEKolb FIRESTAR · S/N 003Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1985 · Hartung James L N874RBeech 35-33 · S/N CD-30Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1959 · Carter Steven J N56948Enstrom F-28C · S/N 501-2Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1980 · Mouse River Helicopters Inc N8807KEagle EAGLE DW-1 · S/N DW-1-0048-81Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Lucke Eva A N8815DEagle EAGLE DW-1 · S/N DW-1-0092-82Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1982 · Lucke Eva A N4504QCessna 402A · S/N 402A0004Cancelled Jun 8, 2017 · Registration expired, pending cancellation · Built 1968 · Don Bessette Aviation Inc N2851FAero Commander CALLAIR A-9B · S/N 1367Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1968 · Pietsch Alfred C DBA N84512Piper PA-28-161 · S/N 28-8216038Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1981 · Scott Wilson A DBA N1366WMooney M20C · S/N 2647Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1963 · Pietsch Flg Svc N7283VAero Commander CALLAIR B-1A · S/N 10025Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1967 N3087ZGarnant Even CA-65 · S/N 1Cancelled Jul 29, 2013 · Sale reported, canceled N94360Ercoupe 415-C · S/N 1583Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Dakota Territory Air Museum Inc N9026TBrown Lee M TATERBUG SB-1 · S/N 1932Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1983 · Steenstrup Harry R N7769VAero Commander CALLAIR A-9B · S/N 1526Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Pietsch Alfred C DBA N6906ZPiper PA-25-235 · S/N 25-2646Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1964 · Lucke E Stewart Jr DBA N6639ZPiper PA-25-235 · S/N 25-2234Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1963 · Kuehn Jon E N4986GRiemers-Roland WEEDHOPPER · S/N 0028Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1979 · Riemers Roland C DBA N5975VCherokee II HOME BUILT · S/N DB-1Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1969 N4029EAeronca 11BC · S/N 11BC-117Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1947 · Grina Gregg S N8876CPiper PA-22-135 · S/N 22-1487Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1953 N2383Eaa Chapter 265 Of Minot BREEZY RL-1 · S/N 265-74-1Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1969 · Experimental Aircraft Assoc N3801Great Lakes HOMEBUILT · S/N 6612J316Cancelled Aug 17, 2012 · Sale reported, pending cancellation · Built 1968 N39215Taylorcraft BC12-D · S/N 6469Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1945 N9708PPiper PA-25-235 · S/N 25-7556024Cancelled Sep 18, 2009 · Registration revoked · Built 1974 · Aero Flight Inc N96624Taylorcraft BC12-D · S/N 8924Cancelled Sep 17, 2009 · Registration revoked · Built 1946 · Carter S G Jack N28953Engineering & Research ERCOUPE 415-C · S/N 49Cancelled Jul 23, 2009 · Registration revoked · Built 1941 · Larson Clifford E N9357LAmerican AA-1A · S/N AA1A0057Cancelled Mar 19, 2009 · Exported to Canada · Built 1971 · Dakota Territory Air Museum Inc N8720LPiper PA-25-260 · S/N 25-5176Cancelled Jun 12, 2008 · Exported to Uruguay · Built 1969 · Lucke Eva A DBA N421RCessna 421C · S/N 421C0143Cancelled Aug 11, 2006 · Exported to Canada · Built 1976 · Flying Too LLC N41371Piper PA-28-151 · S/N 28-7415188Cancelled Jun 29, 2006 · Triennial form not returned · Built 1974 · Pietsch N304WCHughes TH-55A · S/N 67-16900Cancelled Feb 11, 2000 · Triennial form not returned · Ward County Weed Board N8139DHughes TH-55 · S/N 67-16923Cancelled Feb 7, 2000 · Triennial form not returned · Ward County Weed Board N1368ZBeech N35 · S/N D-6789Cancelled Jan 21, 2000 · Triennial form not returned · Gowan David C N5459UBeech V35 · S/N D8541Cancelled Oct 31, 1998 · Bonanza Partners N5030NBellanca 8KCAB · S/N 45779Cancelled Mar 17, 1998 · Exported to Canada · Epstein Irwin J N43JCAerotek PITTS S-2A · S/N 2019Cancelled Feb 17, 1998 · Exported to Canada · Pietsch Warren A N30912Korslein Vern TERATORN TIERRA II · S/N 081958Cancelled Feb 18, 1997 · Triennial form not returned · Meisel Paul L N85115Piper PA-31-350 · S/N 317405182Cancelled Apr 9, 1996 · Lwcr Transportation Inc N2920LMooney M20F · S/N 670314Cancelled Jul 25, 1994 · Second triennial mailing, no response · Fischer Richard C

Back to Minot, ND