Saint Charles, MO

Registered aircraft · 89

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 = 'MO' AND g.registrant_city = 'SAINT CHARLES'
  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.

N102HKCGS HAWK ARROW II · S/N HAII-311-R582-TRLBuilt 2007 · Buchholz William CN105MWMichael D Wilson TAILWIND W-10 · S/N MW001Built 2023 · Wilson Michael DN144AADiamond Aircraft Ind DA20-A1 · S/N 10096Built 1996 · Piston Aviation LLCN1630JPiper PA-28-140 · S/N 28-24017Built 1967 · Piston Aviation LLCN1699GChampion 7ECA · S/N 647Built 1968 · Beckham Samuel GN19AWBellanca 7KCAB · S/N 425-74Fildes Robert DN1BUBucker Jungmann C.A.S.A. 1.131 · S/N E3B-327Kerner Frank WN201NZMooney M20J · S/N 24-0300Built 1977 · Mooney M20j Brokers LLCN2176SCessna T182T · S/N T18208256Built 2004 · Tango-Alpha LLCN2225LBeech C24R · S/N MC-449Built 1977 · Bratcher Randy LN229KBBeaty Robert B GLASTAR · S/N 001Built 1999 · Boeing Employees Flying Club St LouisN246EEBeech N35 · S/N D-6797Baldwin Alexander LN2525BPiper PA-38-112 · S/N 38-79A0108Built 1978 · On Course LLCN25SSNorth American AT-6D · S/N 85087Built 1944 · Hinote Holdings LLCN261WTCirrus Design SR22T · S/N 9440Built 2023 · Cvd Recreation LLCN267ECessna 150L · S/N 15074092Built 1972 · Evenson Charles RN2692JCessna 150G · S/N 15065692Built 1966 · Downing Eric DN2723BPiper PA-28-140 · S/N 28-25852Built 1969 · Piston Aviation LLCN2738MPiper PA-12 · S/N 12-1227Built 1946 · Kerner Frank WN2796LCessna 172H · S/N 17255996Built 1967 · Smyth Michael LN280ACBeech C23 · S/N M-2197Built 1979 · White Scarf Airways LLCN28916Luscombe 8A · S/N 1658Built 1941 · Carnegie Scott W TrusteeN291RFDJI INSPIRE 2 · S/N 09YDE3UL040667Subject Media Group LLCN3150JCessna 150G · S/N 15065850Built 1966 · Keown Kyle WN3406North American NA-64 · S/N 64-2144Built 1940 · Downing Eric DN3414TCessna 177 · S/N 17700714Built 1967 · Kkk Services IncN3437CCessna 170B · S/N 26480Built 1954 · Yaiser James FN34541Aeronca 65-TL · S/N F10151TBuilt 1941 · Carnegie Scott WN35150Quicksilver MX-2 · S/N 60091Built 1984 · Buchholz William CN360GLGarry V Laznicka LANCAIR 360MK-IIC · S/N 974-320-814CSFBLaznicka Garry VN3639PPiper PA-22 · S/N 22-3390Built 1955 · Joseph Patrick SN3668KPiper PA-28-140 · S/N 28-23678Built 1967 · Piston Aviation LLCN3748QBeech V35 · S/N D-8411Built 1967 · Thoendel JasonN39038Grumman American Avn. AA-1C · S/N AA1C0197Built 1978 · Stansberry Charles AN39064Grumman American Avn. AA-1C · S/N AA1C0210Built 1978 · Fischer John WN440XAEa Vision EA J100 · S/N 85570Semke Ryan VN445LMBRM Aero S R O BRISTELL LSA · S/N 445/2019Built 2019 · Piston Aviation LLCN4476EPiper PA-38-112 · S/N 38-78A0627Built 1978 · N4476e LLCN454BCCarter Bradley S LONG-EZ · S/N 278Built 1985 · Mir AliN46879Boeing A75 · S/N 75-2333Built 1941 · Windstar Aircraft LLCN47727Taylorcraft DCO-65 · S/N 4776Built 1943 · Letrello Michael FN4814VBoeing E75 · S/N 75-5706Maresca Paul AN496BMSellers Mark R TWINSTAR MARK III · S/N 1003Built 1998 · Bernard Luke JohnN5074FAeronca 7AC · S/N 7AC-4822Kerner Frank WN5098VCessna 172RG · S/N 172RG0448Built 1980 · Harvestowne Aviation LLCN509TWThomas W Weishaar CCK-1865 · S/N CCK-1865-1045Red Cub Flying Club LLCN5382DCessna 172N · S/N 17272556Built 1979 · Eagles Flying ClubN5636LAmerican AA-1 · S/N AA1-0036Crosby Thomas GN5677WPiper PA-28-160 · S/N 28-909Langel BrandonN5787YPiper PA-23-250 · S/N 27-2917Built 1965 · Marr Steven K
Back to Saint Charles, MO