OpenAirDocs.org
Ponca City, OK

Registered aircraft · 37

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 = 'PONCA CITY'
  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.

N1413CDJI AGRAS T40 · S/N 1581F574B227B00100HQAgriair Solutions LLCN1976HCessna 150M · S/N 15077112Built 1975 · Okaeronut LLCN21CGBeech B200 · S/N BB-1346Built 1989 · N21cg Leasing LLCN21HGPiper PA-31-350 · S/N 31-8152078Built 1981 · Drisco LLCN24393Taylorcraft BC-65 · S/N 1729Built 1940 · Frisbie John NN260HZDJI AGRAS T20P · S/N 1581F574B2274001010XOklahoma Aerial Ag LLCN260KZDJI AGRAS T40 · S/N 1581F574B226600101EQOklahoma Aerial Ag LLCN260QADJI AGRAS T40 · S/N 1581F574B226M00101JXOklahoma Aerial Ag LLCN263WCCessna 550 · S/N 550-0944Built 2000 · 24-7 Machinery LLCN2GGRaytheon B200 · S/N BB-1539Built 1996 · N2gg Leasing LLCN305HMPiper PA-46-600TP · S/N 4698101Built 2019 · Fast On The Hunt LLCN3126TCessna 177 · S/N 17700426Built 1967 · Nicholson Homer LN316SFCessna 182G · S/N 18255668Built 1964 · Doc Aviation LLCN3316RCessna 182L · S/N 18258616Branstetter JackN3484TCessna 177 · S/N 17700784Built 1968 · Cairo Jane LLCN36WAPiper PA-30 · S/N 30-581Built 1964 · Landreth Kevin RN3818ZBeech 77 · S/N WA-225Built 1981 · Rigney Mark EN421VJCessna 421C · S/N 421C0507Built 1978 · H C LLCN42FCRaytheon B200 · S/N BB-1553Built 1996 · N42fc Leasing LLCN444KKCirrus Design SR22T · S/N 9584Built 2023 · Heartland Tank LLCN45128Cessna 177RG · S/N 177RG1093Built 1976 · Bowker James KN486NMcguire Stephen E CABIN ACE SJ · S/N CA001JBuilt 2013 · Mcguire Stephen Edward TrusteeN50GGRaytheon B200 · S/N BB-1728Built 2000 · N50gg Leasing LLCN51CACessna 560XL · S/N 560-5234Built 2002 · Oklahoma Jet 560-5234 LLCN610PWEclipse Aerospace EA500 · S/N 550-1011Built 2017 · Gimp LLCN61PCBeech B200 · S/N BB-1483Built 1994 · N61pc Leasing LLCN624ZMDJI AGRAS T40 · S/N 1581F574B226A00102EXKeeler MickyN63HWCody Hawkins JA30 SUPERSTOL · S/N JA483-1-16Hawkins CodyN6845FCessna 150F · S/N 15063445Built 1966 · Howard Donald E IIN7849VMooney M20C · S/N 2812Built 1964 · Okaeronut LLCN7975RBeech V35A · S/N D-8991Built 1969 · Hicks Jeffrey DN79ABBird-Allen FLYBABY · S/N 414Built 1979 · Howard Donald E IIN850JWSocata TBM 700 · S/N 603Built 2011 · Prop It Up LLCN9188LBellanca 7ECA · S/N 814-72Built 1971 · Sodowsky Jim LN920PWAutel Robotics EVO · S/N 20910EVO2409CWittmer Ellery NealN984VEPilatus PC-24 · S/N 291Built 2022 · Apex 291 LLCN9GARaytheon B200 · S/N BB-1719Built 2000 · N9ga Leasing LLC
Back to Ponca City, OK