Dodge City, KS
Registered aircraft · 35
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 = 'KS' AND g.registrant_city = 'DODGE CITY' 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 = 'KS' AND g.registrant_city = 'DODGE CITY' 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.
N109LLBeech A36 · S/N E-2626N212KSPiper PA-31T1 · S/N 31T-7904010N215CGClifford L George ESCAPADE · S/N JA215-08-10N219DCMike Weber / Jason Mccabe S21 · S/N 11180026N2466RCessna 182G · S/N 18255566N276DCCrotts Leigh F1 · S/N 107N3304CBeech E35 · S/N D-3970N3510ACessna 172R · S/N 17281042N365FCessna 421C · S/N 421C0854N391ECessna 310D · S/N 39131Registration pendingN395LMCirrus Design SR22 · S/N 1395N40826Piper J3C-65 · S/N 7534N424AJCacioppo Mark S S7S COURIER · S/N 0107450N426PTHawker Beechcraft G36 · S/N E-3783N445NSRobert E Stanton CUBBY · S/N 79470N4964GCessna 172N · S/N 17273511N625LMBeech F33A · S/N CE-1600N724LLCirrus Design SR22T · S/N 9011N726RTCessna 421C · S/N 421C0087N733FRCessna 172N · S/N 17268265N74733Grumman American Avn. AA-5B · S/N AA5B0357N75245Cameron Balloons US V-77 · S/N 5837First renewal noticeN763NAHylio HYL-150 · S/N 17906110524N764NAHylio HYL-150 · S/N 17906110525N8036VBeech A36 · S/N E-2693N818SFPiper PA-31T1 · S/N 31T-8004018N81LDHayden CCK-1865 · S/N CCK-1865-1052N8349TCessna 175C · S/N 17557049N864RBeech 35-33 · S/N CD-19N8777XCirrus Design SR22 · S/N 1011N880KW880kw AL18 · S/N AL-368N885BSLucky Dog AL18 · S/N AL-374N888EDCessna 421B · S/N 421B-0421First renewal noticeN9010MCessna 182P · S/N 18264641N989WCubcrafters CC11-160 · S/N CC11-00213
Back to Dodge City, KS