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.
N4266RPiper PA-32-300 · S/N 32-40639N429QXBombardier DHC-8-402 · S/N 4161N42XFSturges Stephen S VAN RV9A · S/N 91389N430BSGrumman American Avn. AA-5B · S/N AA5B-0085N430PSDiamond Aircraft Ind DA 42 · S/N 42.066N4312LLockheed Martin C-130H · S/N 382-4312N4313LLockheed Martin C-130H · S/N 382-4313N4371DPiper PA-28-181 · S/N 28-8490100N4376YGreen Wallace L CYGNET SF-2A · S/N 235N438CYEa Vision EA J100 · S/N 85696N43KMCirrus Design SR22T · S/N 11375N4403RCessna 172M · S/N 17263153N4413BCessna 170B · S/N 26757N4430XPiper PA-34-200T · S/N 34-7670041N444KLEurocopter AS365N2 · S/N 9010N44685Piper PA-32-300 · S/N 32-7440168N448MMRaddatz Steven Gerald RV-8 · S/N 81915N449TSDiamond Aircraft Ind DA 42 · S/N 42.AC049N44RABeech 95-B55 (T42A) · S/N TC-916N4516CCessna 170B · S/N 25460N4526LGulfstream American AA-5B · S/N AA5B1129N452SAmerican Champion 8KCAB · S/N 689-92N460RGCessna 525C · S/N 525C0105N4612BCessna 180 · S/N 31510N4628MPiper PA-11 · S/N 11-132N462BDHouse Robert L HOUSE VANS RV-9A · S/N 90462N46360Cessna 172M · S/N 17264185N468BCGrumman American Avn. AA-5B · S/N AA5B0195N46RDassault FALCON 900 EX · S/N 284N470CGBoeing CH47-414 · S/N M4026N470MAAviat A-1B · S/N 2105N470RGAirbus Helicopters EC 130 T2 · S/N 8469N4717NCessna 182Q · S/N 18267306N471CGBoeing CH47-414 · S/N M4031N471WRSikorsky S-61N · S/N 61471N478FEclipse EA500 · S/N 000228N478GCirrus Design SR22 · S/N 1227N481RELithuanian Factory Of LAK-12 · S/N 6120N4829KCessna P210N · S/N P21000337N4848DCessna 182B · S/N 52082N4853Elwood STARDUSTER SA-300 · S/N GK-3N491JLCessna 560XL · S/N 560-6181N4920HPiper PA-11 · S/N 11-787N495PLRobinson Helicopter R22 MARINER · S/N 3011MN49TNThomas F Newell RV-9A · S/N 90676N500KVEurocopter AS 350 B3 · S/N 4638N505VMBell Textron Canada 505 · S/N 65345N5066EPiper J3C-65 · S/N 16582N509HHSikorsky S-76B · S/N 760312N50NABeech B200 · S/N BB1504
Back to Portland, OR