Stillwater, MN
Registered aircraft · 69
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 = 'STILLWATER' 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 = 'STILLWATER' 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.
N100EFBroderson Eric Michael SKYSTAR(KITFOX)SER 5 · S/N S9801-0132N102MMGlobe GC-1B · S/N 71N105BDRichard Warren Hoch BD-5B · S/N 2562N109DVDurand MARK V · S/N 1N109EHE C Hickey DURAND MK V · S/N 038N117KMAdvanced KITFOX SUPER SPORT · S/N KA0107005N136CBCameron Balloons US A-210 · S/N 6585N152SPCessna 152 · S/N 15282536N157RERans S-7LS · S/N 0806442N1694RCessna A185F · S/N 18502417N2019XCessna 182H · S/N 18256119N21478Piper J3C-50 · S/N 2502N222TRStinson 108 · S/N 108-322N225PSRichardson Ray JR POWERSPORT VNS RV-6A · S/N 24739N2307VCessna 140 · S/N 14543N231AEMooney M20K · S/N 25-0054N2367BTemco GC-1B · S/N 3667N236DFTreff Arthur RV-8 · S/N 81264N23TPBeech F33A · S/N CE-870N2428BTemco GC-1B · S/N 3728N251EXJonathan K James PHD GLASAIR SPORTSMAN2+2 · S/N 7352N2544SPiper PA-18-150 · S/N 18-7909155N2599WMooney M20E · S/N 950N26RBBruner Robert C ACRODUSTER-II · S/N RCB-1N28AGGlobe GC-1B · S/N 42N3028QCessna 182K · S/N 18258028N3128MPiper J3C-65 · S/N 15758N3151RHamilton Roger N W-8 TAILWIND · S/N 353N3288KGlobe GC-1B · S/N 1281N3822UBeech V35B · S/N D-10364Registration pendingN3953KPiper PA-28-140 · S/N 28-23831N406DMState Aircraft Factories MIG-17T · S/N 0613N40TGSiai-Marchetti S 211 · S/N 029/02-019N42297Piper J3C-65 · S/N 14547N42WWUniversal GLOBE GC-1B · S/N 3688N45675Luscombe 8A · S/N 2202N4711CCessna 172 · S/N 36623N5083SPiper PA-28R-200 · S/N 28R-7135082N5092UGlobe GC-1A · S/N 256N51EXJames Jonathan K GLASTAR · S/N 5007N5269LPiper PA-28-180 · S/N 28-4567N539CBBalony Kubicek Spol Sro BB26Z · S/N 1359N55771Piper PA-28-180 · S/N 28-7305464N593PUCirrus Design SR20 · S/N 2040N62928Universal GLOBE GC-1A · S/N 153N6314ZBellanca 17-30A · S/N 85-30996N6500GLancair LC42-550FG · S/N 42045N65636Lake LA-4-200 · S/N 575N6970GCessna 150L · S/N 15072470N715JMCameron Balloons Z-133 · S/N 6774
Back to Stillwater, MN