Yakima, WA
Registered aircraft · 135
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 = 'YAKIMA' 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 = 'YAKIMA' 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.
N1003ACessna P210N · S/N P21000078N115GBDJI PHANTOM 3 PROFESSION · S/N 03Z0132989N11XYAndre George M PITTS S1S · S/N GMA-2N122NBCessna 550 · S/N 550-0836N12447Cessna 172M · S/N 17261988N1264DCessna 170A · S/N 19840N126CN126c CCX-1865 · S/N CCX-1865-0016N126EKAlisport SILENT-IN · S/N 039N128TTCessna U206G · S/N U20604991N1364APiper PA-18-125 · S/N 18-1190N14JYL-Bird CCX-2000 · S/N CCX-2000-0026N165CCCubcrafters CC11-160 · S/N CC11-00122N16XCCub Crafters CC19-215 · S/N CC19-0115N17SHCoplen Randy SPARROWHAWK · S/N SH20030005KN17ULCubcrafters CC11-160 · S/N CC11-01001N190XCCub Crafters CC19-180 · S/N CC19-0001N19859Cessna 172M · S/N 17260811N213Cub Crafters CC19-215 · S/N CC19-0114N21ULCubcrafters CC11-160 · S/N CC11-01008N224BTCirrus Design SR22 · S/N 0370N229WACirrus Design SR22T · S/N 0616N231RXMooney M20K · S/N 25-0305N234CChamberlain Mark VANS RV-7 · S/N 72406N2380RCessna 182G · S/N 18255480N247AZCub Crafters CC19-215 · S/N CC19-0113N250ULN250ul CCX-1865 · S/N CCX-1865-2046N2557PPiper PA-22-150 · S/N 22-2920N262EHare Walter G LONG EZ · S/N 262N264SWRaytheon A36 · S/N E-3190N26UTCub Crafters CC19-215 · S/N CC19-0112N26XCCub Crafters CC19-215 · S/N CC19-0110N2790WMooney M20E · S/N 1068N296EJJean Bernard Tremblay CCX-2300 · S/N CCX-2300-0107N3033DPiper PA-28-161 · S/N 28-7916157N30PYCub Crafters CC19-215 · S/N CC19-0102N345SSaacks CCK-2000 · S/N CCK-2000-0019N358BVGamache Bernard J FLS MICROJET · S/N 007N358ELGavilan EL-1 · S/N E1N361WBCubcrafters CC11-160 · S/N CC11-00445N363EXN126c CCX-2000 · S/N CCX-2000-0001N363LXJacek Ciesielski CCX-2000 · S/N CCX-2000-0225N376ULN376ul CCX-1865 · S/N CCX-1865-1016N379PKCub Crafters CC19-215 · S/N CC19-0103N384SAIniziative Industriali Italian SKY ARROW 650TCN · S/N CN006N397CCCub Crafters CC19-180 · S/N CC19-0002N39MLDavid Lake XENOS MOTOR GLIDER · S/N X0069N4033Stanley E Franz RV8-QUICK BUILD · S/N 83701N4087VCessna 170 · S/N 18419N415SFFranz Stan BUSHWACKER · S/N 001N416GCirrus Design SR22 · S/N 0310
Back to Yakima, WA