Hood River, OR
Registered aircraft · 337
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 = 'HOOD RIVER' 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 = 'HOOD RIVER' 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.
N10115Fletcher E H LONGSTER III · S/N 3N10402Laird LC-1B-300 · S/N 188N106SCSaint Louis YPT-15 · S/N 106N1071DCessna 195A · S/N 7683N1071NPiper J3C-65 · S/N 13284N11016Spartan C2-60 · S/N J-3N11076Alexander FLYABOUT D-2 · S/N 3005N1155QOberlerchner MG23SL · S/N 18N11715Curtiss Wright TRAVEL AIR 12-W · S/N 12W-2040N11872Universal Moulded Products MONOCOACH · S/N 5012N118BZPiper PA-18-150 · S/N 18-8647N1205PPiper J3C-65 · S/N 17630N12087Bell 47D1 · S/N 734N120MWLet L 33 SOLO · S/N 000513N12146Stinson W · S/N 3054N123GAAvolio Gennaro W HP-14 · S/N 14-56N12423Aeronca C-3 · S/N A189N12454Fairchild 22 C7B · S/N 1503N12610Taylor E-2 · S/N 18N12627Piper E-2 · S/N 32First renewal noticeN1270NGaroutte Byron J FLYBABY 1A · S/N 5764-2004N127MCHood Tech Corp Mechanical HTMC-40-PLUS · S/N HTMC-0021N1282Curtiss JN4D · S/N 1N13000Aeronca C-3 · S/N A-215N13027Waco UBF · S/N 3660N13041Waco UBA · S/N 3595N13271Franklin 90 · S/N 106N1339Travel Air 4000 · S/N 214N13572Waco UIC · S/N 3821N135PCPiper L-21B · S/N 53-7731N136MCHood Tech Corp Mechanical HTMC-40-PLUS · S/N HTMC-0022N139EWaco 9 · S/N 218N13DMHood Tech Corp Mechanical HTMC-40 · S/N HTMC-0048N1418CPiper PA-22 · S/N 22-1175N14310Piper PA-18-150 · S/N 18-8309023N14316Piper PA-18-150 · S/N 18-7409077N1431BPiper PA-18-150 · S/N 18-4562N1431DPiper PA-18-150 · S/N 18-5303N1431ECessna A185F · S/N 18503840N14365Piper PA-18-150 · S/N 18-7409092N143YWaco RNF · S/N 3417N1471HAeronca 15AC · S/N 15AC-541N1473Curtiss Wright TRAVEL AIR 4000 · S/N 222First renewal noticeN14KBird A · S/N 1060N15195Franklin Glider PS-2 · S/N 140N151YDavis D-1-K · S/N 510N151ZGCessna T206H · S/N T20608588Sale reportedN15700Waco YPF · S/N 4375N161SRCirrus Design SR22 · S/N 2120N1642BLuscombe 11A · S/N 11-148
Back to Hood River, OR