Redmond, OR
Registered aircraft · 72
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 = 'REDMOND' 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 = 'REDMOND' 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.
N623NSNicholas C Thompson VL3 EVOLUTION · S/N SN 463N62GGReduction Drive Motors LANCAIR ES · S/N ESDD-199N6752FCessna 150F · S/N 15063352N6882FCessna 150F · S/N 15063482N698WWolstenholme Robert F EVOLUTION · S/N EVO-027First renewal noticeN707PMWindward Performance SPARROW HAWK · S/N 10N7130Lash Alvin C RV 7 · S/N 72113N7139LRobinson Helicopter R22 BETA · S/N 2970N71LXHogarty William A LANCAIR IV P · S/N 101N7243NCessna 140 · S/N 14786N75100Boeing A75N1(PT17) · S/N 75-2605N7541CForney F-1 · S/N 5656N760TXJohn T Cooley CCK-1865 · S/N CCK-1865-0059N761GGCessna A152 · S/N A1520951N7922UCessna 150M · S/N 15077861N8086URans Employee Flying Club RANS S-6S COYOTE II · S/N 12981282N8517VRockwell International S-2R · S/N 2277RN8974QAero Commander S2R · S/N 1644RN923SYSteven Young CCK-1865 · S/N CCK-1865-1065N9245TCessna 180C · S/N 50745N924SKDavis Steven J RV-14A · S/N 140807N96MEMaule MXT-7-180 · S/N 14071CRegistration pending
Back to Redmond, OR