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.
N250JFField Joseph S LANCAIR 360 · S/N 644-320-389 FBN250VBUltramagic T-180 · S/N 180/176N252PZProgressive Aerodyne SEAREY LSA · S/N 1071N2538YCessna 172D · S/N 17249838N2573KCessna 180K · S/N 18052995N2575YCessna 172D · S/N 17249875N25LFBoeing B75N1 · S/N 75-6415N25VRDassault FALCON 2000 · S/N 152N265AJJohn Joseph Janovetz TEAM ROCKET F1 EVO · S/N 162N2673RCessna 182K · S/N 18258373N26RDPiper PA-34-200 · S/N 34-7350167N26RWWise OR-71-B · S/N 0R-71-B-RW1N271EXJohn Paul Takacs SUPER PITTS · S/N 1N28010Bellanca 17-30A · S/N 79-30908N28083Piper J5A · S/N 5-99N2843GPiper PA-32-300 · S/N 32-7940152N285KKDassault FALCON 2000 · S/N 204N2864NCessna 120 · S/N 13125N29QCCessna 560 · S/N 560-0675N29RSSchroeder Ronald G LONG-EZ · S/N 1514N29TEPiper PA-28-161 · S/N 28-7916397N2HKSikorsky UH-60L · S/N 85-24745N301XTEmbraer S A EMB-505 · S/N 50500096N302NANorth American T-28A · S/N 51-3725AN302SGlasflugel MOSQUITO · S/N 32N303VPGlasflugel MOSQUITO · S/N 50N304RLDJI AGRAS T50 · S/N 1581F6BUB248E001HC32N305BALet L 33 SOLO · S/N 960408N305DSMitsubishi MU-2B-26 · S/N 328N30CJTextron 525B · S/N 525B0730N3111HBeech F33A · S/N CE-1168N311BPDassault MYSTERE-FALCON 50 · S/N 314N3120WBeech 95-B55 (T42A) · S/N TC-1645N3136MPiper PA-12 · S/N 12-1808N3190NCessna 140 · S/N 13448N3194WRobinson Helicopter R44 II · S/N 11173N319GHHalverson Greg RV-6 · S/N 21111N3208JCessna 150G · S/N 15065908N3223UCessna 182F · S/N 18254623N3241ACessna 170B · S/N 25885N3243BRaytheon A36 · S/N E-3243N329WTCirrus Design SR22T · S/N 8563N331KFleet 2 · S/N 45N331RVVans RV-12 · S/N 120358N3357KGlobe GC-1B · S/N 1350N337HPGreg Nelson RED BIRD 01 · S/N RB01N338CCook Joe F 2T1-A GREAT LAKES · S/N 9801-G-652N340GCessna 340A · S/N 340A1006N3481TCessna 177 · S/N 17700781N348XMaule M-5-210C · S/N 6162C
Back to Portland, OR