Spokane, WA
Registered aircraft · 287
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' 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' 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.
N107TGGarland Christopher J LANCAIR LEGACY · S/N L2K-279N1142NBoeing A75N1(PT17) · S/N 75-3409N11571Cessna 150L · S/N 15075531Sale reportedN116MGGoldner Leslie M CHALLENGER II · S/N CH2-0204-2452N11XPMcholland XPA-11 · S/N 1N121UAero C-104 · S/N 215N123ZMCirrus Design SR20 · S/N 2348N12830Cessna 172M · S/N 17262296N135DMCessna 180J · S/N 18052635N13832Piper PA-23-250 · S/N 27-4474N1441SCessna 182P · S/N 18264989N1456SCessna 182P · S/N 18265004N145AJCirrus Design SR22 · S/N 2082N1489DCessna 170A · S/N 20091N151DFWilson ART W RV-6 · S/N 20917N1528EAeronca 7DC · S/N 7AC-5091N157JTBeech B-60 · S/N P-589N16591Waco EQC-6 · S/N 4490N16771Cessna 150G · S/N 15066452N16BZBattles Brenton E ZODIAC 601 HD · S/N 1N1722HCessna 310C · S/N 35822N1723CCessna 180 · S/N 30423N1755DCessna 170A · S/N 20198N1786JPiper PA-28-140 · S/N 28-24209N17LWWestermeyer Leonard A RV-7A · S/N 74595N185RTCessna A185F · S/N 18502159N1882JRockwell International 112TC · S/N 13034N18FSMcfarland Alan R QUICKIE 200 · S/N 2742N197BROstendorf Robert Lee KITFOX SERIES 5 · S/N S9602-0173N202AVCessna 650 · S/N 650-7108N2051RCessna 182G · S/N 18255251N20EXExtra-Flugzeugbau 300/S · S/N 020N2145YCessna 172D · S/N 17249645Registration pendingN215SCBell OH-58 · S/N 70-15148N21QQShilling E E Q-2 · S/N 2005N2240DPiper PA-34-200T · S/N 34-7970032N2245VCessna 140 · S/N 14519N225CVCirrus Design SF50 · S/N 0612N22WDMooney M20F · S/N 680110N231QMMooney M20K · S/N 25-0362N233CUSchweizer SGS 2-33A · S/N 206N2361HEngineering & Research ERCOUPE 415-C · S/N 2986N23670Taylorcraft BL-65 · S/N 1403N2384UCessna 172R · S/N 17280708N2389VCessna 172R · S/N 17280729N238TWCessna 172P · S/N 17275287N2426VLet BLANIK L-13 · S/N 026502N24336Cessna 172R · S/N 17280888N245FGlasflugel H 301 LIBELLE · S/N 49N248EBeech D17S · S/N 6871
Back to Spokane, WA