Skip to content

Cancelled registrations · 202

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

N2510ULancair LC42-550FG · S/N 42075Cancelled Jun 24, 2005 · Exported to Australia · Lancair Co N25187Lancair LC41-550FG · S/N 41053Cancelled Mar 4, 2005 · Exported to Mexico · The Lancair Company N2439ZCessna 182S · S/N 18280811Cancelled Sep 9, 2004 · Exported to Australia · Built 2000 · J E C Enterprises Inc N2913FCessna 182J · S/N 18257013Cancelled Dec 17, 2003 · Triennial form not returned · Built 1966 · Traughber Jim L N750TLLiv-P LIV-TP · S/N LIV-480Cancelled Oct 23, 2003 · Exported to Mexico · Built 2002 · La Consolidated LLC N54WKHughes Helicopters HUGHES 369D · S/N 690532DCancelled Mar 10, 2003 · Exported to Hungary · Universal Pacific Investments N114KDRockwell International 114 · S/N 14368Cancelled Feb 23, 2003 · Exported to Canada · Built 1978 · Downs Kerry D N3701EBeech C24R · S/N MC-708Cancelled Jul 24, 2002 · Exported to Canada · Built 1980 · Nager Andreas G N211XPLancair LC-40-550FG · S/N 40036Cancelled Mar 26, 2002 · Lancair Company N6181YChristen Rick ROTORWAY EXEC · S/N 002Cancelled Nov 15, 2001 · Triennial form not returned · Christen Richard P N7036XRobinson Helicopter R22 BETA · S/N 2869Cancelled Sep 19, 2001 · Exported to Canada · Currie David A N7815DPiper PA-22-150 · S/N 22-5461Cancelled Sep 14, 2001 · Patrick Paul C N753DBBeech A100 · S/N B-172Cancelled Jun 22, 2001 · Exported to Canada · New Air N71233Balloon Works FIREFLY 8B · S/N F8B-148Cancelled Jul 19, 2000 · Triennial form not returned · Ash Jonathan N4106Pitts Special S-1 · S/N 124HCancelled Nov 16, 1998 · Triennial form not returned · Chambers Charles S N168RWSmith Miniplane DSA-1 · S/N RW1Cancelled Oct 31, 1998 · Triennial form not returned · Chambers Charles S N934APiper PA-22 · S/N 22239Cancelled Jun 2, 1998 · Triennial form not returned · Gibson Patrick V N6522VCessna 172RG · S/N 172RG0748Cancelled Mar 5, 1998 · Triennial form not returned · Flight Shop Inc N8033HRobinson Helicopter R22 BETA · S/N 2378Cancelled Mar 8, 1996 · Exported to Canada · Anderson Ron N68866Helio H-295 · S/N 1471Cancelled Jul 6, 1995 · Exported to Mexico · Hermens Stanley G N558RSPiper PA 46-350P · S/N 4622100Cancelled Dec 15, 1992 · Exported to Germany · Western Air Services Inc N186DMPiper PA 46-350P · S/N 4622063Cancelled Nov 15, 1991 · Exported to Germany N2770GCessna 182B · S/N 52070Cancelled Aug 21, 1991 · Triennial form not returned · Louth Harold L N36532Aeronca 65-CA · S/N CA15751Cancelled Apr 8, 1991 · Triennial form not returned · Bryan Tim G N47RYYaw Ralph G QUICKIE · S/N 436Cancelled Jun 26, 1989 · Administratively canceled · Yaw Ralph G N11847Cessna 150L · S/N 15075673Cancelled Jun 2, 1984 · Administratively canceled · Wilson Philip O N6045Allison-Morgan TEENIE TWO · S/N 51280Cancelled Aug 22, 1983 · O'Brien Robert M N763ABBoeing 707-331 · S/N 17676Cancelled May 20, 1983 · Air Berlin Charter Co N767ABBoeing 707-331 · S/N 17682Cancelled May 20, 1983 · Air Berlin Charter Co N761XPCessna T210M · S/N 21062603Cancelled Feb 8, 1983 · Holmes William M N203GBDouglas C-118A · S/N 51-3826Cancelled Jun 9, 1982 · Exported to Jamaica · Built 1951 · H T T Inc N333RHEnstrom Helicopter 280C · S/N 1068Cancelled May 6, 1981 · Built 1977 · R A Hatch Co N9202PPiper PA-24-260 · S/N 244697Cancelled Mar 28, 1980 · Exported to Canada · Katter Ivan D & Sally N3956TPiper PA-28-181 · S/N 28R-30300Cancelled Jul 6, 1977 · Neff Hugh Dale N5545WPiper PA-28-160 · S/N 28636Cancelled Dec 20, 1976 · Exported to Canada · William James H N5906BCessna 182 · S/N 33906Cancelled Aug 1, 1975 · Exported to Canada · Spahn Cody N4692ACessna 180 · S/N 32289Cancelled Apr 6, 1973 · Exported to Canada · Patrick V Gibson N1802APiper PA-22 · S/N 22-511Cancelled Aug 14, 1970 · Jims Electric Service N6804MStinson 108-3 · S/N 108-4804Cancelled Jan 8, 1970 · Mccook Anson G N2866MPiper PA-12 · S/N 12-1288Cancelled Jun 12, 1965 · Kirsch Don R N9423ZDouglas B-26C · S/N 44-34687Cancelled Apr 13, 1964 · Central Oregon Airial Co Inc N9521HFairchild PT-26 · S/N FC-81Cancelled Apr 30, 1956 · Graham Robert N N58534Fairchild PT-26 · S/N T42-4253Cancelled Nov 30, 1955 · Bowman Lyle O N1058NHoward DGA-15P · S/N 914Cancelled Aug 11, 1955 · Bill Corbett N1085DCessna 195A · S/N 7697Cancelled Mar 7, 1952 · Corbett Bill N7543HPiper PA-12 · S/N 12-409Cancelled Apr 5, 1951 · Built 1945 · Tilse-Bowmen Air Service N2954HEngineering & Research ERCOUPE 415-C · S/N 3579Cancelled Oct 16, 1947 · Built 1946 · Tilse-Bowman Air Service N25391Fairchild 24W-40 · S/N W40-123Cancelled Jun 28, 1946 · Brooks Thomas Frederick N33233Piper J3C-65 · S/N 5905Cancelled Jun 15, 1946 · A J Tilse DBA Tilse Flying Service N87441Ercoupe 415-C · S/N 614Cancelled Jun 15, 1946 · Tilse Flying Service

Back to Bend, OR