OpenAirDocs.org
Pierre, SD

Cancelled registrations · 60

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 = 'SD' AND d.registrant_city = 'PIERRE'
  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.

N65827Condor SPORT · S/N 704RESCancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2004 · Semmler Ronald EN941SDDJI Innovations INSPIRE 1 · S/N W13DCH19041721Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Lifewrx Media LLCN224SDDJI PHANTOM 2 VISION + · S/N 60601F00E246Cancelled May 7, 2022 · Registration expired, pending cancellation · Lifewrx Media LLCN305SKPiper PA-31-350 · S/N 31-7652039Cancelled Aug 11, 2021 · Exported to Canada · Built 1975 · Alliance Aircraft Sales IncN48009Aeronca 0-58B · S/N O58B3422Cancelled Dec 30, 2019 · Revoked, canceled · Built 1942 · Bastien A JN9638KPiper PA-34-200T · S/N 34-7670212Cancelled Sep 11, 2019 · Second renewal notice · Built 1976 · Aircraft Unlimited IncN650DDCessna 650 · S/N 650-0114Cancelled Mar 19, 2019 · Built 1986 · Helium Aviation LLCN719RBQuad City CHALLENGER II · S/N 125602Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2003N78475Piper PA-12 · S/N 12-1986Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1947 · Ice Cecil GN2471SCessna 337C · S/N 337-0771Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1967 · Capital Airways IncN416Lee Paul SQ 2000 · S/N 0007Cancelled Nov 20, 2013 · Third renewal notice · Lee PaulN95119Piper PA-28-140 · S/N 28-25813Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1969 · Dulitz David EN1598PPiper PA-18 · S/N 18-3763Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1954 · Ice Cecil GN57821Piper PA-36-285 · S/N 36-7660128Cancelled Feb 21, 2013 · Revoked, canceled · Built 1976 · Singleton Spray Service CoN57822Piper PA-36-285 · S/N 36-7660129Cancelled Feb 21, 2013 · Revoked, canceled · Built 1976 · Singleton Spray Service CoN37626Maberry Wayne J & Buell G SCORPION 133 · S/N 01Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Maberry Wayne JN31825Aeronca 65-CA · S/N C-11290Cancelled Sep 6, 2012 · Sale reported, canceled · Built 1940N133JTSchladweiler KR-2 · S/N 878Cancelled Jul 6, 2009 · Registration revoked · Built 1976 · Schladweiler John TN661FBChristen Industries A-1 · S/N 1175Cancelled May 20, 2008 · Triennial form not returned · Built 1991 · State Of South DakotaN8745EPiper PA-32-300 · S/N 32-7640073Cancelled Jun 25, 2007 · Triennial form not returned · Built 1976 · Aircraft Unlimited IncN8537NPiper PA-28-235 · S/N 28-11336Cancelled Dec 12, 2003 · Triennial form not returned · Built 1969 · Cherokee Aero ClubN7208ZPiper PA-25-235 · S/N 25-3119Cancelled Jan 13, 2000 · Exported to Belgium · Ice Cecil GN64356Cessna 172M · S/N 17265188Cancelled Nov 30, 1999 · Exported to Spain · Ice Cecil GN7029NBeech V35A · S/N D8629Cancelled Oct 31, 1995 · Triennial form not returned · Lucas Anthony EN86SDMitsubishi MU-2B-60 · S/N 765SACancelled Jul 14, 1994 · Triennial form not returned · South Dakota State OfN9474PPiper PA-24-260 · S/N 244986Cancelled Jul 25, 1991 · Exported to Canada · Ice Cecil GN734MRCessna 172N · S/N 17268964Cancelled Aug 26, 1986 · Hawk Aviation IncN9510GCessna A188B · S/N 18801509TCancelled Sep 16, 1982 · Administratively canceled · Sss IncN9956PPiper PA-36-320 · S/N 36-7560067Cancelled Apr 15, 1982 · Administratively canceled · Rose A HN91622Cessna 182M · S/N 182-59847Cancelled Mar 26, 1982 · Deve IncN39766Aero Commander S2R · S/N 1423RCancelled Sep 30, 1981 · Built 1973 · Kempf RandallN9643PPiper PA-25-235 · S/N 25-7405819Cancelled Jan 23, 1978 · Exported to Mexico · Ice Cecil GN3423NPiper J3C-65 · S/N 22629Cancelled Jul 11, 1977 · Oahe Implement CoN7326ZPiper PA-25-235 · S/N 25-3275Cancelled May 13, 1977 · Exported to Canada · Robison Charles TN9651JPiper PA-28-180 · S/N 28-3816Cancelled Aug 6, 1976 · Exported to Canada · Ice Cecil GN6913SCessna 150H · S/N 15067613Cancelled Oct 6, 1975 · Schmit Aviation IncN5643GCessna 150K · S/N 15071143Cancelled Oct 3, 1975 · Ganje D David DBA AerofliteN7054GCessna 172K · S/N 17258754Cancelled Feb 27, 1975 · Schmit Aviation IncN7142Cessna 170A · S/N 19986Cancelled Aug 30, 1972 · Exported to Canada · Taylor BrothersN77451Cessna 120 · S/N 11894Cancelled May 9, 1972 · Exported to Canada · Ice Cecil GN82616Aeronca 7AC · S/N 7AC-1256Cancelled Mar 22, 1971 · Alto Flying Club IncN9134RCessna 180 · S/N 50535Cancelled Feb 24, 1971 · Built 1959 · Ice Cecil GN7275HPiper J3C-65 · S/N 20527Cancelled Jun 25, 1970 · Ice CecilN8259CPiper PA-18 105 · S/N 18-3687Cancelled Jun 25, 1970 · Ice Cecil GN6005FBeech 35-C33 · S/N CD-871Cancelled Feb 13, 1970 · Sheehan And O DayN216TPiper PA-18 105 · S/N 18-2330Cancelled Oct 2, 1967 · Exported to Canada · Cecil G IceN91925Piper J3C-65 · S/N 16340Cancelled Apr 4, 1967 · Exported to Canada · Ice Cecil GN99951Erco 415-C · S/N 2574Cancelled Nov 9, 1964 · Exported to Canada · Ice Cecil GN24808Piper J4A · S/N 4-727Cancelled Feb 5, 1964 · Exported to Canada · Built 1939 · Bolyard Harold TN6261CBeech C-45 · S/N 43-35932Cancelled Jan 3, 1963 · State Of South Dakota Civil Defense
Back to Pierre, SD