Pendleton, OR
Registered aircraft · 117
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 = 'PENDLETON' 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 = 'PENDLETON' 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.
N450NEEclipse Aerospace EA500 · S/N 550-0280N4528VBeech 35 · S/N D-1352N462CCGarlick Helicopters UH-1H · S/N 6509666N463CHHylio HYL-150 · S/N 17906110489N480BEnstrom Helicopter 480 · S/N 5008N490YHylio HYL-150 · S/N 17906110490Sale reportedN51699Enstrom F-28C · S/N 416N51770Enstrom F-28C · S/N 445N518EGEnstrom F-28F · S/N 812N523SRDJI AGRAS T50 · S/N 63YBAG0020073N5330PPiper PA-24-250 · S/N 24-374N544HEnstrom F-28C · S/N 335N5546VStits Playboy SA3A · S/N P-559N5612MTaylorcraft BC12D-85 · S/N 12011N5623MKelly/Enstrom T280 · S/N 907-001N56874Enstrom F-28C · S/N 467N5694AEnstrom F-28C · S/N 491-2N5698EEnstrom F-28F · S/N 506-2N5699NEnstrom Helicopter 280C · S/N 1220N5699UEnstrom F-28F · S/N 511N5779HPiper PA-16 · S/N 16-395N57KABell UH-1H · S/N 66-16657N5906RCessna 172G · S/N 17253575N6093FCessna 182P · S/N 18264108N624CGCessna 182J · S/N 18257270N643HEnstrom F-28C · S/N 396N644ARAnderson Tony V BUSHMASTER X · S/N 25001N666MDEnstrom F-28C · S/N 338N673DBeech C35 · S/N D-2948N6837KPiper PA-16 · S/N 16-672N6897UMooney M20C · S/N 2601N6972ECessna 175A · S/N 56472N703NPBell UH-1H · S/N 69-15602N7071PPiper PA-24-250 · S/N 24-2223N71136Cessna 182M · S/N 18259509N7247TCessna 172A · S/N 46847N728DBEnstrom F-28C · S/N 332N730HEnstrom F-28F · S/N 730N7545BChampion 7FC · S/N 7FC-48N762AEnstrom F-28F · S/N 762N7694RBeech C23 · S/N M-1294N776DBBeech C35 · S/N D-3046N77KCExstrom SKYRANGER · S/N 001N7841DJI AGRAS T40 · S/N 1581F574B238A00102X8Sale reportedN7843DJI AGRAS T40 · S/N 1581F574B238U00101JCSale reportedN7865DPiper PA-18-150 · S/N 18-6014N791CFBell UH-1H · S/N 68-16245N814MSPiper PA-28-161 · S/N 28-8316099N8161KBell 47G-3B-2 · S/N 6743Sale reportedN8204NPiper PA-28-140 · S/N 28-25396
Back to Pendleton, OR