Skip to content

Lake Oswego, OR

Cancelled registrations · 45

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 = 'LAKE OSWEGO' 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 = 'LAKE OSWEGO'
  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 = 'LAKE OSWEGO'
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.

N873JSCirrus Design SR22T · S/N 1467Cancelled Jan 30, 2025 · Exported to Canada · Built 2016 · Shootyourarrow928 LLC N24638Beech C23 · S/N M-1455Cancelled Nov 27, 2023 · Revoked, canceled · Built 1972 · Hoge Patricia C N208SLTextron 208B · S/N 208B5291Cancelled Mar 11, 2021 · Exported to Canada · Built 2016 · T C Air LLC N67ECCessna 210G · S/N 21058840Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1966 · Gossard Bruce F N1505WAvian Balloon SKYHAWK · S/N 105Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1983 · Wileys Seaplanes Inc N184BAIcon A5 · S/N 00007Cancelled Aug 25, 2017 · Built 2016 · Parker Kurt R N13060Taylorcraft BF12-65 · S/N 2786Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1941 · Wiley David H N209DCDiamond Aircraft Ind DA20-C1 · S/N C0209Cancelled Aug 27, 2015 · Exported to Canada · Built 2003 · Benzing Jeffrey C N92373Cessna 182N · S/N 18260176Cancelled Apr 7, 2015 · Exported to Mexico · Built 1969 · Deering Timothy J N121DACirrus Design SR22 · S/N 1563Cancelled Aug 27, 2014 · Exported to Canada · Built 2005 · N121da LLC N718TJJames Timothy H CUB · S/N 0002Cancelled Jul 15, 2014 · Exported to Canada · Built 2011 · James Timothy H N68665RCM GYROCOPTER FL I · S/N 369-20-2248Cancelled Nov 13, 2013 · Revoked, canceled · Built 1963 · Eaton Elmer L N14DCCessna 414 · S/N 414-0483Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1973 · D&B Leasing Enterprises N29778Cameron Balloons US V-77 · S/N 5080Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1984 · Northwest Avn Entprs Inc Air Agncy #N7320LEagle Balloons C-7 · S/N E 85783Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1985 · Northwest Aviation Enterprises Inc N3148BWillie Chad C EXCELSIOR · S/N SC-1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Wille Chad C N101WLShaffer Edward TH WLAC-1 · S/N 001Cancelled May 14, 2013 · Registration expired, pending cancellation · Southwind Aircraft Sales West N5719ZRaven Industries RALLY RX7 · S/N RX7-261Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1981 N1672TCessna 414 · S/N 414-0465Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1973 · Vip Properties Incorporated N9731QBeech A24R · S/N MC-83Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1971 N518DDPiper PA-28RT-201T · S/N 28R-8331015Cancelled Oct 27, 2011 · Exported to Canada · Olson Susan M N77RSGates Lear Jet 25C · S/N 094Cancelled Jun 28, 2011 · Revoked, pending cancellation · Built 1976 · Sykes Richard Jr N6735JPiper PA-28-140 · S/N 28-24445Cancelled Nov 17, 2008 · Built 1968 · Houghton Kyle D N1378CCirrus Design SR22 · S/N 0539Cancelled Oct 11, 2006 · Exported to Poland · Built 2003 · 78 Charlie Leasing LLC N115CChristen Industries PITTS S-2B · S/N 5216Cancelled Nov 4, 2002 · Exported to Slovak Republic · Built 1991 · Radakovich Robert P II N8719MBeech 23 · S/N M-503Cancelled May 1, 2002 · Triennial form not returned · Built 1963 · Waggoner David F N2173ZAero Commander 680V · S/N 1704-80Cancelled Sep 9, 1997 · Ihlenburg Kirk F N7507HSchweizer 269C · S/N S1615Cancelled Jan 31, 1996 · Exported to Germany · Pacific Flight Services Inc N2407XRobinson Helicopter R22 BETA · S/N 1883Cancelled Aug 25, 1994 · Triennial form not returned · Brady Howard Nelson Jr N306DMState Aircraft Factories MIG-17T · S/N 0714Cancelled May 26, 1994 · Yak Attack Inc N2102VPiper PA-28RT-201T · S/N 28R7931119Cancelled Nov 22, 1993 · Exported to Germany · Piechowski Klaus W N53328Cessna 172P · S/N 17274722Cancelled May 26, 1993 · Exported to Germany · Poling Harper A DBA N4350CCessna 340A · S/N 340A1012Cancelled Mar 8, 1991 · Exported to Germany · Extended Travel Services Inc N4699WRockwell International 112TCA · S/N 13275Cancelled Jul 26, 1984 · Brayton William J N8081WPiper PA-28-180 · S/N 28-2170Cancelled Dec 21, 1982 · Adam Ethal L N72778Cessna 140 · S/N 9961Cancelled Jun 9, 1982 · Wileys Seaplanes N7588SCessna 182Q · S/N 18265237Cancelled Jul 2, 1981 · Exported to Canada · Bernard Frank N98798Piper J3C-65 · S/N 19039Cancelled Feb 23, 1981 · Nolan Ronald C N53283Cessna T-50 · S/N 6458Cancelled Mar 17, 1978 · Young Thomas N4125TCessna 320D · S/N 320D0025Cancelled Jun 25, 1973 · Renshaw Dean/Nicholudis Thomas/ Fox Warren H N69HEAero Commander 680-F · S/N 680F-932-5Cancelled Jun 25, 1973 · Hassan Enterprises Inc N9352PPiper PA-24-260 · S/N 24-4853Cancelled Nov 17, 1972 · Koch George N N5600YPiper PA-23-250 (6PCLM) · S/N 27-2709Cancelled Aug 14, 1972 · Collinson Delbert E N4600KRyan NAVION · S/N NAV-4-1600Cancelled Jun 14, 1971 · Taylor Gale C N3352XMooney M20E · S/N 1077Cancelled May 19, 1970 · Aljim Aero Leasing Corp

Back to Lake Oswego, OR