Moses Lake, WA
Registered aircraft · 170
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 = 'MOSES LAKE' 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 = 'MOSES LAKE' 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.
N100WBBeech 65-A90 · S/N LJ-139N1127NAeronca 7BCM · S/N 7BCM-88N115DHankins Harold D ZODIAC 601XL · S/N 6-5530N1342CPiper PA-20-135 · S/N 20-977N15VLLynn Vernon D ROTORWAY EXEC 162F · S/N 6325N16533Aeronca C-3 · S/N A675N1813KLuscombe 8E · S/N 4540N184DBeech 300 · S/N FA-132N1889GChampion 7KCAB · S/N 93N18966Beech B19 · S/N MB-869N190DFCessna 190 · S/N 7786N1919QCessna 177RG · S/N 177RG0319N192CMCessna TU206G · S/N U20606160N1987LBeech B19 · S/N MB-806N201CStinson 108-2 · S/N 108-3201N2047ABeech B19 · S/N MB-899N2048ABeech B19 · S/N MB-904N2059LBeech B19 · S/N MB-808N20BWPiper PA-32R-300 · S/N 32R-7680355N2146SAyres S2R-G10 · S/N G10-149N217LCDJI AGRAS T40 · S/N 5X5BLEG0020AU1N22711Beech B19 · S/N MB-865N228CPCessna 182Q · S/N 18266514N2318HErcoupe 415-C · S/N 2943N2352BCessna 182S · S/N 18280416N23604Taylorcraft BL-65 · S/N 1328N23ESNorth American T-28A · S/N 49-1620N248KDTwo J'S CCX-2300 · S/N CCX-2300-0058N248KMCirrus Design SR22T · S/N 1458N2503NPoland Mig17 LIM 6 · S/N 1F0319N2535LLancair LC41-550FG · S/N 41082N26024Piper PA-28-181 · S/N 28-8690005N2619RCessna 182K · S/N 18258319N262PMBeech F33A · S/N CE-1681N2692HSchweizer SGS 2-33A · S/N 526N2705ZSchweizer SGS 1-26B · S/N 241N2752SCessna 150G · S/N 15066652N284QEDJI AGRAS T20P · S/N 1581F574B236E00100ZGN291SDCross Country Aviators RV-10 · S/N 40535N302CBlackman Roger L P 40 C · S/N 001N30757Air Tractor AT-802A · S/N 802A-0534N3106QCessna 182K · S/N 18258106N3139EChampion AERONCA 7AC · S/N 7AC-6736N32338Piper PA-28-151 · S/N 28-7515132N3335APiper PA-22-135 · S/N 22-1612N35469Cessna 172I · S/N 17256786N355CBMaule M-7-235 · S/N 4091CN36137Bellanca 7GCBC · S/N 542-73N36174Bellanca 7ECA · S/N 958-73N3621XPiper PA-28-181 · S/N 2881010
Back to Moses Lake, WA