Saint Paul, MN
Registered aircraft · 125
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 = 'MN' AND g.registrant_city = 'SAINT PAUL' 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 = 'MN' AND g.registrant_city = 'SAINT PAUL' 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.
N112SPTextron 182T · S/N 18283086N1147CAllan Behuncik 162F · S/N WAB2006N114CZCessna 182R · S/N 18267892N115SPCirrus Design SR22 · S/N 4385N118SPBell 407 · S/N 53646N119SPBell Helicopter Textron Canada 407 · S/N 54742N11BAPiper PA-38-112 · S/N 38-78A0317N124SPCirrus Design SR22 · S/N 9554N127SMSchleicher ASW-27 · S/N 27156N128DDSyverson David KITFOX MODEL 7 · S/N S70410067N12CPPowell ACEY-DUCYP-70 · S/N 1N12MNKodiak KODIAK 100 · S/N 100-0342N1409EAeronca 7AC · S/N 7AC-4972N14424Parkman David A JR VANS RV-4 · S/N 1253N181ABuchmann Oscar A VANS RV-6A · S/N 60280N191PFFinateri Paulo RV-9A · S/N 90474N1BZCessna 525 · S/N 525-0439N2074DReigle Wade E RANS S-10 SAKOTA · S/N 0793161N20HCessna 680 · S/N 680-0338N215EMCirrus Design SR22 · S/N 2453N2184Martineau Phillip M GLASTAR · S/N 5879N2263VSchanks-William EAA ACRO SPORT · S/N 396N2387BGlobe GC-1B · S/N 3687N24MNKodiak KODIAK 100 · S/N 100-0348N25WFPiper/Wally'S Flyers J3C-65 · S/N 5671N2620NSteenson Jeffrey N MURPHY REBEL ELITE · S/N 714N264VDassault FALCON 2000EX · S/N 353N2654TDJI AGRAS T40 · S/N 1581F574B235B00102YWN2814MPiper PA-12 · S/N 12-1182N311YMCirrus Design SR20 · S/N 10897N321FLCirrus Design SR22 · S/N 3392N321MNDJI AGRAS T40 · S/N 1581F574B227B00100FZN32649Piper PA-28-151 · S/N 28-7515209First renewal noticeN34080Cessna 177RG · S/N 177RG0963N347RVHove Paul E VANS RV-7A · S/N 70345N3506YCessna T206H · S/N T20608311N353SPiper PA-28R-180 · S/N 28R-30851N3561JCessna 150E · S/N 15061261N356DWAviat A-1B · S/N 2101N360FCDassault FALCON 2000EX · S/N 042N3836Cessna 140 · S/N 12510N38RZCessna 182Q · S/N 18265430N3978WOwens Warner R RELIANT J-3 KITTEN · S/N W001N40EMAmerican Champion 8KCAB · S/N 696-92N41EXExtra Flugzeugbau EA 300/L · S/N 1195N431FPiper PA-28-140 · S/N 28-24929N436CDassault FALCON 2000EX · S/N 343N45610Luscombe 8A · S/N 2137N48056Cessna 152 · S/N 15283276N503MKTextron 208B · S/N 208B5342
Back to Saint Paul, MN