Redmond, WA
Registered aircraft · 55
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 = 'WA' 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 = 'WA' 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.
N106EJSilvers Richard V VANS RV-6 · S/N RS001N117ZSEfstathios Papaefstathiou SLING TSI · S/N 654SQN132GCirrus Design SR22T · S/N 8913N1430MCessna 182P · S/N 18264328N14VMSmith AEROSTAR 601P · S/N 61P-0319-088N167EAPipistrel D O O ALPHA TRAINER · S/N 1229 AT 912 LSAN1701RCessna A185F · S/N 18502423N197GGruenitz Sven SPORTSMAN GS-2 · S/N 7413N19JGCessna 175 · S/N 55131N243KPArrow Falcon Exporters OH-58A+ · S/N 70-15243N269TCSchweizer 269C · S/N S1776Registration pending, pending cancellationN303PPiavis James W PIAVIS RV-7 · S/N 70885N33GXMooney M20R · S/N 29-0333N341GWEurocopter SA341F2 · S/N 1541N350SFLancair LC42-550FG · S/N 42062N3786RCessna 172H · S/N 17255586N3991HMooney M20K · S/N 25-0406N40NGONG Timothy LANCAIR ES · S/N ES-086N422HJRyan NAVION B · S/N NAV-4-2289BN425TVCessna 425 · S/N 425-0176N4451WBeech F33A · S/N CE-491N459CDCirrus Design SR22 · S/N 1535N475TVPiper PA-30 · S/N 30-1366N501MBCessna 501 · S/N 501-0122N52319Aerostar International RXS-8 · S/N RXS8-3095N52BTTrubee Brian RV-4 · S/N 2366N54528Hughes Helicopters HUGHES 369D · S/N 390464DN5578WPiper PA-28-150 · S/N 28-685N55LKSchempp-Hirth Flugzeugbau DUO DISCUS T · S/N 45N55MMCirrus Design SR22T · S/N 8740N55XKYakovlev YAK-55M · S/N 920702N5762UPiper PA-28-140 · S/N 28-26586N58591Cessna 182P · S/N 18262162N61MVEvent 38 E455 · S/N 455020N6237LAmerican AA-1 · S/N AA1-0437N62MVEvent 38 E455 · S/N 455021N6688VBellanca 17-30 · S/N 30017N70208Cessna A185E · S/N 18502058N740SHInnovator Technologies MOSQUITO XE · S/N MXE1022A07N7576NCessna TU206G · S/N U20603683N7711BCessna 510 · S/N 510-0230N7778QCessna 310Q · S/N 310Q0278N782MBBennett Taves SLING TSI · S/N 453SKN79GWCirrus Design SR22T · S/N 1988N8166JPiper PA-34-200T · S/N 34-8070146N858Schleicher ASW-15B · S/N 15231N86261Cessna 182P · S/N 18261922N8662RSchweizer SGS 1-26A · S/N 190N8817ZCessna 172H · S/N 17255467Registration pendingN89SFCessna 177RG · S/N 177RG1003
Back to Redmond, WA