Pendleton, OR
Registered aircraft · 117
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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.
N10663Cessna 150L · S/N 15074957N1193BLuscombe 8A · S/N 5820N1219TPiper PA-34-200 · S/N 34-7250265N121PTBell UH-1H · S/N 64-13711N14333Piper PA-18-150 · S/N 18-7409091N1443FCessna 172H · S/N 17254938N14827Bell 47G3B2A · S/N 6837N171HHEnstrom F-28F · S/N 758N17KCBeech 35-33 · S/N CD-169N191JEnstrom F-28C · S/N 390N19BZEnstrom F-28F · S/N 727N2019HEnstrom 280FX · S/N 2019N2026RDJI AGRAS T30 · S/N 527BK5C0010074N210EFCessna P210N · S/N P21000391N2209JBell 47G-3B-2 · S/N 6710N224DLBeech 36 · S/N E-61N2346QBeech 23 · S/N M-425N23974Aeronca 65-C · S/N C-6399N245RNNelson Robert H N2B6 · S/N 1N2473PPiper PA-22 · S/N 22-2848N247WBell 47G-3B-2 · S/N 6683N24MPBell 47G3B2A · S/N 6836N2511RCessna 182K · S/N 18258211N2550JCessna 150E · S/N 15061050N2600YCessna 180E · S/N 18051100N280MWEnstrom F-28F · S/N 743N282ELCessna 182Q · S/N 182-67682N2910ADJI AGRAS T40 · S/N 1581F574B235400100D8Sale reportedN291XTDJI AGRAS T40 · S/N 1581F574B237A00101JESale reportedN2920ADJI AGRAS T40 · S/N 1581F574B238300100AKSale reportedN292ZADJI AGRAS T40 · S/N 1581F574B235B001034ESale reportedN2985WBell 47G3B2A · S/N 6840N3001MPiper PA-12 · S/N 12-1718N3031DJI AGRAS T40 · S/N 64TBL5D002000WN3032DJI AGRAS T40 · S/N 64TBL5F00200EWN3033DJI AGRAS T40 · S/N 64TBL5F00200E2N3360MPiper PA-28-161 · S/N 28-7816339N3458APiper PA-22-135 · S/N 22-1727N3463LCessna TU206B · S/N U206-0763N369PWNakonieczny Edward GLASAIR III · S/N 3261N3712MPiper PA-12 · S/N 12-2658N4029GBell 47G-3B-2 · S/N 6700N40DLEnstrom F-28A · S/N 071N41109Bell UH-1H · S/N 11968N4159XAero Commander 100 · S/N 341N41909Bell UH-1H · S/N 7321809N41FHSikorsky UH-60A · S/N 85-24397N4210Enstrom F-28C · S/N 421N43498Taylorcraft BC12-D · S/N 7157N446KFleet 7 · S/N 169
Back to Pendleton, OR