OpenAirDocs.org
Mansfield, OH

Registered aircraft · 50

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 = 'OH' AND g.registrant_city = 'MANSFIELD'
  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.

N104BEngineering & Research ERCOUPE 415-C · S/N 2533Built 1946 · Knl Associates LLCN12940Cessna 172M · S/N 17262388Built 1973 · Buffoon Flying ClubN1609ECessna 172N · S/N 17271065Built 1978 · Eilenfeld TeresaN19GRLearjet 45 · S/N 470Built 2013 · Gorman-Rupp CoN19SLBeech V35B · S/N D-9848Built 1976 · Mifflin Enterprises LLCN21069Aeronca KCA · S/N KCA41Built 1938 · Walburn John MN2185VCessna 140 · S/N 14414Built 1948 · Streeter M ClowN224VLJMB Aircraft S R O VL-3EH-916 · S/N VL-3-592Built 2024 · Schluter Aviation LLCN2671JCessna 150G · S/N 15065671Built 1966 · Sherman Phillip AN27FCCessna 182E · S/N 18254410Built 1962 · Walburn John MN2885ZBellanca 8KCAB · S/N 374-78Mclaughlin Paul EN30873Piper J3C-65 · S/N 5164Built 1940 · Rall Charles JN31369Aeronca 65-LB · S/N LB10480Built 1940 · Walburn John MN320YBuhl LA-1 · S/N 108Built 1931 · Lootens Charles WN366VRVashon RANGER R7 · S/N 10220Built 2023 · Rcr Aviation LLCN3686RPiper PA-28-180 · S/N 28-5788Built 1970 · Neal Matthhew ZN387EDDJI AGRAS T50 · S/N 1581F6BUB2492001RP99Dolee'S Tree Service LLCN387FDDJI AGRAS T50 · S/N 1581F6BUB2489001EFTBDolces Tree Service LLCN39092Luscombe 8B · S/N 1853Built 1941 · Blauser Edward CN3958NBeech 35 · S/N D-1218Kash Ronald DN4341WBeech B24R · S/N MC-270Built 1974 · Barlow Steven JN481JCessna 210M · S/N 21061580Built 1977 · Collins JasonN481LDDJI AGRAS T50 · S/N 1581F6BUB24A6001HPU7Dolce'S Tree Service LLCN542GTDJI AGRAS T100 · S/N 1581F8ZLC257E002L0P5Dolce'S Tree Service LLCN5535MAero Commander 100 · S/N 121Built 1967 · Butz Jonathan ON55973Piper PA-28-140 · S/N 28-7325543Built 1973 · Crase Nicole TrusteeN601NMAircraft Mfg & Development CH601XL SLSA · S/N 601-006SBuilt 2006 · Barlow Steven JN6153HPiper J3C-65 · S/N 19319Built 1946 · Brown Vintage Airlines LLCN64543Cessna 172M · S/N 17265297Built 1975 · Rcr Aviation LLCN651APiper PA-22 · S/N 22-54Built 1951 · Blauser Edward CN6922ECessna 175A · S/N 56422Built 1959 · Rall Charles JN69648Cessna 310Q · S/N 310Q0833Clow Streeter MN70304Piper J3C-65 · S/N 17281Butz Jonathan ON75267Piper PA-32R-300 · S/N 32R-7680284Built 1976 · Avian Aerospace LLCN7659RBeech B23 · S/N M-1263Thomas Chris CN800BSilvaire LUSCOMBE 8F · S/N 6730Built 1950 · Nesta Richard VN802RHHowell Russell S VANS RV-7 · S/N 74366Built 2017 · Knl Associates LLCN8076FCessna 150F · S/N 15064176Built 1966 · Yoxtheimer David RN80LSPiper PA-18-150 · S/N 18-7609096Built 1976 · Clow Streeter MN8216GCessna 177RG · S/N 177RG0116Built 1971 · Farrar Edwin LN83412Piper PA-18-150 · S/N 18-7609123Built 1976 · Mifflin Enterprises LLCN8385UCessna 172E · S/N 17252285First renewal noticeBuilt 1964 · Clow Streeter MN83956Piper PA-28RT-201T · S/N 28R-8131142Built 1981 · Mc Laughlin Paul EN84141Cessna 172K · S/N 17258352Registration pendingBuilt 1969N89695Cessna 140 · S/N 8744Built 1946 · Rall Charles JN9035QBeech F33A · S/N CE-310Built 1970 · Brown Vintage Airlines LLCN94327Engineering & Research ERCOUPE 415-C · S/N 1550Built 1946 · Sprang Russell DN9621EAeronca 11AC · S/N 11AC1259Built 1946 · Lootens Charles WN9856FBoeing A75N1(PT17) · S/N 752912Built 1942 · Brown Vintage Airlines LLCN9858YChampion 7FC · S/N 437Mclaughlin Paul E
Back to Mansfield, OH