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.
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
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.
N102HKCGS HAWK ARROW II · S/N HAII-311-R582-TRLN105MWMichael D Wilson TAILWIND W-10 · S/N MW001N144AADiamond Aircraft Ind DA20-A1 · S/N 10096N1630JPiper PA-28-140 · S/N 28-24017N1699GChampion 7ECA · S/N 647N19AWBellanca 7KCAB · S/N 425-74N1BUBucker Jungmann C.A.S.A. 1.131 · S/N E3B-327N201NZMooney M20J · S/N 24-0300N2176SCessna T182T · S/N T18208256N2225LBeech C24R · S/N MC-449N229KBBeaty Robert B GLASTAR · S/N 001N246EEBeech N35 · S/N D-6797N2525BPiper PA-38-112 · S/N 38-79A0108N25SSNorth American AT-6D · S/N 85087N261WTCirrus Design SR22T · S/N 9440N267ECessna 150L · S/N 15074092N2692JCessna 150G · S/N 15065692N2723BPiper PA-28-140 · S/N 28-25852N2738MPiper PA-12 · S/N 12-1227N2796LCessna 172H · S/N 17255996N280ACBeech C23 · S/N M-2197N28916Luscombe 8A · S/N 1658N291RFDJI INSPIRE 2 · S/N 09YDE3UL040667N3150JCessna 150G · S/N 15065850N3406North American NA-64 · S/N 64-2144N3414TCessna 177 · S/N 17700714N3437CCessna 170B · S/N 26480N34541Aeronca 65-TL · S/N F10151TN35150Quicksilver MX-2 · S/N 60091N360GLGarry V Laznicka LANCAIR 360MK-IIC · S/N 974-320-814CSFBN3639PPiper PA-22 · S/N 22-3390N3668KPiper PA-28-140 · S/N 28-23678N3748QBeech V35 · S/N D-8411N39038Grumman American Avn. AA-1C · S/N AA1C0197N39064Grumman American Avn. AA-1C · S/N AA1C0210N440XAEa Vision EA J100 · S/N 85570N445LMBRM Aero S R O BRISTELL LSA · S/N 445/2019N4476EPiper PA-38-112 · S/N 38-78A0627N454BCCarter Bradley S LONG-EZ · S/N 278N46879Boeing A75 · S/N 75-2333N47727Taylorcraft DCO-65 · S/N 4776N4814VBoeing E75 · S/N 75-5706N496BMSellers Mark R TWINSTAR MARK III · S/N 1003N5074FAeronca 7AC · S/N 7AC-4822N5098VCessna 172RG · S/N 172RG0448N509TWThomas W Weishaar CCK-1865 · S/N CCK-1865-1045N5382DCessna 172N · S/N 17272556N5636LAmerican AA-1 · S/N AA1-0036N5677WPiper PA-28-160 · S/N 28-909N5787YPiper PA-23-250 · S/N 27-2917
Back to Saint Charles, MO