Skip to content

Cancelled registrations · 42

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

N855SMJohn T Riser ADRENALINE RISER · S/N 001Cancelled Mar 25, 2026 · Registration pending, canceled · Built 2017 N56WMMeneley Willard S QUICKIE 2 · S/N 2186Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1985 · Greiner Eugene A N728PCKarmy James ROTORWAY EXEC · S/N 6073Cancelled Aug 2, 2022 · Sale reported, canceled · Built 1995 N5362KRyan NAVION B · S/N NAV-4-2262BCancelled Oct 5, 2019 · Registration expired, pending cancellation · Scott Bob N259MKKnox Marion L RV-6A · S/N 20253Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 2008 · Knox Marion L N8176EErickson Alfred A HERQUI · S/N 1Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Sahleen Myron C N6462GCessna 150K · S/N 15071962Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1970 · Schmitz Michael N1192KLuscombe 8A · S/N 3919Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1946 · Sieminski James H N7486KPiper PA-20 · S/N 20-400Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1950 · King Derek A N642DWWheeler Dean S VANS RV-6A · S/N 22286Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2009 · Wheeler Dean S N231PWMooney M20K · S/N 25-0348Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1980 · Alexander Rick N7125CBalloon Works FIREFLY 7 · S/N F7-443Cancelled May 4, 2015 · Registration expired, pending cancellation · Whitfield Christopher D N73915Bell 47G-3B · S/N 2788Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · Pilot Personnel International Inc N7620MCessna 175 · S/N 55920Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1959 · Meadowbrook Paul B N2TUMorris BAKENG DUCE · S/N 173Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1979 N9417ABell 47G-3B-1 · S/N 3808Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1968 · Pilot Personnel International Inc N6682GCessna 150L · S/N 15072182Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Bond William K N3381JCessna 150G · S/N 15066081Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1967 N11537Cessna 150L · S/N 15075499Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Built 1973 · Clibborn Ronald G N7543JPiper PA-28R-180 · S/N 28R-30916Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1968 N41722Culver LFA · S/N 440Cancelled Jun 7, 2012 · Revoked, canceled · Built 1942 · Lunceford Timothy A N732ZDCessna T210M · S/N 21061897Cancelled Apr 26, 2010 · Exported to Mexico · Built 1977 · Atchley John A N823DSSmith Dennis AVID BANDIT · S/N 1408ECancelled Sep 10, 2008 · Triennial form undeliverable · Smith Marvin Dennis N9223XPiper PA 46-350P · S/N 4622142Cancelled Mar 22, 2007 · Triennial form not returned · Built 1993 · T And M Pipeline Construction Inc N2465KPiper PA-38-112 · S/N 38-79A0650Cancelled Nov 28, 2000 · Triennial form not returned · Healy Jack N6663SCessna 150H · S/N 15067463Cancelled May 1, 2000 · Triennial form not returned · Meadowbrook Paul N9271TPiper PA-38-112 · S/N 3878A0309Cancelled Oct 12, 1996 · Wingren Norman L N43144Taylorcraft BC12-D · S/N 6803Cancelled Jun 23, 1977 · Built 1946 · Carter Charles C Jr N8318TCessna 175C · S/N 17557018Cancelled Apr 24, 1974 · Train Ronald J N3431XMooney M20C · S/N 3401Cancelled Nov 30, 1971 · Altizer Bentley B N6924BPiper PA-22-150 · S/N 22-4200Cancelled Sep 8, 1971 · Roberts Paul F Roberts Betty L N51325Cessna 150J · S/N 15069925Cancelled Aug 18, 1971 · Flying H Sky Ranch N92104Piper J3C-65 · S/N 16541Cancelled Jan 12, 1971 · Lebanon Flying Club N9472XCessna 210A · S/N 21057772Cancelled Jan 4, 1971 · Gregory Richard S N9527MMooney M20F · S/N 670104Cancelled Jan 4, 1971 · Horn Ernest N8362DBeech J35 · S/N D-5472Cancelled Sep 3, 1970 · Starr Builders N2858HErcoupe 415-C · S/N 3483Cancelled Jun 5, 1970 · Built 1946 · Baker James S N81254Fairchild 24W-46 · S/N W46154Cancelled Nov 5, 1957 · Ralph Johnston N20072Piper J-2 · S/N 1872Cancelled Oct 19, 1955 · Pat Earl Grogan N7003KPiper PA-20 · S/N 20-110Cancelled Nov 3, 1954 · Nofziger Morris E N4531KRyan NAVION · S/N NAV-4-1531Cancelled Sep 25, 1950 · I&S Lumber Co N1707National Airways System AIR KING · S/N 121Cancelled May 1, 1939 · Crawford Lee B

Back to Lebanon, OR