OpenAirDocs.org
Mcpherson, KS

Registered aircraft · 28

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 = 'MCPHERSON'
  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.

N1078LSmith David W SUPER CAT DS-1 · S/N 121339Built 2002 · Smith David WN123EZMusso RACER ORIGINAL · S/N M14372Walline Christopher CN1279MCessna 182P · S/N 18264272Built 1975 · Sturdy Wings Aviation LLCN13806Cessna 172M · S/N 17263010Built 1974 · Mpr Aviation LLCN152HWCessna 152 · S/N 15281995Built 1978 · Wuertz Errol Gene JrN1803MCessna 182P · S/N 18264454Built 1975 · Whitfield EdwardN1939TTaylorcraft BL-65 · S/N 1870Built 1940 · Dickhudt Gene RN2371WBeech A23-19 · S/N MB-9Built 1966 · Spaich Brad GN3104NCessna 120 · S/N 13362Ward David CN3302YCessna 182E · S/N 18254302Built 1962 · Foster James RN42122Powrachute PEGASUS · S/N A002ULSBuilt 2003 · Mann Stephan LN4255DBeech G35 · S/N D-4478Built 1956 · Sprague Dale MN448MJPiper PA-32-260 · S/N 32-772Built 1966 · Wilson Darrell Gene IIIN5053BBeech F35 · S/N D-4332Walline ChristopherN5397WFisher Michael E CLASSIC · S/N C001Driskill Clyde JN56971Powrachute PC 2000 · S/N A-286POWBuilt 2002 · Dickhudt Gene RN5910ACessna 172 · S/N 28510Built 1956 · Alumbaugh Ian MN601KMMeiste C/Meiste G ZODIAC 601 · S/N MEISTE-1Rohn DavidN6026QMooney M20C · S/N 3234Built 1965 · Kosmata Charles CN616NBerwick Special II · S/N 1Built 1972 · Logback Michael RN6483HPiper J3C-65 · S/N 19665Built 1946 · Johnson Chad RN6910XCessna 172B · S/N 17247810Registration pendingN7096FCessna 150F · S/N 15063696Built 1966 · January Lynn EN71295Luscombe 8A · S/N 2722Built 1946 · Logback Michael RN717RMJohnson Chad R WAIEX · S/N W0050Built 2022 · Johnson Chad RN8487WPiper PA-28-180 · S/N 28-2731Built 1965 · Wilson Darrell IIIN8731SCessna 150F · S/N 15062031Lawrenz Richard AN97998Stinson 108-1 · S/N 108-998Built 1946 · Walline Chris
Back to Mcpherson, KS