OpenAirDocs.org
Red Oak, IA

Registered aircraft · 25

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 = 'IA' AND g.registrant_city = 'RED OAK'
  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.

N1136SRaytheon A36 · S/N E-3054Built 1996 · Big Sky Beech LLCN11527Cessna 150L · S/N 15075489Built 1973 · Red Oak Commuter LLCN1197DJI AGRAS T100 · S/N 1581F8ZLC259U002C5DDGoranson Drone Services LLCN1319DJI AGRAS T50 · S/N 1581F6BUB246C001YB33Goranson Drone Services LLCN13VAForrest Foster VANS RV9A · S/N 90823Built 2015 · Mcgrew Kevin PN14364DJI AGRAS T100 · S/N 1581F8ZLC259T0022C9PGoranson Drone Services LLCN1742DJI AGRAS T100 · S/N 1581F8ZLC255H002LF8BGoranson Drone Services LLCN17HSCessna 210G · S/N 21058844Built 1967 · Red Oak Centurion LLCN20348Cessna 172M · S/N 17261211Built 1972 · Red Oak Hawks LLCN2141TPiper PA-28R-200 · S/N 28R-7135144Built 1971 · Horizon Ventures IncN22162Cessna 150H · S/N 15068108Built 1967 · Red Oak Commuter LLCN2260YCessna 177 · S/N 17700060Built 1967 · Reich Bruce DN297GFDJI AGRAS T40 · S/N 1581F574B238A00102Z5Goranson Drone Services LLCN297LGDJI AGRAS T40 · S/N 1581F574B235Q001010WGoranson Drone Services LLCN307KHill R I/Hill R J JR BOUNSALL PROSPECTOR · S/N BSP29NS12Hill Chad RichardN3535Gaskill Leslie D PIETENPOL AIR-CAMPER · S/N 1Built 2018 · Hill Amanda SueN3587EAeronca 7AC · S/N 7AC-6927Built 1947 · Hill Brianna LN3896QCessna 172L · S/N 17259996Built 1971 · Nishna Valley Flying ClubN4268Martin FLY BABY · S/N 7053Hill Chad RichardN4978HPiper PA-11 · S/N 11-858Cool Taildraggers LLCN6243GCessna 150K · S/N 15071743Built 1970 · Red Oak Commuter LLCN7139KPiper PA-18 · S/N 18-356Built 1950 · Cool Tail Draggers LLCN78126Cessna 172K · S/N 17257492Built 1968 · Orme Jason RN9051DPiper PA-22-160 · S/N 22-6191Waller Raymond S TrusteeN940TXTalos Drones T60X · S/N 2104F7EZB251J0019934Pelzer Cade
Back to Red Oak, IA