Portland, OR
Registered aircraft · 547
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 = 'PORTLAND' 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 = 'PORTLAND' 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.
N180EHCessna 180 · S/N 32116N180HYAviat A-1B · S/N NF0001N18121Douglas DC3A · S/N 1997N1814ASteve M Newman VANS RV-14A · S/N 140300N1823ACessna 182P · S/N 18260858N1863QCessna 177RG · S/N 177RG0263N186PSPiper PA46-500TP · S/N 4697228N1871QCessna 177RG · S/N 177RG0271N1919APiper PA-18-125 · S/N 18-1747N1961PPiper PA-18-150 · S/N 18-4190N1970XCessna 182H · S/N 18256070N199EAPipistrel D O O TAURUS ELECTRO · S/N TEX13500186N19ANPiper J3C-65 · S/N 4045N200RXCessna 150G · S/N 15067073N2015DBeech C35 · S/N D-3366N2018NCessna 140 · S/N 12254N201QXMooney M20J · S/N 24-0367Registration pendingN204VBUltramagic N-210 · S/N 210/99N2072SCessna TR182 · S/N R18201298N207DBSea & Ski NW RISEN 916SV · S/N 51N2093QThomsen Horst ROTORWAY EXEC · S/N 3237N20PZCirrus Design SR22T · S/N 0775N211ALCirrus Design SR22T · S/N 8985N212LGLowry David LANCAIR LEGACY · S/N L2K-135N2163JCessna 182T · S/N 18281279N2176XPiper PA-28-181 · S/N 28-7990363N218JDCzech Sport Aircraft A S SPORTCRUISER · S/N P1001090N218MMMooney M20C · S/N 2825N21950Cessna 172M · S/N 17264046N221MLCessna 182P · S/N 18261525N222SCCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC068N222YZCirrus Design SR20 · S/N 2495N225CTRicketts James B G RV-8 · S/N 82890N225HHAirbus Helicopters EC225 LP · S/N 2961N2269NNorth American-Medore SNJ-4 · S/N 88-12427N226ATSocata TBM 700 · S/N 1206N22TZAirbus Helicopters EC 130 T2 · S/N 8016N231QYMooney M20K · S/N 25-0372N2330WBeech A23A · S/N M-927N234VMEurocopter AS365N3 · S/N 6548N235BHGulfstream Aerospace GVI (G650) · S/N 6222N241DBBrunner Douglas LANCAIR LEGACY · S/N L2K-290N2420Lunceford HEATH PARASOL · S/N 69128N2421SPiper PA-18-150 · S/N 18-7909147N242WTMooney M20TN · S/N 31-0105N2472JCessna 152 · S/N 15279969N24773Cessna 152 · S/N 15280369N247HHEurocopter France AS-365N2 · S/N 6529N249AYFaber Jan Job VANS RV9A · S/N 90437N2507PPiper PA-38-112 · S/N 38-79A1016
Back to Portland, OR