OpenAirDocs.org
Eugene, OR

Cancelled registrations · 254

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

N81659Aeronca 7AC · S/N 7AC-279Cancelled Oct 3, 1973 · Built 1945 · Warren Julian GN432FHFairchild Hiller FH-1100 · S/N 125Cancelled Jun 22, 1973 · Bohemia Lumber Co IncN2690LCessna 172H · S/N 17255890Cancelled Jun 5, 1973 · Exported to Canada · Eugene Aircraft Sales & Services IncN8373KStinson 108-1 · S/N 108-1373Cancelled Mar 16, 1971 · Canfield John RN5170ACessna 172 · S/N 28170Cancelled Feb 25, 1971 · Exported to Canada · Eugene Aviation IncN8504YPiper PA-30 · S/N 30-1663Cancelled Jan 29, 1971 · Eugene Aviation IncN8756FHughes 269A · S/N 52-0079Cancelled Jan 4, 1971 · Henderson Aviation CoN7133RPiper PA-28-140 · S/N 28-21834Cancelled Dec 7, 1970 · Built 1966 · Gordon Douglas BN3937PPiper PA-22-150 · S/N 22-3612Cancelled Jun 29, 1970 · Smith SylvanusN3826KTemco GC-1B · S/N 3515Cancelled Jun 8, 1970 · Lee Raymond CN5251HPiper PA-16 · S/N 16-55Cancelled May 15, 1970 · Exported to Canada · Barry EllenN9309YBeech 95-55 · S/N TC-7Cancelled Aug 19, 1968 · Smith SylvanusN963DStinson 108-2 · S/N 108-2963Cancelled Jan 31, 1968 · Richard K WoodwardN74629Beech AT-11 · S/N 1448Cancelled Aug 2, 1967 · Holst Arthur PN3167YCessna 182E · S/N 18254167Cancelled May 4, 1966 · Millett Jr G W & Elvira H MillettN5485DBeech H35 · S/N D-5004Cancelled Dec 1, 1965 · David E WhislerN6825QBeech S35 · S/N D-7448Cancelled Aug 24, 1965 · Green Flying ServiceN823APiper PA-22 · S/N 22-172Cancelled May 18, 1965 · Scofield Chiropractic OfficesN3257ZPiper PA-22-150 · S/N 22-7206Cancelled Sep 2, 1964 · Thomson T C & George Robert ThomsonN99968Engineering & Research 415-C · S/N 2591Cancelled Jan 6, 1960 · Rhoads Paul EN3299VBeech 35 · S/N D-751Cancelled Mar 31, 1958 · Albert Wik & Son & Parry P WatsonN56169Consolidated Vultee BT-13A · S/N 11398Cancelled Jun 17, 1957 · Holst ArthurN58674Consolidated Vultee BT-13A · S/N 10178Cancelled Mar 8, 1956 · William Joseph Daniel JrN58829Fairchild M-62A-3 · S/N FW 896Cancelled Mar 5, 1956 · John H BeesonN53002Ryan Aeronautical ST3KR · S/N 1430Cancelled Nov 29, 1955 · Cannon Stanley LN2944NCessna 120 · S/N 13205Cancelled Nov 9, 1955 · Green Flying ServiceN97866Stinson 108-1 · S/N 108-866Cancelled Oct 31, 1955 · Built 1946 · Wolfe James EdwardN66708Consolidated Vultee BT-13A · S/N 7607Cancelled Oct 24, 1955 · Christensen R DN1076NConsolidated Vultee L-13B · S/N 46-0073Cancelled Mar 4, 1955 · Ralph W RensinkN87HCurtiss Wright ROBIN C-1 · S/N 456Cancelled Feb 21, 1955 · Built 1929 · White Charles VN2277VCessna 140 · S/N 14508Cancelled Jul 15, 1954 · Exported to Canada · Cessna Club IncN76768Cessna 140 · S/N 11200Cancelled Apr 28, 1954 · Swayze Ronald HN1395EAeronca 7AC · S/N 7AC-4957Cancelled Mar 30, 1953 · Built 1946 · Lyon RobertN4047VCessna 170 · S/N 18375Cancelled Jan 3, 1952 · Hyland RayN7757HPiper PA-12 · S/N 12-654Cancelled Jun 6, 1951 · Green Flying ServiceN2681VCessna 170 · S/N 18191Cancelled Apr 5, 1951 · Green Flying ServiceN5748HPiper PA-16 · S/N 16-359Cancelled Nov 28, 1950 · Green Flying ServiceN49274Boeing D75N1 · S/N 75-3866Cancelled Jun 14, 1950 · Whipple Melvin MN53464Boeing A75N1 · S/N 75-4798Cancelled Jun 7, 1950 · Hales JackN92936Commonwealth 185 · S/N 1668Cancelled Jun 7, 1950 · Nasholm Carl RN10684White L J 25 · S/N 1Cancelled Apr 11, 1950 · Smith E LN28478Luscombe 8A · S/N 1345Cancelled Feb 2, 1950 · Built 1940 · Jacobs Guy AN1024NFairchild M-62A-3 · S/N T42-4073Cancelled Aug 30, 1949 · Shelby F SmithN49432Fairchild M-62C(PT-23A) · S/N 198Cancelled Feb 3, 1949 · Hanson Eugene EN49400Fairchild M-62A · S/N T42-3223Cancelled Nov 4, 1948 · Chennault Flying Club IncN36772Stinson 10A · S/N 8072Cancelled Sep 23, 1948 · Built 1941 · Munson Robert LN580YNicholas Beazley NB-8G · S/N K-21Cancelled Jul 13, 1948 · Built 1931 · Saville Clarence RobertN14043Waco UKC · S/N 3868Cancelled Apr 21, 1948 · Wolfe James EN10659Smith Yale E H S · S/N 1Cancelled Jul 15, 1939 · Smith Yale EN10648Scroggs LAST LAUGH · S/N A-1Cancelled Aug 2, 1934 · Scroggs Roy B
Back to Eugene, OR