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.
N650WGGordon Wesley A SHERPA 650 · S/N A650000SCN6540VAero Commander 680T · S/N 1571-26N65PTCessna 177RG · S/N 177RG1086N6650KRepublic RC-3 · S/N 927N666HHEurocopter France AS-365N2 · S/N 6494N6672DBoeing-Vertol 107-II · S/N 2N6676DVertol 107-II · S/N 6N667DBBeech F33A · S/N CE-737N66806Beech B-55 · S/N TC-2278N6715RCessna T210F · S/N T210-0115N671CFAirbus Helicopters MBB-BK117 D-3 · S/N 21279N672CFAirbus Helicopters MBB-BK117 D-3 · S/N 21288N6747HCessna 172M · S/N 17265564N6764KBeech A36 · S/N E-2102N68517Bellanca 8KCAB · S/N 37-72N687BCMcilraith Glen SH-3R · S/N 3189Registration pending, pending cancellationN689APiper PA-22 · S/N 22-92N6911PPiper PA-28-181 · S/N 28-8590050N6931DPiper PA-22-150 · S/N 22-4859N6961UMooney M20C · S/N 2712N696VBUltramagic T210 · S/N 210/120N700CJCessna 525 · S/N 525-0027N700DNBeech 95-B55 · S/N TC-967N700KBCessna T303 · S/N T30300211N700NNSocata TBM 700 · S/N 135N701TJJula Theodore F ZENAIR CH701 SP · S/N 7-9677N702VBUltramagic H-77 · S/N 77/391N708PCRockwell International 695 · S/N 95023N710ETDassault FALCON 2000 · S/N 38N711SAGordon Glen GORDON-SHERPA · S/N 0001N7133NBeech E33 · S/N CD-1137N713JLJames M Jula RV-7A · S/N 70734N7165FCessna 150F · S/N 15063765N7174UMooney M20C · S/N 2756N721CStinson 108-3 · S/N 108-3721N721JFGrumman American Avn. AA-5B · S/N AA5B0807N7233YPiper PA-30 · S/N 30-257N7235JBeech A36 · S/N E-2251N723SBCessna 177B · S/N 17701786N7281PPiper PA-24-250 · S/N 24-2458N728HABombardier CL-600-2B16 · S/N 6229N734HWCessna P210N · S/N P21000602N736RUCessna R172K · S/N R1722736N737CGBoeing 737-3H4 · S/N 27954N737NLCessna 172N · S/N 17269545N737SZCessna 172N · S/N 17269651N737TDCessna 172N · S/N 17269655N739FPCessna 172N · S/N 17270510N74513Mooney M20B · S/N 1824N745AWSikorsky S-61N · S/N 61745
Back to Portland, OR