Cancelled registrations · 33

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 = 'LA GRANDE' 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 = 'LA GRANDE'
  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 = 'LA GRANDE'
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.

N170CBKaman Aerospace K-1200 · S/N A94-0044Cancelled Feb 4, 2026 · Exported to China · Built 2018 · Precision Lift LLC N807CBAir Tractor AT-802 · S/N 802-0653Cancelled Apr 17, 2024 · Exported to Australia · Built 2016 · Columbia Basin Helicopters Inc N3222Schweizer SGU 2-22E · S/N 235Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1965 · Hanan Roy T N70692Franks Kenneth D MINI 500 BRAVO · S/N 408Cancelled May 22, 2017 · Registration expired, pending cancellation · Franks Kenneth D N8534PMcelhoes William A MONERAI-S · S/N 206Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1988 · Mcelhoes William A Jr N842DDouglas DC-7B · S/N 45448Cancelled Feb 4, 2017 · Revoked, canceled · Built 1958 · La Grande Air Service Inc N9175YGrace Alvin Earl LONG EZ · S/N 1395Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Grace Alvin E N9199NRockwell International 685 · S/N 12032Cancelled Jan 15, 2014 · Exported to Australia · Built 1973 · Eagle Cap Aviation Inc N3198DCessna 180 · S/N 31996Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1955 · Schmidt Steven R N660TPPayne B T/Wilson J B AEROCOMP COMP AIR 7 · S/N 997208Cancelled Jun 3, 2013 · Exported to Canada · Built 2000 · Nash R L N54622Mccall George KR-2 · S/N 2495Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1980 · Mccall George E N1718SAero Commander S2R · S/N 1418-RCancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1968 · Cunningham Glen R N4211Bensen B-8M · S/N BJ-7Cancelled Jun 12, 2012 · Revoked, canceled · Built 1967 · Jensen Jack L N118EAero Commander 680 · S/N 680-423-97Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Eagle Cap Aviation Inc N6263FCessna 337A · S/N 337-0263Cancelled Jan 20, 2012 · Registration expired, pending cancellation · Built 1965 · Eagle Cap Aviation Inc N90082Sherburn Robert VOLKSPLANE VP-1 · S/N 3024Cancelled Mar 23, 2006 · Triennial form not returned · Built 2000 · Sherburn Robert N37799Sikorsky UH-19D · S/N 56-1542Cancelled Oct 5, 2005 · Triennial form not returned · Built 1956 · Americopter Aviation Services N2208YPiper PA-28-201T · S/N 28-7921014Cancelled Aug 10, 2005 · Triennial form not returned · Built 1979 · Mcadams Industries Inc N9766VCessna A188 · S/N 188-0216Cancelled Sep 7, 2004 · Triennial form not returned · Built 1967 · Eagle Cap Aviation Inc N75428Sherburn Robert VOLKSPLANE VP-1 · S/N 83024RCancelled Jan 15, 1997 · Sherburn Robert E N4792JBeech A23-24 · S/N MA198Cancelled Sep 12, 1996 · Alayan International Exporters Inc N4897Grumman Acft ENG Cor-Schweizer G-164A · S/N 1094Cancelled May 28, 1993 N300TWBell 206B · S/N 3090Cancelled Apr 24, 1991 · Triennial form not returned · Rambling Rotors Inc N2681JCessna 150G · S/N 15065681Cancelled Dec 23, 1981 · Built 1966 · Shadwick James A N4518PPiper PA-23-250 · S/N 27-22Cancelled Apr 20, 1981 · Exported to Canada · Rambo Myrle G N5789ACessna 172 · S/N 28389Cancelled Dec 21, 1976 · Valley Flying Club Inc N3045Aerospatiale SA 318C ALOUETTE AST · S/N 2181Cancelled Feb 15, 1973 · Exported to Canada · Built 1970 · Rambling Rotors Inc N3503GNorth American TB-25N · S/N 44-30085Cancelled Jan 15, 1971 · Blue Mountain Air Service Inc N1181NBoeing A75 · S/N 75-7927Cancelled Jun 17, 1965 · La Grande Air Inc N9642CNorth American TB-25K-NC · S/N 44-29725Cancelled Sep 15, 1959 · Blue Mt Air Service Inc N49392Boeing A75N1(PT17) · S/N 75-673Cancelled Feb 7, 1949 · Eastern Oregan Airways N366ECurtiss-Robertson ROBIN · S/N 157Cancelled Nov 26, 1947 · Jones Ralph Rodney N58966Cessna UC-78B · S/N 4558Cancellation date not recorded · Greulich F A

Back to La Grande, OR