Skip to content

Devils Lake, ND

Cancelled registrations · 37

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 = 'DEVILS LAKE' 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 = 'DEVILS LAKE'
  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 = 'DEVILS LAKE'
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.

N34459Aeronca 65-LB · S/N L14741Cancelled Jul 17, 2020 · Sale reported, canceled N8194TCessna 175B · S/N 17556894Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Schlieve Terry T N5072NSix Chuter SR7 XL · S/N SR7XL-2495Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2000 · Kvelstad Korey R N4650WWeatherly 620A · S/N 1539Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1992 · Foss & Meier Flight Service N2031JCessna T188C · S/N T18803336TCancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1978 · Moore Glen E N75089Piper PA-32R-300 · S/N 32R-7680255Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Buchanan James F N6301RPiper PA-28-140 · S/N 28-21464Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Ness Dan Paul N7444PPiper PA-24-250 · S/N 24-2633Cancelled May 14, 2015 · Sale reported, canceled · Built 1961 N8603ZBuckeye Industries EAGLE · S/N 3137Cancelled Aug 29, 2013 · Sale reported, canceled · Built 1994 N8727LPiper PA-25-260 · S/N 25-5186Cancelled May 20, 2013 · Registration expired, pending cancellation · Built 1969 · Dakota Aircraft Service N437SNorth American SNJ-5 · S/N 88-15738Cancelled Jan 11, 2013 · Registration pending, pending cancellation · Built 1958 N2317PPiper PA-22-150 · S/N 22-2728Cancelled Jul 13, 2009 · Registration revoked · Built 1955 · Lake Region Flg Club Inc N4999RCessna A188B · S/N 18802486TCancelled Feb 3, 2006 · Revoked by enforcement action · Built 1975 N11024Champion 7ECA · S/N 4Cancelled Mar 26, 1991 · Triennial form not returned · Baker Jack E N70426Cessna A188B · S/N 18801919TCancelled Jan 29, 1991 · Triennial form not returned · Wakefield Tom J N5715UPiper PA-28-140 · S/N 28-26515Cancelled Nov 19, 1984 · Exported to Canada · Parkin Harold N2172JCessna A188B · S/N 18803409TCancelled Jan 19, 1982 · Built 1979 · Wakefield Daniel L Et Al N72108Cessna 140 · S/N 9273Cancelled Aug 30, 1974 · Wakefield Thomas N3759RCessna 172H · S/N 17255559Cancelled Apr 11, 1974 · Exported to Canada · Wakefield Daniel L N6187DPiper PA-18A · S/N 18-5476Cancelled Apr 4, 1973 · Exported to Canada · Meier Michael N3684PPiper PA-18 · S/N 18-4585Cancelled Aug 5, 1970 · Exported to Canada · Ron J Miller N9435BCessna 175 · S/N 55235Cancelled Jun 25, 1970 · Wakefield Daniel L N7787DPiper PA-18 · S/N 18-6779Cancelled Jun 22, 1970 · Wakefield Daniel L N79295Piper J3C-65 · S/N 13405Cancelled Apr 17, 1970 · Exported to Canada · Wakefield Thomas J N1721EAeronca 7AC · S/N 7AC-5286Cancelled Oct 22, 1965 · Larson Glenn H N1082APiper PA-18-125 · S/N 18-668Cancelled May 18, 1965 · Wakefield Flight Service N4374EAeronca 7DC · S/N 7DC-33Cancelled Nov 28, 1961 · Lake Region Flying Service Inc N3364APiper PA-22-135 · S/N 22-1663Cancelled Apr 28, 1961 · Wayne Riggen N86854Bellanca 14-13 · S/N 1216Cancelled Apr 19, 1961 · Toomey G W N4675MPiper PA-11 · S/N 11-183Cancelled Jun 15, 1960 · Exported to Canada · Built 1947 · Wakefield Daniel L N2110APiper PA-18-135 · S/N 18-1840Cancelled Jun 26, 1959 · Exported to Canada · Wakerfield Daniel L N5012MTaylorcraft BC12-D · S/N 10312Cancelled Sep 17, 1958 · Exported to Canada · Wakefield Daniel L N94609Ercoupe 415-CD · S/N 4710Cancelled Feb 27, 1956 · Built 1947 · Sihler W F Dr N99567Ercoupe 415-C · S/N 2190Cancelled Oct 13, 1955 · Built 1946 · Christie Edward Lionel N6046MStinson 108-3 · S/N 108-4046Cancelled Jul 27, 1951 · Exported to Canada · Built 1947 · Lake Region Flying Service Inc N16422Monocoupe 90A · S/N A-749Cancelled Apr 26, 1948 · Built 1937 · Toomey Glenn N699VCurtiss Wright JR CW1 · S/N 1081Cancelled Feb 22, 1940 · Arneson Charles Obert

Back to Devils Lake, ND