Stillwater, OK
Registered aircraft · 87
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 = 'OK' 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 = 'OK' 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.
N100MNAggieair Usu MINION · S/N AA100MNN1025XPiper PA-28-140 · S/N 28-7525261N1029BMooney M20J · S/N 24-1336N1050PDale R Lightfoot SOPWITH CAMEL · S/N 201507N119TTBeech V35B · S/N D-10369N1201DBrablec Douglas Dale TRI-Q · S/N 1-2702N120SUTextron 172S · S/N 172S11674N13386Cessna 172M · S/N 17262720N20KEMugin MUGIN 6 PRO · S/N M6000-OSU-01N211WCCwian Walter D CH750 · S/N 757818N2350MPiper PA-28R-201T · S/N 28R-7803125N2496YCessna 172D · S/N 17249796N250SUTextron 172S · S/N 172S11675N257KAPiper PA-38-112 · S/N 38-79A1004N2685KLuscombe 8A · S/N 5412N300SUCirrus Design SR20 · S/N 2520N310SUCirrus Design SR20 · S/N 2521N320FSDJI AGRAS T40 · S/N 1581F574B237600100PWN320SUCirrus Design SR20 · S/N 2522N330SUCirrus Design SR20 · S/N 2523N34719Northwestern PORTERFIELD 35 · S/N 885N3509NBryson Terry W SKYLITE · S/N 185N3582UCessna 182F · S/N 18254982N360SUCirrus Design SR20 · S/N 2525N370SUCirrus Design SR20 · S/N 2615N3712YCessna 210C · S/N 21058212N3745ABolton Chris A LONG-EZ · S/N 1996-LN3798KPiper PA-28-140 · S/N 28-23733N393MMPiper PA-32R-301T · S/N 3257168N4067HMooney M20J · S/N 24-1046N41415Piper PA-28-180 · S/N 28-7405101N433PWJJP VANS RV-10 · S/N 40531N4614VVarga 2150A · S/N VAC-89-78N4655PCessna 152 · S/N 15284794N4815TPiper PA-28-180 · S/N 28-7205200N48481Cessna 152 · S/N 15283342N490MBeech B36TC · S/N EA-390N500BMBeech 58P · S/N TJ-418N5055FAerostar International RX 8 · S/N RX8-3374N5058HPiper PA-11 · S/N 11-957N5136WPiper PA-28 · S/N 28-165N535FLMorrison Frank W A-11-FM · S/N F-3747N538UAOklahoma State University TURBO ELECTRIC MUGIN · S/N OSU-TE-001N5420PCessna 152 · S/N 15284942N585EJCirrus Design SR20 · S/N 2319N5912SBeech V35A · S/N D-8830N5974UPiper PA-28-140 · S/N 28-26861N5AUPiper PA-28-140 · S/N 28-7725239N600SUCessna 150K · S/N 15071691N6512TCessna 150 · S/N 17912
Back to Stillwater, OK