OpenAirDocs.org
Mason City, IA

Registered aircraft · 39

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

N134AFBeech A45 · S/N G-100Built 1953 · Summerfield Douglas TN16695Harris PIETENPOL AIRCAMPER · S/N KH-1Harris Rex DN1712TPiper PA-28-140 · S/N 28-7125026Built 1970 · Lea Joe AN17TGGeesman John T RV-4 · S/N 1373Geesman John TN1903HPiper PA-28-181 · S/N 28-7790351Built 1977 · Esp Aviation LLCN19302Cessna 150L · S/N 15074319Built 1973 · Halverson Mark SN2437VCessna 140 · S/N 14687Built 1948 · Midtgaard Michael AN273YYounkin J R REPLICA HOWARD DGA-6 · S/N JRY-02Built 1985 · Planelease LLCN2867XCessna 177 · S/N 17700267Built 1967 · Thrush Air LcN29CFCirrus Design SR22T · S/N 1922Built 2019 · J Plane LLCN304BMDJI AGRAS T20P · S/N 1581F574B239600100P4Martin Ag Drones LLCN31571Piper PA-32-300 · S/N 32-7840134Built 1978 · Cg Air LLCN3516SCessna 172E · S/N 17250716Built 1963 · Benedict GregN3967LCessna 172G · S/N 17254136Built 1966 · Jalukar VishramN4151LCessna 172G · S/N 17254220Built 1966 · Pardun Phillip RN4215YBellanca 7GCBC · S/N 968-77Built 1977 · Cg Air LLCN4435KRyan NAVION · S/N NAV-4-1435Built 1948 · Glowaski Adam WN44497Piper PA-28-140 · S/N 28-7425417Built 1974 · English William EN4483ARans S12 · S/N 049607101Built 1994 · Midtgaard Michael AN4547XPiper PA-28-235 · S/N 28-7610035Built 1975 · Bike Aviation LLCN4555TPiper PA-28R-200 · S/N 28R-7235087Jb Aviation LLCN478SCBeech 95-B55 (T42A) · S/N TC-2190Built 1978 · Petroblend CorpN4853EChampion 7EC · S/N 305Built 1959 · Summerfield Douglas TN49774Taylorcraft L-2M · S/N L-5535Built 1943 · Planelease LLCN50121Taylorcraft DCO-65 · S/N 5473Built 1943 · Rozendaal DouglasN5135TChampion 7ECA · S/N 562Rayl Benjamin EN607HWBen Wiedemann SONERAI 11L · S/N 7913.12Wiedemann Ben WN6419LAmerican AA-1A · S/N AA1A-0419Built 1972 · Haag Jay EN6532PPiper PA-24-250 · S/N 24-1654Built 1960 · Carlsson Carl JN696DCDJI AGRAS T50 · S/N 63Y1M120AR0007Registration pendingN7075QCessna 172L · S/N 17260375Corell Ryan JN7221TCessna 172A · S/N 46821Built 1959 · Dahle Neil EN784DEOwens Brent A RV-8 · S/N 82614Built 2011 · Rust David PN78968Mooney M20C · S/N 2142Built 1962 · Harris Rex DN8418RPiper PA-28-140 · S/N 28-22295Built 1966 · Carlsson Carl JN8458HPiper PA-28-181 · S/N 28-8290053Built 1981 · Gansemer William LN84MFFrederick Cheryl A FREDERICK F1 · S/N 084Built 2003 · Planelease LLCN914EOckuly Bernard E VANS RV7A · S/N 70599Built 2005 · Trettin Anthony KN9319UCessna 150M · S/N 15078269Built 1976 · Johnson Douglas G
Back to Mason City, IA