OpenAirDocs.org
Mitchell, SD

Registered aircraft · 47

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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 = 'SD' AND g.registrant_city = 'MITCHELL'
  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.

N104PMCessna 182K · S/N 18258085Pats Offroad IncN1171QCrawford Kirby L PRECEPTOR ULTRA PUP · S/N KLC001Built 1997 · Koch Carl JN164WGWhiskey Gulf AF Inc/Glojek GLASAIR I · S/N 164Built 1990 · Bug Smasher LLCN203BDDJI AGRAS T30 · S/N 527BK6P00100BPLeland Dennis GN2145EAeronca 7EC · S/N 7AC-5716Built 1946 · Krall Jeff PN218ZGDJI AGRAS T30 · S/N 4CZBJ5W00102LRLeland Dennis GN223RFJason Arnold KITFOX IV 1200 · S/N 1773Built 2021 · Edinger Charles FN2276CBeech F33A · S/N CE672Built 1976 · Leading Edge Consulting LLCN23101Piper J3F-50 · S/N 2883Built 1939 · Lark Enterprises LLCN253ZZDJI AGRAS T50 · S/N 63YBLB2002001XNeugebauer Spencer PN25LErcoupe G · S/N 5025Krall James MN268NQDJI AGRAS T40 · S/N 64TBL7K002007XMitchell TechN2745GCessna 414A · S/N 414A0622Built 1980 · Kj3 Air LLCN28217Piper J4F · S/N 4-1142Rebransco LLCN286YMYoung Robin GLASAIR-WRY · S/N 286Built 1983 · Bug Smasher LLCN3200NRaytheon A36 · S/N E-3200Built 1998 · Lazy Bones LLCN337BTCessna T337E · S/N 33701223Built 1969 · Krall JeffN35452Piper J3L-65 · S/N 6357Built 1941 · Shannon Todd JN36541Piper PA-28-181 · S/N 28-7890521Built 1978 · Plains AviationN36VGBeech A36 · S/N E-309Built 1972 · Mitchell Aviation LLCN3760AHylio AG-272 · S/N 17906070285Precision Drone Solutions LLCN3906HErcoupe 415-CD · S/N 4607Built 1947 · Krall James MN404PCAmerican Legend AL11 · S/N AL-1093Built 2007 · Legend Aire LLCN4127SBeech V35B · S/N D-9738Built 1975 · Krall Jeff PN420CXCessna 525A · S/N 525A0420Built 2008 · Superbird Icc LLCN4283VConti Horace Charles KITFOX III · S/N 770Johnson Neal RN437DMEdward L Olds III STOL CH 750 · S/N 75-7641Johnson NealN444BGCessna 421C · S/N 421C0893Built 1980 · Mitchell Aviation LLCN4995HPiper PA-11 · S/N 11-886Built 1948 · Peterson Ronald W TrusteeN518FRTalos Drones T60X · S/N 2104F7EZW255Q001DL63Vermeulen Drone Service LLCN55159Piper PA-32-300 · S/N 32-7340103Built 1973 · Rasmussen Paul HN559TBeech 95-55 · S/N TC-108Built 1961 · Superbird Icc LLCN6141JPiper PA-28-151 · S/N 28-7615312Built 1976 · Rnt Air LLCN6261QCessna 172H · S/N 17255080Built 1967 · Pitz William AN62BFS.O.C.A.T.A. MS894A · S/N 12022Wise David LN715MECessna 525A · S/N 525A0361Built 2007 · Mmp Airflight LLCN725MECessna 525C · S/N 525C0165Built 2014 · Mmp Airflight LLCN73816Cessna 172N · S/N 17267696Built 1976 · Nedved Aviation LLCN75105Schweizer 269C · S/N S1677Built 1994 · Mitchell Maverick LLCN752TFDJI AGRAS T30 · S/N 527BK3S001002NFischer Aerial LLCN759MQCessna 182Q · S/N 18266106Built 1977 · Pretre Alan GN770JKJeffrey Peter Krall SAFARI 400 · S/N 7007Built 2019 · Krall Jeffery PN780GAGrumman American Avn. GA-7 · S/N GA7-0067Built 1978 · Prairie Planes LLCN80673Cessna 172M · S/N 17266698Built 1976 · Mitchell Aviation LLCN812JBBonewitz John A KITFOX SERIES 5 · S/N 9604-0178Built 2000 · Krall Jeff PN8606PPiper PA-24-260 · S/N 24-4061Built 1964 · Buhler Carey CN9271RCessna R182 · S/N R18200676Built 1978 · Upwind Aviation LLC
Back to Mitchell, SD