OpenAirDocs.org
Grove, OK

Registered aircraft · 48

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

N133CKLockheed T-33A · S/N 51-17445Built 1951 · Heritage Air LLCN1523DFirefly Balloons FIREFLY 7B-15 · S/N F7B-2006Donahue KathrynN1555YBeech A36 · S/N E-2508Built 1989 · G E C Air LLCN1650RGrumman American Avn. AA-1B · S/N AA1B-0550Built 1975 · Kock Berwin M TrusteeN1961WBeech B19 · S/N MB-624Meier Monte MN1UFCessna T337G · S/N P3370098Built 1973 · Grand Aviation IncN20743Cessna 182P · S/N 18261172Built 1972 · Eagles Flight LLCN21035Cessna 172M · S/N 17263890Built 1974 · Hayes Bradley MN2271ZAyres S2R-G6 · S/N G6-147Built 1997 · Plane LLC (The)N2998MBeech F33A · S/N CE-1097Built 1986 · M T Aviation LLCN3017ZAir Tractor AT-602 · S/N 602-1223Built 2013 · Plane LLC (The)N3084XAyres S2R-R1340 · S/N R1340-033Built 1995 · Plane LLCN3086SCessna 172I · S/N 17256700Amo Air & Claims LLCN328JMMacy Jack L STARDUSTER TOO SA300 · S/N 2082Grand Aviation IncN335PBeech A36 · S/N E-3005Built 1996 · Elvin Robert BrianN3363RCessna 182L · S/N 18258663Built 1967 · Eagles Flight LLCN40699Thrush S2RHG-T65 · S/N T65HG-016Built 2005 · Plane LLCN4292BBeech F35 · S/N D-4354Built 1955 · Freeman Bobby KeithN465PEBeech 95-C55 · S/N TE-112Built 1966 · Hoyle Jason RN48178North American F-86A · S/N 48178Built 1948 · Heritage Air LLCN50376Bellanca 8GCBC · S/N 282-78Built 1978 · Hayes Brad MN5493ZPiper PA-22-108 · S/N 22-9278Built 1962 · Mcnabb James A TrusteeN54RCBoeing N2S-5 · S/N 75-8579Built 1943 · Baker Thomas NealN553SWCessna 414A · S/N 414A0614Built 1981 · Heritage Air LLCN5888CCessna U206G · S/N U20605888Cwf Enterprises IncN61680Cessna 172M · S/N 17264724Built 1975 · Kaye LindaN618SMSmith AEROSTAR 601P · S/N 61P-0201-016Built 1975 · Hoyle Jason RN622SKCirrus Design SR22T · S/N 2206Built 2020 · Makkar Aviation LLCN63548Cessna 150M · S/N 15077387Built 1975 · Hoyle JasonN6466JPiper PA-28-180 · S/N 28-4890Homesick Angel Aircraft ManagementN6572QAlon A2 · S/N A-72Carlton Davis EN6688EBeech V35B · S/N D-10319Built 1979 · Hill Daniel DBAN6994JPiper PA-28-140 · S/N 28-7625266Built 1976 · Lytle Tobin AN732ETCessna P210N · S/N P21000575Built 1980 · Caudill Jimmy LN736TSCessna TR182 · S/N R18200770Built 1978 · Rose Clarence E IIIN7412XCessna 172B · S/N 17247912Built 1960 · Epperson Gregory RN7455ACessna 172 · S/N 29555Built 1956 · Applied Products LLCN74DMCessna 172M · S/N 17262699Built 1973 · T C Rian Association LLCN7588CPiper PA-28-140 · S/N 28-7625076Built 1975 · Grand Aviation IncN7PZPiper PA-46-701TP · S/N 46020024Built 2024 · Eagles Flight LLCN8017XCessna 172B · S/N 17248517Built 1961 · Caudill Jimmy LN83448Champion 7AC · S/N 7AC-2115Built 1946 · Baker Thomas NN8483NBeech V35A · S/N D-8807Built 1968 · Fletcher Greg S TrusteeN86961Engineering & Research ERCOUPE 415-C · S/N 134Sale reportedBuilt 1945N869HCAir Tractor AT-802 · S/N 802-0475Built 2012 · Plane LLCN9161BCessna 172 · S/N 36761Built 1958 · Lee Mark SN930JDCessna 310 · S/N 35297Built 1956 · 310 Aero LLCN939NALockheed T-33A · S/N 56-3689Built 1956 · Heritage Air LLC
Back to Grove, OK