Owasso, OK
Registered aircraft · 178
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 = 'OWASSO' 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 = 'OWASSO' 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.
N1000JBeech A23A · S/N M-1000N1065UCessna 182T · S/N 18281573N10815Cessna 150L · S/N 15075058N1121DCessna 140A · S/N 15685N116ASLearjet 45 · S/N 078N1238BDehavilland DHC-2 MK.I · S/N 1238N125VAConklin Christopher E VELOCITY · S/N DM0125N127JTJames T Campbell VANS RV-14A · S/N 140838N12YSNYS John M NYS RV-10A · S/N 40558N1306YCessna 172C · S/N 17249006N134GLBeech A45 · S/N G-732N1374DHeston Howard P G.N.I. · S/N 803N1448BLuscombe 8F · S/N 6075N147GGBeech 95-A55 · S/N TC-260N1505XPiper PA-28R-200 · S/N 28R-7535302N15579Piper PA-28-180 · S/N 28-7305089N159MMAlexander Geoffrey L GLASTAR · S/N 5791N15JFBeech C35 · S/N D-3095N16179Cessna 150L · S/N 15073527N1697Waterson Robert L GREAT LAKES 2T-1A-2W · S/N 001N1759FCessna 172H · S/N 17255154N182CBCessna 182B · S/N 52008N185SKCessna A185F · S/N 18504151N19040Cessna 150L · S/N 15074117N19238Cessna 150L · S/N 15074263N1935CFlight Design CTLS · S/N F-12-07-04N195PKCessna 195 · S/N 7712N2073RCessna 182G · S/N 18255273N2121NCessna 140 · S/N 12357N213ADDalton Bart RV-6 PLUS · S/N 3N215JGCirrus Design SR22T · S/N 0486N2197WBeech B19 · S/N MB-697N2234GCessna 182A · S/N 51534N22362Aeronca 50-L · S/N L3669N2264HEngineering & Research ERCOUPE 415-C · S/N 2889N226AHNorth American T-28D · S/N 52-1226N231CMooney M20K · S/N 25-0063N2343Stewart-Anderson Breezy 254351768353282-A · S/N 835328283533070N2351WBeech A23A · S/N M-949N236RMoman Guy E JR FIREBOLT · S/N GM-3N24540Piper PA-38-112 · S/N 38-79A1129N2496UCessna 172D · S/N 17250096N250CRHelicopteres Guimbal CABRI G2 · S/N 1336N2586JCessna 150E · S/N 15061086N2704SCirrus Design SR22 · S/N 1265N2844Stephenson Charles H SIEMENS SCHUCKERT D1 · S/N 904N300TUBombardier BD-100-1A10 · S/N 20264N301BCCupp Ben L T 18 · S/N E20TN30769Cessna 177B · S/N 17701454N3101DCameron Balloons US Z-90 · S/N 7024
Back to Owasso, OK