OpenAirDocs.org
Canby, OR

Registered aircraft · 115

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'OR' AND g.registrant_city = 'CANBY'
  ORDER BY g.n_number"

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.

N10035Eaglerock A-1 · S/N 970R H Lindsay & Assoc IncN10HLCessna 210L · S/N 21060646Built 1975 · Hoyt Robert H TrusteeN110YDCessna 210L · S/N 21060858Built 1975 · Lloyd CleeN1122GGroelz & Meyers VANS RV-9A · S/N 90772Built 2017 · Groelz Philip BN112TFVans RV-12 · S/N 120289Hughes GregoryN116MBird BK · S/N 2001-52Built 1929 · R H Lindsay & Assoc IncN11754Monocoupe 90A · S/N A-685Built 1934 · Colton F DN15606Fairchild 24 C8C · S/N 2708Built 1935 · Colton Frank DN164BNNugent Robert A RV6A VANS · S/N 60050Hoffman William RN1852MBoeing E75 · S/N 75-8734Built 1943 · Cundiff Charles LeeN1877VCessna 140 · S/N 14057Built 1947 · Hickman Robert JN1944BBeech G17S · S/N 6926Built 1944 · Beck Larry RN1991APiper PA-18-135 · S/N 18-1815Built 1952 · Holman Daily AN1CZCessna 190 · S/N 7481Built 1950 · Warden Richard LN20683Bell 206B · S/N 3878Built 1985 · Cascade Helicopters LLCN209MTTerrell M A /Caragol A J RV 7 · S/N 71202Built 2009 · Terrell Michael AN2230VCessna 140 · S/N 14461Built 1948 · Thompson Dan WN238YBeech F17D · S/N 272Built 1939 · Wright Jeffrey CN23XCCub Crafters CC19-180 · S/N CC19-0038Built 2018 · Gustafson Timothy ScottN240WCPilatus PC-24 · S/N 273Built 2022 · Wilson Construction CoN2411EAeronca 7AC · S/N 7AC-5990Built 1946 · R H Lindsay & Assoc IncN2546FChampion 7ECA · S/N 7ECA-342Built 1965 · Lloyd Clee EN2735UCessna 172D · S/N 17250335Built 1963 · Knepper Gary EN29958Waco UPF-7 · S/N 5455Built 1940 · Guilmette John LN3001CBeech J35 · S/N D-5664Built 1958 · Hoyt Robert HN3121LDotter Berton Eugene JR RV-4 · S/N 2309Built 1991 · Beckham StephenN317LSLance Sorensen ZENITH CH 750 CRUZER · S/N 11310Sorenson Lance JN33265Piper J5A · S/N 5466Built 1940 · Sigler Daniel EN333CXPiper PA-24-260 · S/N 24-4720Built 1967 · Flying Bs LLCN33RALockheed 12A · S/N 1239Built 1937 · Warden Richard LN34336Meyers OTW-160 · S/N 81Built 1942 · Warden Richard LN3493XMooney M20E · S/N 1161Built 1966 · Knepper Gary EN3740EAeronca 7AC · S/N 7AC-7127Built 1947 · Linstad Daniel EN3857MPiper PA-12 · S/N 12-2574Ryans Float Flying LLCN39374Aeronca 65-TAC · S/N L4482TABuilt 1942 · Park William GN3956Nord STAMPE SV4E · S/N 476Built 1949 · Hoyt Robert H TrusteeN402RHHickman Robert J RV-10 · S/N 40204Built 2008 · Hickman Robert JN415WCHughes Helicopters 369E · S/N 0005EBuilt 1981 · Wilson Construction CoN4166VCessna 170 · S/N 18499Built 1948 · Freitas Anthony FN417DBBuck David G LANCAIR IV · S/N LIV-022Troposphere Research Academy LLCN4185HPiper PA-15 · S/N 15-68Colton F DN420WCMD Helicopters 369E · S/N 0579EWilson Construction CompanyN424WCMcdonnell Douglas Heli 369FF · S/N 0606FFBuilt 1988 · Wilson Construction CoN425WCMcdonnell Douglas Helicopter 369E · S/N 0268EWilson Construction Co IncN4312WBeech V35B · S/N D-9585Built 1974 · Breitbarth BrianN4376WBeech V35B · S/N D-9626Built 1974 · Smith RyanN438YNokes Matthew LANCAIR IV P · S/N LIV-298Built 2000 · Hogge DennisN45279Naval Aircraft Factory N3N-3 · S/N 2985Built 1941 · Whitney Patricia AN4532HMooney M20J · S/N 24-0792Built 1979 · Advanced Flight Systems IncN4586HPiper PA-17 · S/N 17-2Winston Eric D
Back to Canby, OR