Redmond, OR
Registered aircraft · 71
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.
N10XRRatzlaff Ray RATZLAFF EZ-1 · S/N 1845-LN1166MCessna 182P · S/N 18264238N1183ABeech V35A · S/N D-9006N123HHSchempp-Hirth VENTUS-2B · S/N 168N126SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1169N12CKChristen Industries PITTS S-2B · S/N 5179N12DUCessna TU206G · S/N U20605202N138BSBurroughs Bruce BRUSH 1 · S/N 001N142CJJones Colby C RV-9A · S/N 91286N1514KArbc Inc DBA Lindstrand 90A · S/N 5340N155SBSamson Sky SG1P · S/N 001N1651PPiper PA-18-135 · S/N 18-3766N16SWWilliams Robert S L-IV · S/N 066N173BGGinsberg Robert J VELOCITY 173 FXD GR · S/N DM0257N182LHCessna 182H · S/N 18256305N185UVCessna 185 · S/N 185-0171N1979GGulfstream American AA-5B · S/N AA5B1041N199LMkii LANCAIR 2000 · S/N 2000-001N20262Cessna 172M · S/N 17261138N217EDonald E Eccker VANS RV-8 · S/N 81177N2217ZKubicek Factory S R O BB51Z · S/N 1906N228TJEpic E1000 · S/N K023N2292Alvin C Lash ZENITH CRUZER · S/N 10400N231WAGilbert B Shepherd SPORT COPTER SUPER · S/N 149N23295Cessna 150H · S/N 15068855N2355PCessna T182T · S/N T18208750N23642Beech F33A · S/N CE-759N2423NHead Balloons AX8-105 · S/N 431N256MALemaire Filidauro LANCAIR IV-P · S/N LIV-461N305PRMooney M20K · S/N 25-1206N3070ZPiper PA-28RT-201T · S/N 28R-7931174N3105UAyres S2R-G6 · S/N G6-108N313GGKodiak KODIAK 200 · S/N K2-0004N3185FCessna 182J · S/N 18257285N3234ACessna 170B · S/N 25878N3344RCessna 182L · S/N 18258644N3438MPiper PA-12 · S/N 12-2276N38368Piper PA-32R-300 · S/N 32R-7780419N41KSMax Kay SPORTSMAN GS-2 · S/N 7494N42139Piper J3C-65 · S/N 14365N440CHFerd Kuhn / Bill Schirding KUHN CYGNET SF-2A · S/N C-5095N4445MPiper PA-12 · S/N 12-3399N4707APiper PA-18-150 · S/N 18-4924N4RMCessna U206B · S/N U206-0683N4WWCessna 210-5A(205A) · S/N 2050530N500SGPiper PA32-301FT · S/N 3232020N5112ECessna 180B · S/N 50412N525TTTompkins Landing EPIC LT · S/N 006N55334Boeing A75N1 · S/N 75-869N557LLee A Brinley LANCAIR ES-P · S/N ESP-188
Back to Redmond, OR