OpenAirDocs.org
Blackfoot, ID

Cancelled registrations · 50

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 = 'ID' AND d.registrant_city = 'BLACKFOOT'
  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.

N792ASEa Vision EA J100 · S/N EAVUAV502585796Cancelled Jul 11, 2026 · Sale reported, canceledN93345Engineering & Research ERCOUPE 415-C · S/N 668Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Brooke Glenn DN597Beech 35 · S/N D-321Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1947 · Preston Earl BN8640ABeech A35 · S/N D2050Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1949 · Preston Earl BN4881ZPiper PA-22-108 · S/N 22-8462Cancelled Nov 18, 2017 · Revoked, canceled · Built 1961 · Air Spray IncN7468KJohns Gary RANS S-10 SAKOTA · S/N 0996178Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Johns GaryN7589CCallair A-4 · S/N 194Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Thompson Randall PN7225LPiper PA-25-235 · S/N 25-7405585Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1974 · Novas Don HN6946XCessna 172B · S/N 17247846Cancelled Sep 3, 2014 · Revoked, canceled · Built 1960 · Cushman DougN7283ZPiper PA-25-235 · S/N 25-3224Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1965 · Blackfoot Flying Service IncN7826PPiper PA-24-250 · S/N 24-3046Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1962 · Novas Don HN7694ZPiper PA-25-235 · S/N 25-3852Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1966 · Novas Don HN4289ABeech C18S · S/N 6492Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1949 · Novas Don HN13815Stinson JR. SR · S/N 8767Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1933 · Novas Don HN4488YPiper PA-25-235 · S/N 25-4151Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1966 · Novas Don HN7165ALeffler David R SONERAI II L · S/N 01331LCancelled Oct 16, 2012 · Registration expired, pending cancellation · Leffler David RN14GPitts Special PITTS BG · S/N 3Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1968 · Novas Don HN46761Piper PA-18-135 · S/N 18-3917Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1954N8174GButler Ronald S KITFOX · S/N 381Cancelled Dec 23, 2009 · Exported to Canada · Built 1994 · Clapp Jon LeviN28371Cessna UC-78 · S/N 6423Cancelled Jul 21, 2009 · Registration revoked · Built 1943 · Henderson CarlN2938BPiper PA-28-181 · S/N 28-7990569Cancelled Mar 8, 2000 · Triennial form not returned · Western Aviation IncN8553LPiper PA-25-235 · S/N 25-4973Cancelled Feb 25, 2000 · Triennial form not returned · Western Aviation IncN9621PPiper PA-25-260 · S/N 25-7405784Cancelled Jan 24, 2000 · Triennial form not returned · Galbraith RalphN8765WWixom Steven RANS S-7 · S/N 1293125Cancelled Jun 25, 1998 · Exported to Canada · Wixom StevenN93336Cessna T210L · S/N 21060366Cancelled Nov 2, 1994 · Second triennial mailing, no response · Ramsthaler Jack HN9052HNapper Paul R EVANS VP-1 · S/N V2411Cancelled Apr 11, 1991 · Triennial form not returned · Napper Paul RN20776Piper PA-28-181 · S/N 28-7990024Cancelled Jul 3, 1984 · Administratively canceled · Western Aviaton IncN1172PPiper PA-23 · S/N 23186Cancelled Apr 16, 1984 · Administratively canceled · Anderson Russell WN7368XCessna 150B · S/N 15059468Cancelled Mar 31, 1982 · Watson John BN24755Cessna 152 · S/N 15280357Cancelled Aug 1, 1980 · Built 1977 · Hill Benjamin FN1333YCessna 172C · S/N 17249033Cancelled Jul 16, 1980 · Built 1961 · Anderson Kurt DN4047JCessna 150G · S/N 15065347Cancelled Jul 6, 1977 · Western Aviation IncN4306PPiper PA-23-160 · S/N 23-1807Cancelled Nov 29, 1976 · Bair Ronald HN9191DPiper PA-22-160 · S/N 22-6249Cancelled Jul 17, 1973 · Exported to Canada · Hales George GN95550Taylorcraft BC12-D · S/N 7850Cancelled Nov 20, 1972 · Exported to Canada · Crosswinds Flying Club Inc C/O Paul JorgensenN36328Taylorcraft BC12-D · S/N 6408Cancelled Aug 17, 1971 · Built 1946 · Olsen Geo HN5267WPiper PA-28 · S/N 28-313Cancelled Jan 22, 1971 · Mccarley L G DBA Blackfoot Flying ServiceN3381ZPiper PA-18A 150 · S/N 18-7263Cancelled Jan 20, 1971 · Built 1960 · Mccarley L GN5787PPiper PA-24-250 · S/N 24-866Cancelled Jun 26, 1970 · Blackfoot Flying ClubN5427YPiper PA-23-250 · S/N 272505Cancelled Apr 22, 1968 · Blackfoot Flying ServiceN7210VCallair A-9 · S/N 1247Cancelled Nov 13, 1967 · Novas Don HN9927DPiper PA-18A 150 · S/N 18-6973Cancelled Nov 29, 1963 · Mccarley L GN49060Aeronca 0-58B · S/N 058B-10273Cancelled Oct 28, 1960 · Hansen A E & Drazich B FN1807NCessna 120 · S/N 12051Cancelled Sep 26, 1960 · Stander Jess MN3398BPiper PA-18A-135 · S/N 18-3386Cancelled Sep 23, 1955 · Hansen V CN53343Beech D17S · S/N 6934Cancelled Jun 30, 1950 · Built 1944 · Hansen Vern CN47958Fairchild M-62A · S/N T41-804Cancelled Jun 1, 1949 · Mccarley L GN22967Piper J4A · S/N 526Cancelled May 25, 1948 · R G CappsN2578Standard J-1 · S/N A-880Cancelled Mar 10, 1948 · Bills J NN8380Eaglerock A-3 · S/N 609Cancelled Jul 1, 1938 · Grieve Floyd
Back to Blackfoot, ID