Skip to content

Cancelled registrations · 80

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

N368WStephen Lorentzen LANCAIR LEGACY · S/N L2K-102Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Wolstenholme Robert F N927LEJCB 5 EVOLUTION · S/N EVO001Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2008 · Jcb 5 Inc N407LLancair Intl LANCAIR ES · S/N ES001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1992 · Jcbs Inc N933ACBeech 400 · S/N RJ-05Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1985 · Stratos Aircraft Inc N1758PPiper PA-18 · S/N 18-4078Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 1954 · Lash Alvin C N82QUNewgard Peter M KITFOX 4-1200 · S/N 1798Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1993 · Thornburgh Ambers J N9208HCessna 172M · S/N 17266015Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1975 · Thornburgh Ambers J N5110TChampion 7ECA · S/N 443Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1966 · Davis Richard T N427LEBartels Joseph LANCAIR EVOLUTION · S/N EVO-002Cancelled Feb 26, 2018 · First renewal notice · Built 2009 · Unmanned Systems Inc N4286AArras William AX-2 · S/N PPN06Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1995 · Arras William R N4287UArras William AX-1 · S/N ANN02Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Arras William R N42905Arras William AX-5 · S/N ANN10Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1995 · Arras William R N106LLancair International LANCAIR IV · S/N L002Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1992 · Jcb5 Inc N71344Powell Coy M BERKUT · S/N 026Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2005 · Powell Coy M N10272Braunschmidt Ken TURBO SKY WAGON · S/N 000I-00Cancelled Aug 9, 2016 · Third renewal notice · Braunschmidt Ken R N2471GCessna 182B · S/N 51771Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1959 · Daughs Robert H N69KBBraunschmidt Ken LANCAIR IV · S/N FB-304-IVCancelled May 19, 2015 · Registration expired, pending cancellation · Built 1998 · Braunschmidt Kenneth N7XZCessna TR182 · S/N R18201053Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1979 · Spirit Flight Inc DBA N4286UArras William AX-1 · S/N ANH01Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1995 · Arras William R N4289EArras William AX-2 · S/N ANPN05Cancelled May 5, 2015 · Registration expired, pending cancellation · Arras William R N4290UArras William AX-1 · S/N PPN-03Cancelled May 5, 2015 · Registration expired, pending cancellation · Arras William R N51158Arras Industries EX 6 · S/N A1292Cancelled May 4, 2015 · Registration expired, pending cancellation · Arras Industries Inc N6441VAerostar International RX-7 · S/N RX7-3056Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1986 · Arras Industries Inc. DBA N4289UArras William AX-2 · S/N NF111-07Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Arras William R N752BXLancair International LANCAIR PROPJET · S/N LIV-584Cancelled Oct 1, 2014 · Registration expired, pending cancellation · Built 2007 · Lancair International Inc N92PFFox Peter H RV-6 · S/N 20131Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Fox Peter H N6354DAerostar International RAVEN S49A · S/N S49A-3081Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1991 · Keown Owen B N7164MCessna 175 · S/N 55464Cancelled Aug 16, 2013 · Sale reported, canceled N3111QCessna 182K · S/N 18258111Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1967 N63070Boeing A75N1(PT17) · S/N 75-2749Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1941 · Butler Calvin J N279WPBeech A36TC · S/N EA-142Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1980 · Basin Building Materials Co N112CJButler Calvin J QUICKIE II · S/N 2442Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Redmond School District 2j N46BTAviat PITTS S-2B · S/N 5245Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1992 · Sowell Paul A N7201MCessna 175 · S/N 55501Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1958 N6833ECessna 175A · S/N 56333Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1959 N5121AArras William EX5 · S/N B193Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1993 · Arras Industries Inc N6967PPiper PA-24-250 · S/N 24-2108Cancelled Nov 7, 2012 · Sale reported, pending cancellation · Built 1960 N4411APartin Greg A QUICKSILVER MX II · S/N 1425Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Partin Greg A N35359Cessna 172I · S/N 17256733Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1968 N8315LCessna 172I · S/N 17256515Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1968 N1372FCessna 172G · S/N 17254867Cancelled Jun 14, 2012 · Sale reported, canceled · Built 1966 N409LNeico LANCAIR IV · S/N L4001Cancelled May 22, 2012 · Built 1990 · Jcb5 Inc N167NMBritish BAC 167 STRIKEMASTER · S/N 404Cancelled Apr 27, 2011 · Exported to Canada · Built 1970 · Vortek LLC N2457XCessna 172S · S/N 172S10114Cancelled Dec 9, 2010 · Exported to Canada · Built 2006 · Spirit Flight Inc DBA N390LJCB 5 LANCAIR LEGACY FG · S/N LS-215Cancelled Sep 24, 2009 · Exported to Brazil · Built 2006 · Jcb 5 Inc N240MECessna 182S · S/N 18280759Cancelled Dec 4, 2007 · Exported to Russia · Built 2000 · Smith Keith D N359LMK II LEGACY SPORT · S/N LS-100Cancelled Oct 9, 2007 · Triennial form not returned · Built 2003 · Jcb5 Inc N6318CDouglas DC-7 · S/N 44282Cancelled Aug 23, 2007 · Triennial form not returned · Built 1954 · Butler Aircraft Company N750MLBartels Joseph C LANCAIR PROPJET · S/N LIV-561Cancelled Mar 11, 2005 · Exported to Mexico · Built 2004 · Bartels Joseph C N25069Eells Belinda C AIR COMMAND-503 · S/N 1D188Cancelled Mar 29, 2004 · Triennial form not returned · Eells Belinda C

Back to Redmond, OR