Salem, OR

Cancelled registrations · 216

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 = 'OR' AND d.registrant_city = 'SALEM'
  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.

N300BMThomas Dick 300 · S/N PABM1Cancelled Oct 24, 2012 · Triennial form not returned · Thomas DickN24657Beech B19 · S/N MB-569Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1973 · Nguyen VuiN7572ZPiper PA-18-150 · S/N 18-8397Cancelled Sep 6, 2012 · Revoked, canceled · Built 1966 · Van Cleaver AaronN198LLang BG-12L · S/N 098Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1966 · Mccracken Wallace DN998NEngineering & Research ERCOUPE 415-D · S/N 2596Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1946N123MGBeech 58P · S/N TJ-115Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Built 1977 · First Capital Investment IncN93PFHelio H-295 · S/N 1470Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Carson Leasing & Equity IncN1660George LITTLE GEORGE · S/N 8Cancelled Jul 19, 2012 · Sale reported, canceledN183TShear David TITAN TORNADO · S/N T93277SOHK0065Cancelled Jun 12, 2012 · Sale reported, canceledN4005CStinson 108-3 · S/N 108-5005Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1948N298CPArrow Falcon Exporters OH-58A+ · S/N 71-20532Cancelled Feb 6, 2012 · First renewal notice · Built 2007 · Reforestation Services IncN185MECessna A185F · S/N 18503844Cancelled Sep 21, 2011 · Exported to Canada · Built 1979 · Fibermax Oregon IncN94492Hiller UH-12E · S/N 1777Cancelled Jun 17, 2011 · Triennial form not returned · Built 1964 · Industrial Aircraft Co IncN20963Waco YKS-7 · S/N 5235Cancelled May 31, 2011 · Revoked, canceled · Built 1940 · Pacific Mine And Dredge CoN16HBell 47G · S/N 12Cancelled May 24, 2011 · Revoked, canceled · Built 1947 · Richards Daniel E DBAN2093EHiller UH-12D · S/N 956Cancelled May 13, 2011 · Triennial form not returned · Industrial Aviation Services IncN3490PNesbitt Peter B BARNETT J4B2 · S/N 198Cancelled Dec 13, 2010 · Built 1997 · Stuart Mary CN61148Cessna 150J · S/N 15070837Cancelled Aug 25, 2010 · Exported to Mexico · Newby C AN4460WBeech 95-B55 (T42A) · S/N TC-1674Cancelled Dec 22, 2009 · Exported to Brazil · Built 1974 · Brian Wood Enterprises LLCN6138SCessna TR182 · S/N R18201623Cancelled Sep 25, 2009 · Exported to Australia · Built 1980 · Bmi Contractors IncN809Sikorsky S-51 · S/N 51209Cancelled Sep 15, 2009 · Registration revoked · Built 1959 · Mineral Mountain MetalsN1610UElkins James D JD · S/N FAR013Cancelled Jun 30, 2009 · Registration revoked · Built 1965 · Elkins James DN132DLLewis Doyle L NIEUPORT 11 · S/N 008Cancelled Jan 30, 2008 · Triennial form not returned · Built 2002 · Lewis Doyle LN86659Hiller H-23D · S/N 62-3761Cancelled Feb 9, 2007 · Triennial form not returned · Built 1962 · Reforestation Services IncN6982NCessna T210N · S/N 21063191Cancelled Jan 3, 2007 · Exported to Canada · Built 1979 · Barry Dennis CN35FMCessna R182 · S/N R18200406Cancelled Sep 15, 2006 · Exported to Mexico · Built 1978 · Lima Charlie Quebec IncN48001Hiller UH-12E · S/N 1018Cancelled Aug 2, 2006 · Triennial form not returned · Built 1959 · Reforestation Services IncN92502Piper PA 46-350P · S/N 4622170Cancelled Nov 30, 2005 · Exported to Canada · Built 1994 · Ebel Ronald G TrusteeN67827Cessna 152 · S/N 15282042Cancelled Aug 29, 2005 · Exported to El Salvador · Built 1978 · White Star Leasing IncN731LECessna A188B · S/N 18802971TCancelled May 26, 2005 · Exported to Brazil · Built 1977 · Carson Leasing And Equity IncN26327Grumman American Avn. AA-5A · S/N AA5A0535Cancelled May 11, 2005 · Triennial form not returned · Built 1978 · Pacific Flyers IncN900DNBeech A100 · S/N B-170Cancelled Jan 14, 2005 · Exported to Mexico · Built 1973 · Par Avion LLCN8ULAerospatiale AS350B · S/N 1875Cancelled Jun 7, 2004 · Exported to Canada · Built 1986 · Denmark Investments IncN38WCElkins James D LANCAIR 4-P · S/N LIV-028Cancelled Oct 10, 2003 · Exported to Mexico · Built 1995 · Elkins James DN1162URobinson William E SANDPIPER XP-1 · S/N OR831012-12-MBCancelled Aug 20, 2002 · Triennial form not returned · Robinson William EN205GLBell UH-1H · S/N 74-22356Cancelled Apr 19, 2002 · Triennial form not returned · Built 1974 · Grim Logging Company IncN1389BSilvaire LUSCOMBE 8F · S/N 6016Cancelled Mar 18, 2002 · Built 1948 · Burwell William CN508HVHiller UH-12E · S/N 5008Cancelled Jan 19, 2001 · Triennial form not returned · Reforestation Services IncN85PFCessna U206D · S/N U2061421Cancelled Dec 10, 1999 · Exported to Honduras · Carson Leasing & Equity IncN62461Hiller OH-23G · S/N 1549Cancelled May 5, 1999 · Triennial form not returned · Reforestation Services IncN401HAHiller UH-12E · S/N HA4001Cancelled Oct 24, 1997 · Triennial form not returned · Reforestation Services IncN3601DAerostar International S-60A · S/N S60A3119Cancelled Jan 17, 1997 · Triennial form not returned · Balloon Flying Service Of Oregon IncN1122RPiper PA-28-235 · S/N 2810082Cancelled Sep 12, 1995 · Triennial form not returned · American Mchne And Rollform Tech IncN876FRRomig Francis A FRONTRUNNER FR-1 · S/N 001Cancelled Jun 6, 1994 · Romig Francis AN8297MBeech F33A · S/N CE1735Cancelled Aug 13, 1993 · Exported to France · Simon Mathurin AN435BWBeech A36 · S/N E811Cancelled Jun 17, 1993 · Triennial form not returned · Theodorson Robert LN2626NCessna 140 · S/N 12884Cancelled Oct 3, 1984 · Administratively canceled · Mcdowell DavidN6131MStinson 108-3 · S/N 108-4131Cancelled Oct 4, 1983 · Exported to Canada · Sherman Jack GN51321Cessna 150J · S/N 15069922Cancelled Dec 6, 1982 · Larson Arnold MN64247Cessna 180K · S/N 180 52884Cancelled Sep 28, 1982 · Colvin Ralph M Jr
Back to Salem, OR