Spokane Valley, WA
Registered aircraft · 68
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 = 'SPOKANE VALLEY' 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 = 'SPOKANE VALLEY' 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.
N104CXBeech B200 · S/N BB1004N10615Cessna 150L · S/N 15074925N10PXCirrus Design SR22T · S/N 1453N147WHAndrew J Russell RV-7 · S/N 71460N15083Piper E-2 · S/N 222N1563HCessna 177RG · S/N 177RG0737N16111Avian Balloon MAGNUM IX · S/N 167N167AVWalter Forey X-ROCKET · S/N 167N172MZDiamond Aircraft Ind DA 40 · S/N 40.730N185PMCessna A185F · S/N 18503415N185WYCessna A185E · S/N 185-1229N206SNCessna TU206G · S/N U20605101N21215Cessna 182P · S/N 18261494N212TNRoth Lonnie R HI-MAX · S/N 265N224HCessna 180 · S/N 32649N231NPMooney M20K · S/N 25-0111N2487SCessna R182 · S/N R18201344N248RCCessna T206H · S/N T20608141First renewal noticeN2537VCessna 170 · S/N 18041N2569WMooney M20E · S/N 930N2684APiper PA-18-135 · S/N 18-2190N287RVAllbee S/Allbee C RV-7A · S/N 71925N29616Walter SKYHAWK · S/N 11N297TCCessna 172R · S/N 17280016N3079FCessna 182J · S/N 18257179N3451CCessna 170B · S/N 26494N356PTCessna R182 · S/N R-18201584N4400CCessna 195 · S/N 7985N44AVAvian Balloon FALCON II · S/N 44N4538TPiper PA-28-180 · S/N 28-7205190N455BTBeech 95-B55 · S/N TC741N457BCCessna 172M · S/N 17264589N4635HPiper PA-17 · S/N 17-50N471ZCDJI AGRAS T50 · S/N 63YBM8C00200D1N477PRBeyers Johannes J KITFOX IV · S/N 1822N481PCessna U206G · S/N U20603684N50288Avian Balloon SKYHAWK · S/N 179N5459CCessna 170A · S/N 19493N5498ZPiper PA-22-108 · S/N 22-9284N555KVLundy-Kearney SONERAI-II · S/N 439N567GSCessna 150L · S/N 15072751N590RZChristen Industries PITTS S-2B · S/N 5185N5962WPiper PA-28-150 · S/N 28-3821N6053DPiper PA-20-150 · S/N 22-4706N61215Cessna 150J · S/N 15070892N616EAPilatus PC-12/45 · S/N 616First renewal noticeN64650Boeing B75N1 · S/N 756534N6468BCessna 172 · S/N 29668N70047Avian Balloon MAGNUM IX · S/N 124N7268KCessna 182S · S/N 18280491
Back to Spokane Valley, WA