OpenAirDocs.org
Sapulpa, OK

Registered aircraft · 29

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

N1043KPiper PA-18-135 · S/N 18-3919Built 1954 · Shadowens Jackie RN104APBell 206B · S/N 4149Built 1990 · Rock Creek Leasing LLCN13231Cessna 172M · S/N 17262594Built 1973 · Ace Aviation LLCN1855JPiper PA-28-140 · S/N 28-24293Nicholson JohnN220BCSmith AEROSTAR 601 · S/N 61-0031Rock Creek Leasing LLCN234PWCessna 182Q · S/N 18266103Built 1978 · Right Rudder LLCN2394FCessna 210E · S/N 21058594Built 1965 · N2394 Fox LLCN29933North American AT-6G · S/N 49-3291Built 1951 · Green Country Warbirds LLCN307BAStewart Clifford L ZODIAC 601XLB · S/N 6-4698Built 2019 · Stewart Matthew T TrusteeN3101LPowrachute PEGASUS · S/N A331PEGBuilt 2006 · Leake KennethN311JGDehavilland DHC-1B-2-S5 · S/N 228Built 1956 · Gilbert Joe MN32104Balloon Works FIREFLY 8B-15 · S/N F8B-512Built 1996 · Jones Brian CN321JGGilbert Joe M RANS S-7 · S/N 0798253Built 2000 · Gilbert Joe MN36837Aeronca 65-CA · S/N C-17731Built 1941 · Bowden DonaldN4057HBuckeye HORNET · S/N 16333English Brian QN4158NCessna 140 · S/N 13629Perkins Howard D JrN418SVBell 206B · S/N 2399Built 1978 · Canyon Creek Investments LlpN442LVCessna 510 · S/N 510-0153Built 2009 · Wachob Leasing Co IncN5149Grumman Acft ENG Cor-Schweizer G-164A · S/N 1123Built 1973 · Rock Creek Leasing LLCN51HSSorensen Harvey L RV-9A · S/N 91126Built 2006 · Gilbert Joe MN6049YPowrachute PEGASUS · S/N A-048PEGBuilt 2008 · Leake KennethN6944RCessna T210H · S/N T210-0344Built 1968 · Silcox Cleven LN7144VMooney M20F · S/N 22-0063Built 1974 · Js&J Enterprises LLCN787SMMock D/Mock S HYPERHOPPER · S/N 1Built 1996 · Mock Stephen RN841MBell UH-1B · S/N 62-1956Built 1962 · Rock Creek Leasing LLCN8930Cheek Carroll HATZ/CHEEK · S/N 825Built 2003 · Chronister Raymond LN91WGBeech F33 · S/N CD-1244Built 1970 · Temco LLCN9553KStinson 108-2 · S/N 108-2553Built 1947 · Chronister RaymondN99011Engineering & Research ERCOUPE 415-C · S/N 1634Built 1946 · Redding Doug Trustee
Back to Sapulpa, OK