Portland, OR
Registered aircraft · 546
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.
N8388SCessna 182H · S/N 18256488N83WAPilatus PC-12/47E · S/N 1803N841DWCessna 560XL · S/N 560-5177N841KAeropro CZ S R O A220 · S/N 62721N8462DPiper PA-18A 150 · S/N 18-6161N846SASikorsky UH-60L · S/N 87-24639N84XPBeech 200 · S/N BB481N85021Aeronca 7AC · S/N 7AC-3746Registration pending, pending cancellationN851JGT-28a Restorations T-28A · S/N 51-7708XN8533FKenneth S Shinn ROTORWAY EXEC 90 · S/N 3542N8556BCessna 172 · S/N 36256N857RVDoughty Robert J RV-8A · S/N 80857N85PLRaytheon 390 · S/N RB-55N86DFMark S Jardini RISEN · S/N 23N8741VBellanca 7GCBC · S/N 849-75N87784Piper J3C-65 · S/N 15442N8787YCirrus Design SR22 · S/N 1589N880GXEpic E1000 · S/N K080N8812XCessna 182D · S/N 18253212N8814NPiper PA-28-140 · S/N 28-25661N886JMCirrus Design SR22T · S/N 0155N890VBUltramagic M-90 · S/N 90/115N8926UBeech 35-C33 · S/N CD-946N8929JPiper PA-28-180 · S/N 28-2947N8933WPiper PA-28-235 · S/N 28-10500N8958PPiper PA-24-260 · S/N 24-4415N8UFAgusta A109A II · S/N 7268N9066XCessna 182D · S/N 18253466N9085ZBalloon Works FIREFLY 7-15 · S/N F7-882N910TWCessna R172K · S/N R1723279N91502North American NAVION · S/N NAV-4-297N9165DPiper PA-22-160 · S/N 22-6218N918MMBeech F90 · S/N LA-52N918MTBeech F90 · S/N LA-211N918TFPiper PA-12 · S/N 12-2232Registration pendingN920KPiper PA-28-151 · S/N 28-7415038N9219QBeech V35B · S/N D-9265N9221PPiper PA-24-260 · S/N 24-4718N9221QBeech V35B · S/N D-9264N9228MMooney M20E · S/N 1185N924TDCessna 525B · S/N 525B0371N92638Cessna 182N · S/N 18260291N9269JPiper PA-28-180 · S/N 28-3346N927SJNeil J Axel LOCKWOOD AIR CAM · S/N AC317-3N93202Cessna A185F · S/N 18503198N9320XCessna 182R · S/N 18268488N9375MMooney M20E · S/N 1307N939ZAgusta AW139 · S/N 31061N9430LAmerican AA-1A · S/N AA1A-0230N9438VMooney M20C · S/N 700071
Back to Portland, OR