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.

N39499Piper PA-28-161 · S/N 28-7816665Cancelled Jul 23, 1982 · Built 1978 · Val-Airways IncN8339MCessna A150K · S/N A15000039Cancelled Jul 17, 1982 · Reynolds Lesley C JrN735PZCessna 182Q · S/N 18265589Cancelled Jan 4, 1982 · Salem Concrete Pipe CoN7012VMooney M20F · S/N 22-1364Cancelled Oct 15, 1981 · Jagger LarryN80169Cessna A185F · S/N 18503100Cancelled Oct 13, 1981 · Sills Investment CoN320BGCessna 320A · S/N 320A0013Cancelled May 5, 1981 · Exported to Canada · Built 1963 · Mel Lambert MotorsN80918Globe GC-1B · S/N 1111Cancelled Mar 3, 1980 · Farries J RN161GRockwell International 690A · S/N 11296Cancelled Feb 29, 1980 · Exported to Colombia · Built 1976 · Hilltop Developers IncN5688QMooney M20E · S/N 700Cancelled Jun 18, 1979 · Exported to Canada · Meunier Roger PN1614UMclauchlan GYRO COPTER · S/N 100Cancelled Apr 5, 1979 · Mclauchlan Robert DN30059MC Fall Rowe MR1 · S/N A-1Cancelled Nov 8, 1977 · Built 1967 · Eyerly Harry LN73382Cessna 172M · S/N 17267415Cancelled Sep 1, 1977 · Administratively canceled · Colvin Ralph M JrN2019JChampion 7GCB · S/N 7GCB-99Cancelled Jul 27, 1977 · Exported to Canada · Eoff I JosephN7470LPiper PA-18-150 · S/N 18-7509066Cancelled May 11, 1976 · Exported to Canada · Salem Aviation IncN9957VCessna 172M · S/N 17264575Cancelled Dec 24, 1975 · Exported to Canada · Built 1974 · Salem Aviation IncN7349QCessna 182P · S/N 18260989Cancelled Sep 23, 1975 · Exported to Canada · Salem Aviation IncN19072Cessna 150L · S/N 15074143Cancelled Sep 8, 1975 · Exported to Canada · Built 1972 · Salem Aviation IncN6250MStinson 108-3 · S/N 108-4250Cancelled Feb 25, 1975 · Exported to Canada · Frees James PenlN93003Seals James CHALLENGER II (2) · S/N 63-10Cancelled Jul 24, 1974 · Vaughn Kenneth RN34601Cessna 177B · S/N 17701893Cancelled May 15, 1974 · Salem Aviation IncN18153Cessna 150L · S/N 15073826Cancelled Apr 22, 1974 · Built 1972 · Salem Aviation IncN9741CHiller UH-12E · S/N 2115Cancelled Mar 12, 1974 · Reforestation Services IncN8817HNorth American NAVION A · S/N NAV-4-817Cancelled Feb 27, 1974 · Exported to Canada · Mootry KeithN56236Boeing A75 · S/N 75291Cancelled Jun 25, 1973 · Harchenko Jerral DN4393Hauptman GYROCOPTER · S/N TH-1Cancelled Nov 15, 1972 · Built 1971 · Hauptman Thomas LN7135SCessna 150H · S/N 15067835Cancelled Jan 31, 1972 · Salem Aviation IncN74115Bensen B-8M · S/N NWSP-101Cancelled Nov 29, 1971 · Northwest Sports Planes IncN3837JCessna 150G · S/N 15065137Cancelled Oct 14, 1971 · Salem Aviation IncN6025Helio H-391B · S/N 77Cancelled May 27, 1971 · Exported to Canada · Adams Daniel DN1036MHoward DGA-15P · S/N 810Cancelled May 14, 1971 · Exported to Canada · Built 1943 · Hanson Herman RN1462WBell 206A · S/N 368Cancelled Mar 16, 1971 · Built 1969 · Jacobs Locke JrN4939VConsolidated PBY-5A · S/N Y34047Cancelled Jan 19, 1971 · Demers Leo JohnN93009Gyrocopter GB-GYRO · S/N GB-1Cancelled Jan 12, 1971 · George R BarrN5454FMooney A-2A · S/N B254Cancelled Aug 17, 1970 · Exported to Canada · Shelton Roy LN8561CPiper PA-18A · S/N 18-2715Cancelled Jun 11, 1970 · George F KreitzbergN4940ZPiper PA-22-108 · S/N 22-8533Cancelled Jun 13, 1968 · Built 1961 · Salem Aviation IncN6049WPiper PA-28-140 · S/N 28-20049Cancelled Mar 18, 1968 · Exported to Canada · Salem Aviation IncN9181EAeronca 11AC · S/N 11AC814Cancelled May 25, 1965 · Built 1946 · Brandt Henry LN9793RBeech M35 · S/N D-6302Cancelled Sep 10, 1964 · Eoff Electric Co IncN7374ECessna 210 · S/N 57074Cancelled Jul 31, 1964 · Exported to Canada · Page EmersonN6498TCessna 150 · S/N 17898Cancelled Nov 8, 1963 · Kreitzberg Aviation Sales Co IncN9945DPiper PA-18A 150 · S/N 18-7001Cancelled Jul 19, 1963 · State Of OregonN2888ACessna 180 · S/N 30088Cancelled Mar 21, 1962 · Exported to Mexico · Byers Cecil LN52406Vultee/Reed Ron BT-13A · S/N 2328Cancelled Dec 7, 1959 · Built 1946 · Kreitzberg George FN62176Consolidated Vultee BT-13A · S/N 2974Cancelled Dec 7, 1959 · George F KreitzbergN79112Corcoran TG-1A · S/N B2-23Cancelled Sep 29, 1959 · Exported to Canada · Santee Donald FN7945HPiper PA-12 · S/N 12849Cancelled Dec 18, 1957 · Exported to Mexico · Byers Cecil LN4183Mooney M-18C 55 · S/N 348Cancelled Jul 11, 1957 · Kreitzberg George FN66625Consolidated Vultee BT-13A · S/N 6431Cancelled Mar 14, 1956 · Built 1942 · Demers Leo JohnN58642Consolidated Vultee BT-13A · S/N 8887Cancelled Mar 8, 1956 · Jay D Whiteford
Back to Salem, OR