Corvallis, OR
Registered aircraft · 112
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 = 'CORVALLIS' 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 = 'CORVALLIS' 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.
N101PPeterson J4 · S/N 001N124CSVans RV-12 · S/N 120080N134ABeech A45 · S/N G-59N150MFOMF OMF-100-160 · S/N 0015N172HWCessna 172S · S/N 172S8407N176AZArctic S-1B2 · S/N 1027N1780Mccollom George W RV6 · S/N 60352N1999WMooney M20J · S/N 24-1564N21972Cessna 150L · S/N 15074580N23MXTony Hesseen MXR MX2 · S/N 6N2425VCessna 140 · S/N 14673N25103Luscombe 8A · S/N 1027N2534SSixchuter SPIRIT XL · S/N 2944N2596QCessna 182K · S/N 18257796N26JSSmith Jim E MA-5 CHARGER · S/N 29N291DVCessna 560XL · S/N 560-5146N292FMRoibert M Ingle FMX-4 · S/N 1002N300SBSchneider K/Cook C SC SKYBOLT · S/N 001N3014XPiper PA-32-300 · S/N 32-7940094N304GSCanadian Car & Foundry HARVARD MK IV · S/N 20328N3170BCessna 650 · S/N 650-0136N326SXEstumkeda Ltd DBA Micco Acft MAC-145B · S/N 260003N34034Taylorcraft BC12-65 · S/N 2885N3405ZPiper PA-22-150 · S/N 22-7317N34420Cessna 177B · S/N 17701794N34DVVaughan Don K RV 4 · S/N 1619N3529NCessna 182T · S/N 18280981N3568JCessna 150E · S/N 15061268N356EDJI SPREADING WINGS S900 · S/N CH231936182746N3725PPiper PA-22-150 · S/N 22-3443N3728UCessna 182G · S/N 18255128N37299Interstate S-1A · S/N 142N3764MPiper PA-12 · S/N 12-2696N3911VCessna 170 · S/N 18221N39NSAviat A-1B · S/N 2003N4149EMooney M-18C · S/N 315N421ESCessna 421C · S/N 421C0801N42486Cessna 180J · S/N 18052357N4281LCessna 172G · S/N 17254350N42QQCordy Clifford B JR QUICKIE 2 · S/N 2055N43875Schweizer G-164B · S/N 766BN43964Taylorcraft BC12-D · S/N 7623N444HTCessna T310Q · S/N 310Q0739N4608CCessna T210N · S/N 21063572N4888FCessna TU206A · S/N U206-0588N49TRBeech V35B · S/N D-9628N50AUCessna A185E · S/N 1851368N5123YCirrus Design SR22 · S/N 0886N51PHCessna 180H · S/N 18051478N541FZMX MXS · S/N MXS-003
Back to Corvallis, OR