Sisters, OR
Registered aircraft · 60
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 = 'SISTERS' 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 = 'SISTERS' 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.
N102MDMaule M-4-220C · S/N 2127CN144SHHarris Steve L VANS RV-4 · S/N 1N144THHarris Steve BEARHAWK · S/N 38-73/74-764N16444Beech C17L · S/N 103N1689KLuscombe 8E · S/N 4416N182TVCessna 182M · S/N 18259913N1981XCessna 182H · S/N 18256081N211HLTaylor Jeffrey S HIGHLANDER · S/N JA229-02-11N219KMMike Macon CCK-1865 · S/N CCK-1865-0080N222TTBeech G35 · S/N D-4446N2443DCessna 170B · S/N 20595N24498Cessna 152 · S/N 15280290N24998Cessna 152 · S/N 15280503N2715CCessna 170B · S/N 26259N295BFHelio HT-295 · S/N 1715N319JSStolasz Jeffrey P HIGHLANDER · S/N JA609-12-20N335TCBeech V35 · S/N D-8274N33BJPilatus PC-12/45 · S/N 184N33HRJohs Robert W HARMON ROCKET II · S/N 004N346BBarnett C/Wilson J N KITFOX SPEEDSTER · S/N EB5004N351TMGeorge Walters THUNDER MUSTANG · S/N FITM023N3713MPiper PA-12 · S/N 12-2539N3720VCessna 140 · S/N 14997N4013VCessna 170 · S/N 18332N4252SMaule MXT-7-180A · S/N 21078CN42944Piper J3C-65 · S/N 15303N42958Cessna 180J · S/N 18052389N43628Taylorcraft BC12-D · S/N 7287N442HCRobinson Helicopter R44 II · S/N 11017N442MJMaryjane Frances Harris RV-14A · S/N 140938N458LKTodd Downing KITFOX SS7 · S/N KA12351250N4820ECessna A185F · S/N 18503880N516PUPiper PA-28-161 · S/N 28-8316101N5290ZPiper PA-22-108 · S/N 22-8986N573TLSocata TB-20 TRINIDAD · S/N 573N5751BCessna 182 · S/N 33751N58153Mooney M20J · S/N 24-1580N6074JPiper PA46-500TP · S/N 4697397N6089MCessna 152 · S/N 15284617N625VJackson Nate VELOCITY 173 R G · S/N DMO 329N6350MCessna 152 · S/N 15284689N6351PCessna 152 · S/N 15285006N63LSSmith J Leon SUPER ES · S/N ES-004N68459Cessna 152 · S/N 15282303N708JPSocata TBM 700 · S/N 1199N739LMDavis Lawrence L RV-6 · S/N 20885N758LECessna R172K · S/N R1723174N774LSPiper PA-32-300 · S/N 32-7840004N777HLNorth American SNJ-5 · S/N 85008N787CLDean R Billing DBR S-7S · S/N 0111552
Back to Sisters, OR