Eugene, OR
Registered aircraft · 209
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 = 'EUGENE' 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 = 'EUGENE' 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.
N101PGCessna 680 · S/N 680-0336N102PGIai GULFSTREAM G280 · S/N 2248N106CJCessna 525 · S/N 525-0006N1088RCessna 560XL · S/N 560-6156N108WBell 206-L4 · S/N 52034N111BGSchleicher ASW-17 · S/N 17008N112DSCessna 182Q · S/N 18265826N112WAWallace Anderson/Eric Nordlund RV9A · S/N 91108N1152SVans RV-12IS · S/N 121052N122LDVans RV-12 · S/N 120247N132JPParsons John C PITTS SPECIAL S-1S · S/N 001-JPN1448VCessna R172K · S/N R1722193N147BCAmerican Champion 8GCBC · S/N 447-2003N14WEEckertson Wayne RANS-S14 · S/N 0804139N15WAAviat PITTS S-2B · S/N 5247N164BJJoseph P May VANS RV-6 · S/N 20248N172FNCessna 172R · S/N 17280004N1757FCessna 172H · S/N 17255152N180TDMaule MX-7-180C · S/N 28011CN184RBAlbertson Rw/Mathews JD RV-8 · S/N 81297N185RXCessna A185F · S/N 18504118N19252Taylor J-2 · S/N 1652N1991MMcgirr Stephen J VANS RV7 · S/N 73773N2001HEngineering & Research ERCOUPE 415-C · S/N 2624N2023SJohn Kidd QUAD CITY CHLNGR II · S/N CH2-0405-2620N20615Fairchild 24 J · S/N 3407N2172LBeech 95-B55 (T42A) · S/N TC-2020N21KCCampbell KR-1 · S/N KAC-1N2203MPiper PA-28-161 · S/N 28-7816258N22074Silvaire LUSCOMBE 8A · S/N 900N225ERyan NAVION · S/N NAV-4-1160N2272QPiper PA-28-161 · S/N 28-7716094N228PKBombardier BD-100-1A10 · S/N 20730N2335NCessna 140 · S/N 12575N2341WBeech A23A · S/N M-940N23YCCessna 550 · S/N 550-0923N2401RCessna 182G · S/N 18255501N2510PMax Holste 1521 · S/N 283N257CTPiper PA-28-161 · S/N 287816053N25LRBeech A36TC · S/N EA-196N2718UCessna 172D · S/N 17250318N273VPDJI AGRAS T40 · S/N 52LBK6R00100LFN275SHLynch John N GLASTAR · S/N 001N27NCWay Norman Robert PITTS S1 · S/N NW-3N28JGCirrus Design SR22T · S/N 1130N28PGPiper PA-28-161 · S/N 28-7916405N300MTEmbraer EMB 312F · S/N 312500N3014TScottish BULLDOG MDL 120/121 · S/N BH120/212N3037CCessna 162 · S/N 16200114N30861Cessna 177B · S/N 17701511
Back to Eugene, OR