Skip to content

Springfield, OR

Cancelled registrations · 77

Query with SQL

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 = 'SPRINGFIELD' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'SPRINGFIELD'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9833WPiper PA-28-140 · S/N 28-23339Cancelled Jul 11, 2026 · Registration pending, canceled · Built 1967 N456Bennett James G LANCAIR 320 · S/N 5Cancelled Jun 6, 2026 · Registration pending, canceled N47032Unrein Paul DSA-1 MINI PLANE · S/N 1Cancelled Jun 6, 2026 · Registration pending, canceled · Built 1984 N6863KPiper PA-16 · S/N 16-699Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1949 N2072ZRyan Aeronautical ST3KR · S/N 1446Cancelled Jul 22, 2023 · Registration pending, canceled · Built 1941 N79446Cessna 172K · S/N 17258095Cancelled Apr 18, 2023 · Sale reported, canceled · Built 1969 N77344Cessna 120 · S/N 11785Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Motter Edward Christian Allen N9294RHughes 269C · S/N S1171Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1984 · Summit Helicopters N37334Interstate S-1A · S/N 177Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Talen Timothy L N50557Taylorcraft DC-65 · S/N O4498Cancelled Jan 3, 2020 · Revoked, canceled · Built 1942 · Sudduth Doyle H N76046Cessna 172N · S/N 17268102Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1976 · Summit Helicopters N115SWPiper PA-30 · S/N 30-919Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Bauer John M N4948ESilvaire LUSCOMBE 8A · S/N 6388Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Skinner Hal W Jr N7455NBeech 36 · S/N E-33Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1968 · Lababedy Hakmat N8136NTaylorcraft A · S/N 89Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Talen Timothy L N9857Travel Air Mfg 2000 · S/N 1113Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Talen Timothy L N844EAmerican Eagle 101 · S/N 375Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Talen Timothy L N6154Stearman C3-B · S/N 140Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Talen Timothy L N6299Stearman C3-B · S/N 195Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Talen Timothy L N29025General G1-80 · S/N 12Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Talen Timothy L N2213EInterstate S-1A · S/N 14Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1941 · Talen Timothy L N15346Fairchild 24 C8C · S/N 2689Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1935 · Talen Timothy L N19759Aeronca K · S/N K-270Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Talen Timothy L N820KGreat Lakes 2T-1A · S/N 134Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1931 · Talen Timothy L N17054Cessna C-34 · S/N 337Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1936 · Talen Timothy L N505PRRobinson Helicopter R22 BETA · S/N 1380Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1990 · Kelly William W N89622Mattison Kenneth A EARLY BIRD JENNY · S/N 140Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Mattison Kenneth A N80400Beech D18S · S/N A-248Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Bowman George W N5781ACessna 172 · S/N 28381Cancelled Oct 3, 2016 · Registration expired · Built 1956 · Bodie Charles H N116NSioux COUPE 60 · S/N Q-217Cancelled May 6, 2015 · Registration expired, pending cancellation · Talen Timothy L N167VCurtiss Wright TRAVEL AIR 2000 · S/N 1402Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Talen Timothy L N5384UCessna TU206G · S/N U20605265Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1979 · Palmer Ed N15347Fairchild 24 C8C · S/N 2690Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1935 · Talen Timothy L N4992ZPiper PA-22-108 · S/N 22-8600Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1961 · Houck Stanley E N1403AAerofab LAKE LA-250 · S/N 30Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1985 · Berryman Larry A N82QTThomas James L QUICKIE · S/N 443Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1982 · Thomas James L N9682LGrumman American Avn. AA-1B · S/N AA1B-0182Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1973 · Thomas Jeffrey N N4255XFinch John Michael COMMUTER IIA · S/N 80Cancelled May 3, 2013 · Registration expired, pending cancellation · Finch John M N7153DPiper PA-22-150 · S/N 22-5017Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1957 · Jones Stan R N20702Porterfield CP-40 · S/N 532Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1938 · Talen Timothy L N12107Cessna 172M · S/N 17261814Cancelled Nov 14, 2011 · Exported to Argentina · Built 1973 · Santiam Drug Inc N10670Macmaniman Springfield BABY FLEET · S/N 5Cancelled Jun 30, 2011 · Sale reported, canceled · Built 1931 N1168GJones Stan REFLEX · S/N 007Cancelled Feb 7, 2011 · Registration pending, pending cancellation N9353FHughes 269B · S/N 0061Cancelled Sep 18, 2009 · Registration revoked · Built 1964 · Defoor R R Transport Co Inc N163CTCirrus Design SR22 · S/N 2954Cancelled Aug 10, 2009 · Exported to Brazil · Built 2008 · Rainrock Investment LLC N6595UMooney M20C · S/N 2377Cancelled Apr 9, 2009 · Triennial form not returned · Built 1962 · Bodie Charles H N293RCHaynes David RANS S-4 · S/N 00293Cancelled Sep 9, 2003 · Haynes David S N62961Cessna 172P · S/N 17275369Cancelled Dec 2, 2002 · Triennial form not returned · Built 1981 · Sundahl Roscoe J Trustee N542YKYakovlev YAK-54 · S/N 04003Cancelled Sep 29, 1999 · Exported to Australia · Yakovlev Aircraft Of USA LLC N4312APiper PA-28-235 · S/N 28-10249Cancelled Jul 26, 1999 · L & S Investment

Back to Springfield, OR