Fargo, ND

Cancelled registrations · 189

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 = 'FARGO'
  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.

N2846SCessna 150G · S/N 150-66746Cancelled Feb 1, 1972 · Ski IncN4949UCessna 210 · S/N 210-58649Cancelled May 25, 1971 · Exported to Canada · Currier R LN3491MPiper PA-12 · S/N 12-2084Cancelled Apr 2, 1971 · Exported to Canada · Richard ThurlowN2063GCessna 182A · S/N 51363Cancelled Nov 9, 1970 · Exported to Canada · Kirkham Michael IncN2503VCessna 170 · S/N 18006Cancelled Sep 21, 1970 · Exported to Canada · Built 1948 · Munter Duane DN79294Aeronca L-16A · S/N 47-862ACancelled Aug 19, 1968 · Civil Air Patrol IncN79297Piper J3C-65 · S/N 10037Cancelled Jan 28, 1968 · Civil Air Patrol IncN2418EAeronca 7AC · S/N 7AC-5997Cancelled May 1, 1967 · Exported to Canada · Skroch Edward A JrN6890FCessna 150F · S/N 15063490Cancelled Mar 27, 1967 · Kundert Aviation IncN5948TCessna 150D · S/N 15060648Cancelled Nov 17, 1965 · Kundert Aviation IncN77994Luscombe 8A · S/N 3721Cancelled May 20, 1965 · Allan W NorbyN84859Aeronca 7AC · S/N 7AC-3578Cancelled May 10, 1965 · Arliss Fedje/ Charles MetzrothN5881PPiper PA-24 · S/N 24-966Cancelled Nov 7, 1963 · Kundert Aviation IncN35751Piper J3C-65 · S/N 6589Cancelled Jan 14, 1963 · Exported to Canada · Kundert A JN2079BLuscombe 8A · S/N 6506Cancelled Jul 31, 1961 · Exported to Canada · Nelson Lyle AN88636Piper J3C-65 · S/N 16264Cancelled Jul 18, 1961 · Exported to Canada · Daro AbleidingerN9049KStinson 108-1 · S/N 108-2049Cancelled Nov 14, 1960 · Exported to Canada · Pella ProductsN75196North American SNJ-3 · S/N 78-7279Cancelled Nov 1, 1960 · Air Activities IncN64939Consolidated Vultee BT-13A · S/N 5557Cancelled Oct 2, 1959 · Air Activities IncN79296Aeronca L-16A · S/N 7BCM-78Cancelled Sep 22, 1958 · Civil Air Patrol IncN2106KLuscombe 8A · S/N 4833Cancelled Jul 11, 1958 · Exported to Canada · Dentz Gerald EN3053MPiper PA-12 · S/N 12-1584Cancelled Dec 13, 1957 · Exported to Canada · Skroch-Kundert IncN72772Cessna 140 · S/N 9955Cancelled Mar 16, 1956 · Fargo Flying Club IncN29388Culver LCA · S/N 177Cancelled Mar 5, 1956 · Anderson John MN42168Piper J3C-65 · S/N 14403Cancelled Mar 5, 1956 · Fargo Flying Club IncorporatedN2743HErcoupe 415-C · S/N 3368Cancelled Nov 21, 1955 · Dakota SkywaysN2257HEngineering & Research 415-C · S/N 2882Cancelled Nov 17, 1955 · Built 1946 · Munter JohnN98345Piper J3C-65 · S/N 18515Cancelled Oct 17, 1955 · Built 1946 · Gunkelman R F JrN21833Piper J-3 · S/N 2630Cancelled Sep 19, 1955 · Built 1938 · Skroch-Kundert IncN85669Aeronca 7AC · S/N 7AC-4414Cancelled Jan 5, 1955 · Exported to Canada · Skyroch-Kundert IncN85165Aeronca 7AC · S/N 7AC3897Cancelled Nov 12, 1954 · Built 1946 · Dakota SkywaysN37844Culver LFA · S/N 348Cancelled Oct 24, 1951 · Linberg Eugene HN80279Culver V · S/N V-198Cancelled Apr 10, 1950 · Built 1946 · Dakota SkywaysN34493Aeronca 65-LB · S/N LB14801Cancelled Apr 6, 1950 · Built 1941 · Strand Duane RN80056Culver V · S/N V-97Cancelled Jan 5, 1950 · Built 1946 · Scott Vernon L Dbadakota SkywaysN50193Fairchild M-62A · S/N T-41-626Cancelled Jun 20, 1949 · Air Activities IncN16552Aeronca C-3 · S/N A-693Cancelled Apr 28, 1948 · Parkman James RN99992Ercoupe 415-C · S/N 2615Cancelled May 21, 1947 · Faleide Harry SN1427Central States Aero MONOCOUPE · S/N 7Cancellation date not recorded · Fargo Aeronautic Club Inc
Back to Fargo, ND