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.
N738RVKnight Dm/Knight Ca RV7A · S/N 72718N74022Cessna 180A · S/N 50324N7425TRobinson Helicopter R44 II · S/N 11192N743RKJackson Drew G RANS S-6S COYOTE II · S/N 06041578N7479CCessna 180 · S/N 30565N749AJKeller Doug AIRCAM · S/N 082N7503MCessna 175 · S/N 55803First renewal noticeN750LHLee A Hackbarth STOL CH 750 · S/N 75-10041N76786Cessna 120 · S/N 11218N7694UCessna 150M · S/N 15077820N76PXGlasflugel CLUB LIBELLE 205 · S/N 158N7719QCessna 340 · S/N 3400194N7745GCessna 172L · S/N 17259445N7757CCessna 180 · S/N 30389N77YPEpic E1000 · S/N K131N7847CCessna 180 · S/N 31046N7865North American AT-6G · S/N 51-14694N78KDBeech C24R · S/N MC-569N78WYAviat A-1C-180 · S/N 3187N7939VCessna 180H · S/N 18051839N79DACessna 550 · S/N 550-0875N8003JAvian Balloon MAGNUM IX · S/N 217N8009ACessna 170B · S/N 20861N801TNEpic E1000 · S/N K139N807LERobinson Helicopter R44 II · S/N 10807N8094XCessna 172B · S/N 17248594N811TDwsc LEGEND(PERFMNC AC) · S/N 136TFirst renewal noticeN8155BCessna 172 · S/N 29955N8155TCessna 175B · S/N 17556855N820EKErnie A Billing RV-7 STANDARD · S/N 70418N82209Piper PA-18-150 · S/N 18-7809153N822JBCubcrafters CC11-160 · S/N CC11-00366N82CXEpic E1000 · S/N K004N831VFEpic E1000 · S/N K014N832BHPilatus PC-12/45 · S/N 508N8360HPiper J-3C · S/N 45-5137N83989Aeronca 7DC · S/N 7DC-2675N8431GCessna 150F · S/N 15062531N850DVN850dv EPIC LT · S/N 031N850WCSocata TBM 700 · S/N 599N851BHHoisington Bruce KITFOX SERIES 7 · S/N S70208-014N8550LPiper PA-25-235 · S/N 25-4970N860CGBeech 95-B55 · S/N TC-1957N8632TCessna 182C · S/N 52532N863WAPiper PA 46-350P · S/N 4636863N866DSDiamond Aircraft Ind DA 40 · S/N 40.766N87ESShilling E E SKYBOLT · S/N 004 ESN88044Piper J3C-65 · S/N 15707N8811QAero Commander S2R · S/N 1511RN8840WPiper PA-28-235 · S/N 28-10389
Back to Bend, OR