OpenAirDocs.org
Iowa City, IA

Registered aircraft · 102

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

N105DYPiper PA-32-260 · S/N 32-467Built 1966 · Yeager Daniel CN110PLMil Moscow Helicopter MI-2 · S/N 563648094Built 1974 · State Of IowaN11992Stits Playboy SA3B · S/N P-222Built 1970 · Rohr Brian DN120PLBell TH-57 · S/N 163341State University Of IowaN123PFCessna 172S · S/N 172S8086Built 1999 · Jet Air IncN1243CPiper PA-22-135 · S/N 22-1059Built 1953 · Endahl Eric AN124MECessna 172S · S/N 172S8372Built 2000 · Jet Air IncN130PLBell TH-57 · S/N 163345Built 1985 · State University Of IowaN1351CCessna 177B · S/N 17702708First renewal noticeBuilt 1977 · Sapphire Vistas LLCN1508EAeronca 7AC · S/N 7AC-5071Built 1946 · Couch Richard AN150PLTroy Built Models TBM UAV-3 · S/N 2016-002State Of Iowa University Of IowaN1564XPiper PA-28-151 · S/N 28-7515424Built 1975 · Brumley James LawrenceN17XCCub Crafters CC19-180 · S/N CC19-0028Built 2018 · State University Of IowaN1921FCessna 172N · S/N 17273013Built 1979 · State Of IowaN1942BLuscombe 8A · S/N 6369Farkas Edward JN20PLAerovodochody L-29 DELFIN · S/N 395097Built 1973 · State Of Iowa University Of IowaN20UPRobinson Helicopter R66 · S/N 0924Built 2019 · Rsv Rotor Wing LLCN2114QCessna 172S · S/N 172S9616Built 2004 · Jet Air IncN211CBHostager Bruce S RV-9A · S/N 90715Built 2020 · Hostager Bruce SN211JFFishbaugh Justin GLASAIR III · S/N 3293Built 2004 · Fishbaugh Justin KN211PZMil Moscow Helicopter MI-2 · S/N 515021126Built 1977 · State Of IowaN2135KCessna 172S · S/N 172S9556Built 2003 · Jet Air IncN222RBBeech 58 · S/N TH-1592Built 1990 · M & B LlpN22JACessna 550 · S/N 550-1129Jet Air IncN23540Beech A36 · S/N E-1180Built 1977 · State Of IowaN23798Cessna 172R · S/N 17280603Built 1998 · Jet Air IncN254TPPiper PA-28-151 · S/N 28-7715184Jet Air IncN25KPNorth American T-6G · S/N 49-3336AJet Air IncN2779GBoeing A75N1(PT17) · S/N 75-4920Built 1943 · Jet Air IncN27858Piper J4A · S/N 4-1078Built 1940 · Lust Gary LN2819EAeronca 7AC · S/N 7AC-6402Built 1946 · Overturf Sarah RN282MECessna 172S · S/N 172S8540Built 2000 · Jet Air IncN289JSCessna 172S · S/N 172S8996Built 2001 · Jet Air IncN29006Cessna 172M · S/N 17264093Built 1974 · Fancy IncN339ZAAero Vodochody L-39ZA · S/N 332650Built 1983 · State University Of IowaN3542FCessna 172R · S/N 17281075Jet Air IncN35HBBarr Harry SX 300 · S/N CP-59Built 1988 · Downes GregN35SUAlexandre Kolyvanov VAN'S RV-7A STANDARD · S/N 72094Kolyvanov AlexandreN35WKBeech F35 · S/N D-4366Built 1955 · Schnell ThomasN364MACessna 172S · S/N 172S8007Built 1998 · Jet Air IncN37EGRobinson Helicopter R44 II · S/N 14125Built 2017 · Volterra LLCN386ESCessna 172R · S/N 17280106Built 1997 · Jet Air IncN409KFleet 2 · S/N 132Built 1929 · Vintage Props LLCN41496Downes/Dane/Zimmerman RANS COYOTE II S6S · S/N 94S6S03Built 1994 · Zimmerman Gregory JN429GCAerovodochody L-29 DELFIN · S/N 591311Built 1964 · State Of IowaN44329Taylorcraft BC12-D1 · S/N 10129Built 1946 · Tiffany John RN4687VCessna 172RG · S/N 172RG0366Built 1980 · Sharp Cutlass LLCN47497Piper PA-28R-201 · S/N 28R-7737168Built 1977 · Alpha Arrow Flying LLCN49255Boeing A75N1(PT17) · S/N 75-691Built 1941 · Butler John EN49KWCessna 550 · S/N 550-1021Built 2002 · Jet Air Inc
Back to Iowa City, IA