OpenAirDocs.org
Rolla, MO

Registered aircraft · 27

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 = 'ROLLA'
  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.

N155JMMoon O E ESQUAL VM-1 · S/N 74Built 2007 · Bequette EugeneN163DBPiper PA-32R-301T · S/N 3257210Built 2001 · Dehghani MohammadN1978EAeronca 7AC · S/N 7AC-5545Built 1946 · Pritchett Flying Service LLCN225JBBearden Biplane SOPWITH CAMEL · S/N 63017Built 2018 · Bearden James TN2457JPiper PA-18-150 · S/N 18-7909128Built 1979 · Harrison Steven DN2766PPiper PA-22 · S/N 22-3077Marti Larry BN2895EAeronca 7AC · S/N 7AC-6478Pritchett Flying Service LLCN333USchempp-Hirth STANDARD CIRRUS · S/N 528Built 1974 · Mason Steven KN384QADJI AGRAS T50 · S/N 63YBLCB0020055Aerovision Drone LLCN5571CBeech F33A · S/N CE-1347Built 1989 · Harrison Steven DN60161Cessna 150J · S/N 15070115Built 1968 · Pipes George A IIN6433TCessna R182 · S/N R18202022Built 1985 · Cole Richard JN7104FPiper PA-28-151 · S/N 28-7715197Built 1976 · Potrafka Richard MN7289LGrumman American Avn. AA-5 · S/N AA5-0289Built 1972 · Mott Calvin LN772XTJames F Mccaul IV JMB: VL-3TE-915 · S/N VL-3-491Built 2022 · Mccaul Medical Group LLCN82320Aeronca 7AC · S/N 7AC-949Pritchett Flying Service LLCN82733Aeronca 7AC · S/N 7AC-1380Built 1946 · Green Vernon GN8285MBeech A36 · S/N E-2815Built 1993 · Cohen Aviation LLCN8291UCessna 172F · S/N 17252191Built 1964 · Barnett William MN838HPCessna 150F · S/N 15062786Built 1966 · Keathley Jeremie LN85855Aeronca 11AC · S/N 11AC-288Built 1946 · Mason Steven KN8924CPiper PA-22-135 · S/N 22-1519Built 1953 · Haines Delmar WN9098CAeronca 7BCM · S/N 7BCM-372Pritchett Flying Service LLCN9217GCessna 182N · S/N 18260757Built 1971 · Register Otis EN951GHHenderson Gary R VANS RV-8A · S/N 83643Built 2021 · Henderson Gary R TrusteeN958PBBeech 58P · S/N TJ-392Built 1981 · Mo Elite Air LLCN9961WPiper PA-28-140 · S/N 28-23508Built 1967 · Viper Enterprises LLC
Back to Rolla, MO