Saint Peters, MO
Registered aircraft · 41
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 PETERS' 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 PETERS' 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.
N1167MBeech A23A · S/N M-1082N118DMPiper PA-46-701TP · S/N 46020051N146MBPiper PA-32-300 · S/N 32-7840160N1518DCessna 195A · S/N 7740N165EZKranzusch Norman T LONG-EZ · S/N 165N2396QBeech 23 · S/N M-475N2774EAeronca 7AC · S/N 7AC-6358N3091SCessna 150G · S/N 15066991N30BLBennett A Ludtke SONEX · S/N 1412N3547YCessna 182F · S/N 18254447N37829Superior CULVER LFA · S/N 332N3955SCessna 172E · S/N 17251155N4016QAndrew Philip Richardson DBA A-B · S/N 249N45896Luscombe 8A · S/N 2423N493SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0581N533SBeech V35 · S/N D-8028N5376TJennings Walter L RANS S 9 · S/N 1287036Sale reportedN5942FPiper PA-32R-300 · S/N 32R-7780022N660CMAmerican Champion 8KCAB · S/N 1028-2006N679MLHawes AEROSPORT QUAIL · S/N 7N68JPBeech E-55 · S/N TE-854N690FAFairchild 24R-46 · S/N R46104N72DAC F M Air S R L DARDO · S/N 002N74470Grumman American Avn. AA-5B · S/N AA5B-0240N7521EBoschert Randall P PEGASUS · S/N 001N7544VCessna 177RG · S/N 177RG0841N7725FCessna 150F · S/N 15063825N820STCessna 150M · S/N 15078376N82TTSocata TB-20 TRINIDAD · S/N 616N8337UCessna 172F · S/N 17252237N8548EChampion 7FC · S/N 7FC-348N854SDiamond Aircraft Ind DA20-A1 · S/N 10198N88VWJagust William M BENSEN 8M · S/N 001N910NMDassault-Breguet MYSTERE FALCON 900 · S/N 95N9134JPiper PA-28-180 · S/N 28-3185N92630Piper J3C-65 · S/N 17001N929KPJoshua Humphreys AUTOGYRO CAVALON · S/N V00139N92KVArbc Inc DBA Lindstrand 105A · S/N 5709N9371EAeronca 11AC · S/N 11AC-1009N93880Engineering & Research 415-C · S/N 1203First renewal noticeN93CXBurton J Biermann THATCHER CX5 · S/N 093
Back to Saint Peters, MO