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.

N73BVBellanca 17-31ATC · S/N 73-31066Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1973 · Noble Viking LLCN9219SHammer Tom VARIEZE · S/N 1718Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1982 · Hammer Thomas JN210XDAmerican Champion 8KCAB · S/N 1132-2013Cancelled Feb 24, 2015 · Exported to Austria · Built 2013 · Extremeaerosports.Com LLCN5554KRaven Industries RALLY RX7 · S/N RX7-116Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1979 · Hull Lawrence EN991TPPettit Thomas E SAVANNAH · S/N 04-06-51-297Cancelled Nov 19, 2014 · Registration pending · Built 2004N6402JPiper PA-28-180 · S/N 28-4818Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1968 · Dilworth JohnN1960WBeech B19 · S/N MB-622Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1973 · Corvallis Aero Service IncN52980Daleo Norman C RANS S-14 · S/N 0392017Cancelled Aug 20, 2014 · Sale reported, canceledN8539JCessna 150G · S/N 15066439Cancelled Jun 2, 2014 · Exported to Canada · Built 1967 · Laux Ronald KN737SGCessna TR182 · S/N R18200878Cancelled Nov 13, 2013 · Registration expired, pending cancellation · Built 1979 · Place Kenneth TN2341JRobinson Helicopter R22 BETA · S/N 2187Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1992 · Pacific Rim Aviation LLCN7179QMason Bob QUICKSILVER MX II · S/N 1097Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Hunter E StewartN6156UAviation International Rotors CH-54A · S/N 66-18410Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1966N243WJBell 214ST · S/N 28127Cancelled Aug 13, 2013 · Sale reported, canceledN1915RRaven Industries RX6 · S/N RX6-293Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1978 · Hull Lawrence EN51714Baierl David W RANS S-6ES COYOTE II · S/N 0492290Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1992N86129Elkay UFO-9 · S/N L-1Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1980 · Elkay CorporationN733FPolizzotto Gary DR PULSAR · S/N 121Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1991N620HAHispano Aviacion HA-200 SAETA · S/N E.14A-20Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Shepard Aircraft CorporationN8ZHHiller UH-12D · S/N 1051Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1958 · Corvallis Aero Service IncN75EBruer PITTS S-1C · S/N JLB-12Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Logan Robert LN70065Ponnequin Craig R N 3 PUP · S/N N85596-11Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1985N421TBCessna 421A · S/N 421A0056Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1969 · Beardsley JohnN310RCCessna T310Q · S/N 310Q0212Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Blatchford William AN4418QCessna 172M · S/N 17261701Cancelled Jun 27, 2012 · Revoked, canceled · Built 1973 · Dewitt RossN13841Piper PA-23-250 · S/N 27-4482Cancelled May 14, 2012 · Second renewal notice · Built 1970 · Watershed Sciences IncN919GHawkins John RAN S-6 · S/N 0196916ESCancelled Dec 7, 2011 · Built 1995 · Delaney Keith PN66632Waco UPF-7 · S/N 5585Cancelled Aug 22, 2011 · Exported to Canada · Built 1940 · Davison Robert PN4ZHBell 206B · S/N 170Cancelled Feb 14, 2011 · Revoked, pending cancellation · Built 1968 · Corvallis Aero Service IncN5599ACessna 177RG · S/N 177RG-1108Cancelled Mar 4, 2008 · Exported to Australia · Built 1977 · Crowe Hubert LN144SGRepublic RC-3 · S/N 51Cancelled Dec 20, 2007 · Triennial form not returned · Built 1946 · Looney James CN758JYCessna R172K · S/N R1723144Cancelled Sep 22, 2006 · Triennial form not returned · Built 1979 · Ugashik IncN6380HHinde Frank George ZENITH ZODC CH601HDS · S/N 63599Cancelled Jun 23, 2006 · Exported to Canada · Built 1999 · Hinde Frank GN46560Robinson Helicopter R44 · S/N 0407Cancelled Nov 8, 2005 · Exported to Australia · Avia Aviation Services IncN6070KRepublic RC-3 · S/N 250Cancelled May 25, 2004 · Triennial form not returned · Built 1947 · Looney SusanN91270Wachs Gary Michael ROTORWAY EXEC · S/N 3090Cancelled Sep 13, 2000 · Wachs Gary MN512HHRobinson Helicopter R22 BETA · S/N 0548Cancelled Feb 25, 1999 · Triennial form not returned · Pacific Rim AviationN101PRRobinson Helicopter R22 BETA · S/N 0936Cancelled May 27, 1998 · Exported to New Zealand · Pacific Rim AviationN525BWRobinson Helicopter R22 BETA · S/N 2358Cancelled Nov 8, 1997 · Triennial form not returned · Pacific Rim AviationN8627BCessna 172 · S/N 36327Cancelled Jun 4, 1997 · Triennial form not returned · Johnson Vernon SN5121PPederson Earl C SILHOUTTE I · S/N 227Cancelled Mar 19, 1997 · Triennial form not returned · Pederson Earl CN277MBStearns ER BD-4 · S/N 4469Cancelled Sep 14, 1989 · Triennial form not returned · Stearns Eugene RN7193Mclagan DRUINE TURBULENT D31 · S/N 136Cancelled Oct 20, 1983 · Mclagan Dennis LN2ZHBell 47J-2A · S/N 3110Cancelled Aug 2, 1983 · Administratively canceled · Corvallis Aero Service IncN9410LAmerican AA-1A · S/N AA1A-0210Cancelled Apr 9, 1983 · Administratively canceled · Woods Charles MN2535PPiper PA-38-112 · S/N 38-79A1018Cancelled Dec 1, 1982 · Built 1979 · Marys Peak AviationN5675YPiper PA-23-250 · S/N 27-2790Cancelled Oct 10, 1980 · Corvallis Aero Service IncN9753MMooney M20C · S/N 670047Cancelled Oct 10, 1980 · O S U Flying ClubN51989Ridings Douglas D PDQ-2 MOD C · S/N S2Cancelled Feb 20, 1980 · Ridings Douglas DN6ZHHiller UH-12E · S/N 1624Cancelled Jan 24, 1978 · Corvallis Aero Service Inc
Back to Corvallis, OR