Corvallis, OR

Cancelled registrations · 126

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

N733VPCessna 172 · S/N 172-68585Cancelled Aug 3, 1977 · Hirte Douglas J & Hirte Lauralee ON8862CPiper PA-22-135 · S/N 22-1493Cancelled Jul 18, 1977 · Corvallis Aero Svc IncN3ZHBell 206B · S/N 1619Cancelled Jul 11, 1977 · Built 1975 · Corvallis Aero Services IncN78791Cessna 172K · S/N 17257762Cancelled Oct 7, 1975 · Exported to Canada · Annis Helen AN9183JPiper PA-28-180 · S/N 28-3251Cancelled Oct 7, 1975 · Starker ForestsN2940TAero Commander 100 · S/N 056Cancelled Jan 29, 1974 · Cook C MichaelN5134WPiper PA-28-160 · S/N 28-163Cancelled Jan 18, 1974 · Exported to Canada · Moore Robert JN2912LMooney M20F · S/N 670306Cancelled May 10, 1972 · Exported to Canada · Corvallis Aero Service IncN2824RPiper PA-28R-200 · S/N 28R-35300Cancelled Apr 10, 1972 · Wilt Stanley W / Western Milling CompanyN4645YPiper PA-18-150 · S/N 18-8946Cancelled Nov 17, 1971 · Exported to Canada · Built 1971 · Turney Burton SN49100Taylorcraft DCO-65 · S/N L-5239Cancelled Apr 30, 1971 · Neil Forrest AN1983YMooney M20E · S/N 270Cancelled Feb 9, 1971 · Boersma H J And Boersma L GN1841KLuscombe 8E · S/N 4568Cancelled Dec 30, 1970 · Built 1946 · Stover Warren HN7635ZPiper PA-25-235 · S/N 25-3767Cancelled Jun 2, 1970 · Built 1966 · Aero Service IncN78889Mooney M20B · S/N 2904Cancelled Jul 31, 1968 · Built 1965 · Chamberlain Howard Emil/Chamberlain Imogene KN1195EAeronca 7AC · S/N 7AC-4752Cancelled Aug 11, 1965 · Corvallis Aero Service IncN7140TCessna 172 · S/N 46740Cancelled Jun 21, 1965 · Sumner John DavidN37461Interstate S-1B1 · S/N 252Cancelled Oct 20, 1955 · Built 1943 · Miller Zalmon KennethN57183Ryan Aeronautical ST3KR · S/N 1435Cancelled Apr 22, 1954 · Smith-Livinston Air Service IncN53309Consolidated Vultee BT-13A · S/N 5118Cancelled Apr 11, 1951 · Built 1941 · Campbell Manfred E / Campbell Martin LN586CStinson 108-3 · S/N 108-3586Cancelled Sep 7, 1950 · H H FaustN37331Interstate S-1A · S/N 174Cancelled Sep 15, 1948 · Smith-Livingston Air Services IncN9029KStinson 108-1 · S/N 108-2029Cancelled Mar 5, 1948 · Smith-Livingston Air ServicesN1111Alexander COMBINATION EAGLEROC · S/N 238Cancelled Oct 10, 1945 · Burchett Darwin VanceN190NChurch & Miller MONOPLANE · S/N 3Cancelled Sep 22, 1933 · Built 1929 · Bicknell RayN6181Swallow C · S/N 995Cancelled Jan 19, 1929 · Oregon Airways
Back to Corvallis, OR