Bend, OR
Registered aircraft · 397
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 = 'BEND' 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.
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 = 'BEND' ORDER BY g.n_number
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.
N510AZCessna 510 · S/N 510-0124N5116MBeech 76 · S/N ME-39N5128RCessna 172M · S/N 17263345N513PACirrus Design SR20 · S/N 1974N515ATColumbia Aircraft Mfg LC41-550FG · S/N 41664N5160ECessna 172N · S/N 17271744N517PZCirrus Design SR22 · S/N 0931N518JHHill James D RV-12 · S/N 120330N51LTSchermerhorn WITTMAN W-8-ES1 · S/N 69N52010Cessna 180J · S/N 18052439N525XDCessna 525 · S/N 525-0335N529ETCooper LANCAIR EVOLUTION · S/N EVO-0036N530RMTextron 510 · S/N 510-0474N5330QCessna 150L · S/N 15073230N53516Piper PA46-500TP · S/N 4697132N541BNCirrus Design SR22T · S/N 10605N541SJJeffery M Johnson KITFOX S7 STI · S/N KA24271640N5434UBeech V35 · S/N D-8520N5442PPiper PA-24-250 · S/N 24-496N5462QCessna 172M · S/N 17261792N552LERobinson Helicopter R22 BETA · S/N 3502N554JCPiper PA-18 · S/N 18-4132N5620BCessna 182 · S/N 33620N56737North American AT-6 · S/N 59-1945N5726BCessna 182 · S/N 33726N5726PMooney M20K · S/N 25-0801N573TCPdps Pzl-Bielsko SZD-48-3 · S/N B-2063N5758BCessna 182 · S/N 33758N577WNW Michael Nicholls SLING 4TSI · S/N 188SKN589TCEpic E1000 · S/N K134N597LERobinson Helicopter R22 · S/N 597First renewal noticeN59HHEpic E1000 · S/N K128N5AKCessna 172N · S/N 17268768N6049KCessna T182T · S/N T18208582N61105Cessna U206F · S/N U20602063N611TPEpic E1000 · S/N K133N612BJJohn Rosen CCX-2300 · S/N CCX-2300-0027N6137RCubcrafters CC11-160 · S/N CC11-00333N61TTBeech F33A · S/N CE-1238N6201MMaule M-5-235C · S/N 7198CN620CWN723ct S-21 OUTBOUND · S/N 05240383N620DSVans RV-12 · S/N 120620N621MBRobinson Helicopter R66 · S/N 0579N6229UMooney M20C · S/N 2068N624KBBLY Kenneth G RV-9A · S/N 92152N6256GCessna 172N · S/N 17273583N628CBCessna 525B · S/N 525B0049N62EZSchempp-Hirth VENTUS A/16.6 · S/N 203N62VYCirrus Design SR22T · S/N 11219N63210Cessna 150M · S/N 15077177
Back to Bend, OR