Oregon City, OR
Registered aircraft · 89
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 = 'OREGON CITY' 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 = 'OREGON CITY' 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.
N11FBJohn P Pike FLY BABY · S/N 4130N1433WAerospatiale GAZELLE SA341F2 · S/N 1433N1459BLuscombe 8F · S/N 6086N1645Cosmer Gary M S-21 OUTBOUND · S/N 10230352N171SCTextron 172S · S/N 172S12589N1773RCessna R182 · S/N R18200554N181SCTextron 172S · S/N 172S11663N18GXMooney M20M · S/N 27-0318N18HVVeenker Harlen G VANS RV8 · S/N 80290N191SDScott Crockard VANS RV-9A · S/N 90927N1981BDavid Burkhardt VORTEC M912 GYROCOPT · S/N 159N20524Taylorcraft A · S/N 529N217JRJavier Rodriguez RV-14A · S/N 140217N223APTextron 172S · S/N 172S13440N23245Piper J3F-60 · S/N 3013N23981Aeronca 65-C · S/N C6379N2460EDJI AGRAS T40 · S/N 1581F574B226S00102D2N2530LCessna 172H · S/N 17255730N261SCTextron 172S · S/N 172S13439N280SCTextron 172S · S/N 172S12443N282CDCirrus Design SR22 · S/N 1136N288SCTextron 172S · S/N 172S13240N2978CCessna 180 · S/N 30878N298SCTextron 172S · S/N 172S13241N2ABPiper PA-24-250 · S/N 24-1941N313GAHesse Robert R C GLASAIR III · S/N 333AN320SCTextron 172S · S/N 172S13352N330CStinson 108-2 · S/N 108-3330N3477NPiper J3C-65 · S/N 22923N34NDDodge Norman A GLASTAR (GS-1) · S/N 5407N3576TTaylorcraft F19 · S/N F-042N360KRBeech D50E · S/N DH-320N3713FCessna 172H · S/N 17255208N375NAEavision EA-J150 · S/N JMZKJ150UAV602595261N3787APiper PA-18A · S/N 183054N38FUEa Vision EA J100 · S/N 85711N400TGCessna 525B · S/N 525B0195N407SCTextron 172S · S/N 172S12588N423SCTextron 172S · S/N 172S12542N438SCTextron 172S · S/N 172S12225N4428AEa Vision EA J100 · S/N 85662N4511VPiper PA-28-236 · S/N 28-7911293N46703Cessna 172K · S/N 17257439N46PSJohn P Pike S1 · S/N JP10N4783NCessna 182Q · S/N 18267366N4910KRyan NAVION A · S/N NAV-4-1910N499APiper PA-28RT-201T · S/N 28R-7931091N512ESEric G Stacey ZENITH STOL CH 701 · S/N 7-10426N51469Cessna T-50 · S/N 6644N53019Fairchild M-62A · S/N T43-5050
Back to Oregon City, OR