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.
N567RLAMS Flight D O O CARAT A · S/N CA15Sale reportedN567XCessna 182E · S/N 18254115N569BSMark Husnik PA18-180 REPLICA · S/N 18-1686N56BUGulfstream Aerospace GV-SP (G550) · S/N 5059N56KGCessna 560 · S/N 560-0563N56ZLCameron Balloons ZL-56 · S/N 6377N5727FPiper PA-28-140 · S/N 28-25028N57FCCessna 501 · S/N 501-0229N5813FMooney M20J · S/N 24-1563N58517Cessna 182P · S/N 18262116N585MAAmerican Champion 8KCAB · S/N 992-2005N58JRAgusta AGUSTA A109 · S/N 7361N58SDCessna 180A · S/N 50167N591DKCessna 560 · S/N 560-0591N5940UPiper PA-28-140 · S/N 28-26830First renewal noticeN5954HPiper PA-16 · S/N 16-578Registration pending, pending cancellationN59VJCirrus Design SF50 · S/N 0696N5RJJamsek Richard A RUTAN LONG EZ · S/N 739N600HCCessna 414A · S/N 414A0025N600LLEurocopter AS365N3 · S/N 6262N6025XMesserschmitt-Bolkow-Blohm BO 105 P · S/N 6025N604CGCanadair CL-600 CHALLENGER · S/N 1048N605UHSikorsky UH-60L · S/N 93-26509N6062FCessna 182P · S/N 18264078N606UHSikorsky UH-60L · S/N 93-26482N6071ACessna 172 · S/N 28671N60797Cessna 150J · S/N 15070586N607EDPiper PA 46-350P · S/N 4636481N60FLPiper PA-46-600TP · S/N 4698060N611LLEurocopter AS 365 N2 DAUPHIN · S/N 6476N612BFEvolution Trikes REVO · S/N 1010N612VTTurnbull Carl Norman SILHOUETTE · S/N SA-212N61323Cessna A185F · S/N 18504147N614JKCessna S550 · S/N S550-0018N61FMAgusta-Bell A 109A · S/N 7197N622HABombardier CL-600-2B16 · S/N 6224N6265DCessna 172N · S/N 17272676N627HCurtiss Wright TRAVEL AIR S-6000-B · S/N 6B-2005N6281ZCessna T182T · S/N T18208866N6283VCessna 172RG · S/N 172RG0608N62926Cessna T206H · S/N T20608854N6293ECessna 172 · S/N 46393N629RTLeonardo AW139 · S/N 31269N6334VHelio H-295 · S/N 1226N63554Cessna 180K · S/N 18052854N63936Beech A36 · S/N E-2053N640Grumman/Mckinnon Enterprises G21G · S/N 1201N6413RPiper PA-28-140 · S/N 28-21592N650RGGulfstream Aerospace GVI · S/N 6004N650WACessna 650 · S/N 650-0047
Back to Portland, OR