OpenAirDocs.org
Williston, ND

Cancelled registrations · 61

Query with SQL
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 = 'WILLISTON'
  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.

N653CPPelto Carey KITFOX III · S/N 853Cancelled Oct 21, 2023 · Sale reported, canceled · Built 1990N6286QCessna 152 · S/N 15285220Cancelled Oct 12, 2022 · Sale reported, canceled · Built 1981N43RHBeech V35A · S/N D-8875Cancelled Nov 10, 2021 · Built 1968 · Ritter Thomas TN419BDDentz Steven A JUST A/C HIGHLANDER · S/N JA181-12-08Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2010 · Scarborough Justin RN46630Enstrom 280FX · S/N 2036Cancelled Aug 19, 2021 · Exported to Canada · Built 1989 · Aero Spraying Service IncN6615MStinson 108-3 · S/N 108-4615Cancelled Dec 27, 2019 · Sale reported, canceled · Built 1948N73777Rathbun Jay H COZY · S/N 2Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1995 · Reising Palmer CN8962WPiper PA-28-235 · S/N 28-10538Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1964 · Hotshot Welding & Rental Services IncN8786TCessna 182C · S/N 52686Cancelled Jan 7, 2019 · Registration pending, canceledN8001XCessna 172B · S/N 17248501Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1961 · Vestal Richard LeeN85AYBrumbaugh B/Kasowski L AVID FLYER IV · S/N 984Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1994 · Malott David BN7377KPiper PA-20 · S/N 20-286Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1950 · Flying H Of Williston IncN1029CHayden Morris 2/3 REP CURTIS P-40 · S/N 66-04-1-WNDCancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1980 · Hayden Morris SN41MKBeech A36 · S/N E-662Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1975 · Bonanza Air IncN77094Cessna 140 · S/N 11552Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Gunderson Gilbert CN704APCessna 150M · S/N 15078461Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1976 · Malone W AN8797VBellanca 17-30A · S/N 30365Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1971N4475BWings Ultralights ROTEC RALLY 3 · S/N 12821Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1982 · Heiser George L DBAN40325Maule M-4-220C · S/N 2100CCancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1972 · Red River Mud Co IncN4996QCessna A188B · S/N 18802730TCancelled Dec 14, 2005 · Exported to Argentina · Built 1976 · Aero Spraying Service IncN9290RCessna A188B · S/N 18802216TCancelled Sep 15, 2004 · Exported to Brazil · Built 1975 · Held GeneN3679XAero Commander S2R · S/N 1900RCancelled Dec 22, 1999 · Exported to Canada · Aero Spraying Service IncN7713QCessna T310Q · S/N 310Q0213Cancelled Aug 7, 1996 · Murphy Motors IncN6131PCessna P210N · S/N P21000144Cancelled Sep 26, 1995 · Exported to Canada · Prairchem IncN36NCBeech 36 · S/N E144Cancelled Dec 17, 1993 · Exported to Canada · Skynorth Aviation LtdN6844NMooney M-20G · S/N 680115Cancelled Jan 25, 1983 · Jorgensen William SN7377XCessna R182 · S/N R18200091Cancelled Jun 10, 1981 · Exported to Canada · Breum EddieN2347PPiper PA-22-150 · S/N 22-2758Cancelled Mar 14, 1979 · Exported to Canada · Flying 21 IncN9380DPiper PA-18-150 · S/N 18-6647Cancelled Jul 25, 1977 · Exported to Canada · Palmer Industries IncN9067Aero Commander 100-180 · S/N 5032Cancelled Aug 2, 1973 · Exported to Canada · Flying 21 IncN2341YCessna 177 · S/N 17700141Cancelled Jan 26, 1973 · Exported to Canada · Hall Ivan W SrN5560QMooney M20E · S/N 633Cancelled Nov 19, 1972 · Exported to Canada · Flying 21 IncN30737Piper J3C-65 · S/N 5075Cancelled Dec 19, 1970 · Charles H VizinaN1136KLuscombe 8A · S/N 3863Cancelled Sep 3, 1970 · Varner ConradN3590NMooney M20F · S/N 680107Cancelled Mar 19, 1969 · Built 1967 · Daniels Jack KN7332BBeech E35 · S/N D-3795Cancelled Jun 21, 1968 · Exported to Canada · Varner ConradN8277WPiper PA-28-180 · S/N 28-2433Cancelled May 31, 1968 · Exported to Canada · Built 1965 · Maas J HN95636Taylorcraft BC12-D · S/N 7936Cancelled May 21, 1965 · Jacobsen Ruvold EN8435DPiper PA-22 · S/N 22-5690Cancelled Oct 30, 1963 · Exported to Canada · Aero Spraying Service IncN42714Piper J3C-65 · S/N 15012Cancelled Dec 4, 1961 · Aero Spraying Service IncN2877ZPiper PA-18-A150RESTD · S/N 18-7040Cancelled Aug 17, 1959 · Exported to Canada · Northern Flying ServiceN30463Piper J3C-65 · S/N 4848Cancelled Mar 19, 1959 · Exported to Canada · Built 1940 · Wright Flying ServiceN84827Aeronca 7AC · S/N 7AC-3544Cancelled Mar 19, 1956 · Alvin BratlienN39685Fairchild M-62A-3 · S/N FV-107Cancelled Feb 28, 1956 · Built 1943 · Stockman W H DBA Stockman Flying ServiceN3783MPiper PA-12 · S/N 12-2713Cancelled Feb 14, 1956 · Les PangerN51300Fairchild M-62A · S/N T41-436Cancelled Jan 31, 1956 · H G OnstadN23435Piper J3F-50 · S/N 3172Cancelled Aug 11, 1955 · Built 1939 · Morehouse Dean RN50186Fairchild M-62A · S/N T42-3456Cancelled Mar 30, 1955 · Michae Allen MahannaN3266EAeronca 11AC · S/N 11AC-1641Cancelled Sep 2, 1953 · Exported to Canada · Built 1947 · Stevens James EN84477Aeronca 7AC · S/N 7AC-3176Cancelled Jan 7, 1953 · Scott Wilbert M
Back to Williston, ND