OpenAirDocs.org
Claremore, OK

Registered aircraft · 79

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

N1100SCessna 175 · S/N 55410Built 1958 · Hagen Johnny DN130MAStephen Dennis R RV-7A · S/N 70972Built 2006 · Davie Timothy WN1500EAir Tractor AT-402 · S/N 402-0820Vaughans Aircraft Leasing LLCN1596PPiper PA-18-135 · S/N 18-3761Passmore Aviation LLCN16NRHiller UH-12E · S/N 1755Built 1964 · Paragon Helicopter Services LLCN182YACessna 182P · S/N 18264643Built 1976 · Sageeyah Cessna LLCN18968Beech C23 · S/N M-1986Built 1978 · Budde Michael DN1956LBeech C23 · S/N M-1816Built 1976 · Meisinger Darrell GN199CMPilatus PC-12/45 · S/N 262Built 1999 · Passmore Aviation LLCN21687Piper J3C-65 · S/N 2578Built 1939 · Boyd Darrell MN2189TPiper PA-28-180 · S/N 28-7205041Built 1971 · Tulsa Aviation Group Leasing LLCN22SPHiller UH-12E · S/N 1214Built 1959 · Paragon Helicopter Services LLCN23888Taylorcraft BC-65 · S/N 1524Built 1939 · Mcguire ChristopherN24XGMichael Trusty/Patricia Trusty AL18 · S/N AL-387Built 2024 · Trusty Michael NN250VTXag P100 PRO · S/N 8219314J131RHabitat Solutions Management LLCN2524FChampion 7ECA · S/N 72Built 1966 · Wilkins Shelley AN2576APiper PA-22-135 · S/N 22-868Built 1952 · Christopher StevenN25WGGretz W Warren VANS ACFT CO RV-6 · S/N 23270Built 2008 · Seemore Flyers LLCN2645PSix Chuter SR7 XL · S/N 992117SR7XLBuilt 1999 · Dawson John HN28623Silvaire LUSCOMBE 8C · S/N 1452Built 1940 · Wilkins David JoeN2959MPiper PA-28-181 · S/N 28-7890281Built 1977 · Hanneman RobertN31311Titan TORNADO · S/N D99912SOHK0356Built 2007 · Mcclure Jared BN3375DCessna 180 · S/N 32173Built 1955 · Qualls Randy JN34543Cessna 177B · S/N 17701865Built 1973 · Riggs Jeffrey WN34985Cessna 177B · S/N 17702136Built 1974 · Long Sean LN359WTPure Flight S R O PHOENIX U15 · S/N 66/U15Built 2023 · Walter James CN37804Culver LFA · S/N 312Built 1941 · Mcguire Christopher CN385TCCessna T182T · S/N T18208385Liebl Holdings LLCN3909CCessna 172I · S/N 17257032Built 1968 · James Eric AN402YKYakovlev YAK-50 · S/N 822402Wilkins David JN4086VCessna 150M · S/N 15076695Built 1975 · Boyd Darrell MN439SPOrtbals Marvin JABIRU SP · S/N 310 SPBuilt 2005 · Ortbals Marvin HN442RYRobinson Helicopter R44 II · S/N 10096Built 2003 · Paragon Helicopter Services LLCN44JXQuinn James P RV6A · S/N OKFL39514469Built 2003 · Quinn James PN46595Aeronca L-3 · S/N 058B-6302Built 1942 · Egbert TomN474JWWedman Jeffrey S VANS RV-8 · S/N 80474Built 2003 · Wedman Jeffrey SN4751LPiper PA-28-180 · S/N 28-4080Boyd Aero Services LLCN5028TPiper PA-28R-200 · S/N 28R-7235178Built 1972 · Drake Charles RN50957Cessna 150J · S/N 15069673Anklam Eugene EN54413Cessna 172P · S/N 17274970Built 1981 · Belcher Phillip BN544VBeech S35 · S/N D-7904Built 1965 · Ingle Maurice O IIIN5529CCessna 170A · S/N 19576Built 1950 · Haralson Stephen K TrusteeN5599WPiper PA-28-160 · S/N 28-736Built 1962 · Phoenix Aviation LLCN56691Piper PA-28-235 · S/N 28-7410023Built 1973 · Green BrianN5697ACessna 172 · S/N 28297Built 1956 · Ham Dana LN5827XCessna 310F · S/N 3100127Built 1961 · Bechtold Norman JN5946JCessna 182Q · S/N 18267024Built 1979 · Millett Paul BN59HAHigher Class SUPER HORNET · S/N 059Built 2007 · Stauner Philip CN615TWTextron 182T · S/N 18283110Built 2020 · Clark Jim WN6330BCessna 182 · S/N 34230Built 1957 · Group Therapy Enterprises Inc
Back to Claremore, OK