OpenAirDocs.org
Portland, OR

Cancelled registrations · 944

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 = 'PORTLAND'
  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.

N2478CCessna 180 · S/N 30778Cancelled Jan 31, 1968 · Hanson Robert WN8305DBeech J35 · S/N D-5410Cancelled Jan 31, 1968 · Exported to Canada · Flightcraft IncN34036Taylorcraft BL12-65 · S/N 2887Cancelled Jan 26, 1968 · Built 1941 · O'Keefe JohnN71865Luscombe 8A · S/N 3292Cancelled Jan 17, 1968 · Industrial Leasing CorpN8186SCessna 150 · S/N 150-61786Cancelled Nov 13, 1967 · Executive Flight Services IncN4925PPiper PA-23-235 · S/N 27-517Cancelled Nov 9, 1967 · Air IncN2374WBeech A23-19 · S/N MB-11Cancelled Oct 23, 1967 · Exported to Canada · Oregon Airmotive IncN8214VCessna 180H · S/N 18051716Cancelled Aug 21, 1967 · Exported to Peru · Robert E SeamountN6838QBeech S35 · S/N D-7442Cancelled Aug 18, 1967 · Exported to Canada · Flightcraft IncN8251CPiper PA-18 · S/N 18-3675Cancelled Feb 27, 1967 · Whitehead Ernest GN8787MBeech A23 · S/N M-572Cancelled Jan 6, 1966 · Flightcraft IncN4769ZPiper PA-22-108 · S/N 22-8329Cancelled Oct 29, 1965 · Langston C EN893DUniversal Stinson 108-2 · S/N 108-2893Cancelled Jul 23, 1965 · L W Hembree CoN9436CCessna 180 · S/N 31834Cancelled Jul 14, 1965 · Exported to Zimbabwe · Courtney Thomas C JrN5974VBeech C18S · S/N 8076Cancelled Jul 13, 1965 · Shelley Joseph FN6003MStinson 108-3 · S/N 108-4003Cancelled Jun 25, 1965 · Exported to Canada · Interstate Vehicle Management IncN8435CAero Commander 680-E · S/N 680E-798-55Cancelled Jun 23, 1965 · Exported to Canada · Daly Walter MN3759GGriffiths B-8 · S/N HJG-1Cancelled Jun 5, 1965 · Griffiths Happy JN4327NCessna 195 · S/N 7082Cancelled May 22, 1965 · Stater-Kauffman CoN8133KStinson 108-1 · S/N 1081133Cancelled May 21, 1965 · Simpson J JN8887KStinson 108 · S/N 108-1887Cancelled May 21, 1965 · Pauli Lowell EN40196Stinson 108 · S/N 108-126Cancelled May 20, 1965 · Built 1946 · Branin William BN4134BAero Commander 520 · S/N 38Cancelled May 20, 1965 · Built 1952 · Dallas W KN2383LBeech 23 · S/N M-224Cancelled May 18, 1965 · Exported to Guatemala · Flightcraft IncN682CUniversal Stinson 108-3 · S/N 108-3682Cancelled May 18, 1965 · Built 1947 · Hansen RichardN97562Stinson 108 · S/N 108-562Cancelled Feb 8, 1965 · Northwest PlywoodN10309Lockheed ELECTRA 10-A · S/N 1148Cancelled Oct 21, 1964 · Built 1959 · Flightcraft IncN94430Engineering & Research ERCOUPE 415-D · S/N 5076Cancelled Aug 4, 1964 · Carl R ClymensN4535ZPiper PA-22-108 · S/N 22-8040Cancelled Sep 10, 1963 · Exported to Canada · Holt W WarrensN2140YCessna 172D · S/N 17249640Cancelled Sep 4, 1963 · Exported to Canada · Skyways IncN5617MTaylorcraft BC12D-85 · S/N 12017Cancelled Mar 6, 1963 · Built 1948 · Parsons James OwenN70265Piper J-3 · S/N 17246Cancelled Jun 8, 1962 · Exported to Canada · Built 1956 · Tektronix Employees Flying ClubN4377DBeech E50 · S/N EH-23Cancelled May 1, 1962 · Colyear Motor Sales CoN3992FCessna 172 · S/N 36892Cancelled Jul 31, 1961 · Exported to Canada · Flighteraft IncN1294CPiper PA-18-135 · S/N 18-2506Cancelled Jun 22, 1961 · Exported to Canada · Henry TrohN8238DBeech J35 · S/N D5332Cancelled Mar 23, 1961 · Hiway Ready Mix IncN2518PPiper PA-22-150 · S/N 22-2880Cancelled Mar 1, 1961 · Built 1955 · Mt Hood Flying ClubN2765VBeech 35 · S/N D-156Cancelled Jan 5, 1961 · Church Wilbur E &/Or Eve B ChurchN1062PPiper PA-23 · S/N 23-70Cancelled Dec 23, 1960 · Exported to Canada · Built 1954 · Perkins And Lennington CoN8653DPiper PA-22-160 · S/N 22-5859Cancelled Sep 10, 1960 · Exported to Canada · Willamina Lumber CoN56006Douglas C-54A · S/N 10279Cancelled Jun 27, 1960 · Exported to United Kingdom · General Airways IncN3557BBeech B50 · S/N CH-15Cancelled Jun 15, 1960 · Exported to Canada · Flightcraft IncN8535EChampion 7FC · S/N 7FC-341Cancelled Jun 7, 1960 · Exported to Canada · Flightcraft IncN53791Boeing A75N1 · S/N 75-523Cancelled May 9, 1960 · Exported to Canada · Troh Henry PN53643Cessna T-50 · S/N 6094Cancelled Nov 24, 1959 · Shelley Joseph FN2480NCessna 140 · S/N 12733Cancelled Oct 7, 1959 · Exported to Canada · Flightcraft IncN81076Cessna 120 · S/N 10370Cancelled Oct 7, 1959 · Exported to Canada · Flightcraft IncN522CStinson 108-3 · S/N 108-3522Cancelled Aug 5, 1959 · Exported to Canada · Robert W Knight And Keith D PiercyN3894PPiper PA-18-150 · S/N 18-4727Cancelled Jun 17, 1959 · Exported to Canada · Built 1955 · Trohs Air TaxiN34235Taylorcraft BCS12-D · S/N 7657Cancelled Apr 6, 1959 · Exported to Canada · R L Waterman
Back to Portland, OR