OpenAirDocs.org
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.

N963TBeech 35-33 · S/N CD-162Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1960 · Newby C AN86933Bellanca 14-13 · S/N 1295Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Roberts Philip MN5725NRaven S-60A · S/N S60A-167Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1981 · D R And R IncN5717XRaven Industries RALLY RX7 · S/N RX7-246Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1981 · Balloon Flying Service Of OregonN47246Sikorsky S-58JT · S/N 58-960Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1958 · Pacific Helicopters IncN2077WHutchison Gil F VARIEZE · S/N 00245Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1990 · Hutchison Gil FN9182YAerostar International RX-9 · S/N RX9-3004Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Balloon Flying Service Of OregonN7076YJessup Stan M EXEC 90 · S/N 5233Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Jessup Stan MN86PFCessna 310Q · S/N 310Q0642Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Carson Leasing & Equity IncN4430BHelio H-391B · S/N 014Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Carson Leasing And Equity IncN7981JBell 206A · S/N 693Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1971 · Carson Leasing And Equity IncN602RAHiller UH-12J3 · S/N 1459Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1963 · Carson Leasing And Equity IncN44298Helio H-395A · S/N 515Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Carson Leasing And Equity IncN9721Chamberlin FLY BABY 1A · S/N TMC1Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1973 · Mckinley William VN582HSSikorsky S-58 · S/N S58-061Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Helicopter Services IncN585HSSikorsky S-58 · S/N 581745Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Helicopter Services IncN586HSSikorsky S-58 · S/N 58128Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Helicopter Services IncN587HSSikorsky S-58 · S/N 58-451DCancelled Sep 12, 2013 · Registration expired, pending cancellation · Helicopter Services IncN811NPBartle NIEUPORT 11 · S/N 1229-7Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2004N45PGlobe GC-1B · S/N 1157Cancelled Aug 28, 2013 · Sale reported, canceledN2730CCessna 170B · S/N 26274Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1954N20TTSchleicher ASW-20 · S/N 20012Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1977N204FFBell UH-1P · S/N 63-13161Cancelled Aug 19, 2013 · Sale reported, canceledN48DTThomas Richard TR-1 · S/N 001Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Thomas Richard LN31418Aeronca 65-LB · S/N LB10620Cancelled Aug 2, 2013 · Third renewal notice · Built 1940 · Smith Delbert RN212ACBell UH-1F · S/N 65-7918Cancelled Jul 11, 2013 · Sale reported, canceledN244FBell UH-1F · S/N 66-1220Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1967N75355Globe GC-1B · S/N 2294Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1948N583HSSikorsky S-58 · S/N S58-226Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Helicopter Services IncN584HSSikorsky S-58 · S/N S58-841Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Helicopter Services IncN4246Aerospatiale SE3160 ALOUETTE III · S/N 1884Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1971 · Carson Leasing And Equity IncN4420VNau/Curtis AVID FLYER · S/N 14Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1984 · Trembly Jeff LN4214LSikorsky S-58 · S/N 58008Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Helicopter Services IncN8191QCessna A185F · S/N 18503635Cancelled May 30, 2013 · Exported to Canada · Built 1978 · Sea & Sky Holding IncN94519Hiller UH-12E · S/N 2043Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1960 · Carson Leasing And Equity IncN865BMooney M20 · S/N 1027Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1956 · Eaton Glenn A JrN738QTCessna 172N · S/N 17270161Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Gkw Flights LLCN6532GCessna A188B · S/N 18801203TCancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1973 · Carson Leasing And Equity IncN1143LMorton John W CHRISTAVIA M 1 · S/N 2Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1998N5510GHelio HT-295 · S/N 1253Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1967 · Carson Leasing And Equity IncN5672WPiper PA-28-160 · S/N 28-874Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Simms Harold HN542HAHiller UH-12E · S/N 5042Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1978 · Carson Leasing And Equity IncN54776Boeing A75N1(PT17) · S/N 75-3741Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1942 · 310 LtdN276KABell 206B · S/N 1949Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1976 · Carson Leasing And Equity IncN4101DHelio H-391B · S/N 016Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1955 · Carson Leasing And Equity IncN45215Cessna 150M · S/N 15076788Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1975N8971Ballou BA2 · S/N 701Cancelled Feb 27, 2013 · Sale reported, pending cancellation · Built 1971N1169JColumbia Aircraft Mfg LC41-550FG · S/N 41730Cancelled Dec 31, 2012 · Exported to Australia · Built 2007 · Big Sky Consulting & Investments LLCN7045CBell UH-1F · S/N 65-7948Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Carson Leasing & Equity IncN4075BOggs ROTOCRAFT · S/N C-1Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1966
Back to Salem, OR