OpenAirDocs.org
Warren, OH

Registered aircraft · 45

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

N107BMResser Richard J 601 XL · S/N 6-6345Thompson James RN10CYNusbaum Steve JOHN DOE · S/N 0001Molek JonN1282EAeronca 7AC · S/N 7AC-4842Built 1946 · Molek EugeneN1512CCessna 180 · S/N 30212Built 1953 · Molek JonN2004HTaylorcraft F21 · S/N F-1004Molek JonN2334EAeronca 7AC · S/N 7AC-5916Sale reportedBuilt 1946N2589QCessna 182K · S/N 18257789Molek EugeneN25ASAviat A-1B · S/N 2151Built 2001 · Molek JonN2600EAeronca 7AC · S/N 7AC-6182Built 1946 · Antonell George FN2658VCessna 170 · S/N 18168Built 1948 · Griffin Robert LN273ACCarlson Anders J CARLSON CUB · S/N 101Built 2010 · Griffin Connor WN30CYNusbaum Steve VAQUERO · S/N 0004Molek JonN33AFLight Aero AVID FLYER AF1 · S/N 167Molek Jon PN3452APiper PA-22-135 · S/N 22-1725Molek JonN36078Taylorcraft BC12-D · S/N 3045Built 1941 · Molek JonN3665MPiper PA-12 · S/N 12-2530Built 1947 · Ernie Hall Aviation Museum IncN3900UCessna 150E · S/N 15061300Built 1965 · Heston Jeffrey WN399FPVans RV-12 · S/N 120135Built 2010 · Crawford David BN43531Taylorcraft BC12-D · S/N 7190Built 1946 · Molek JonN441LSCessna 441 · S/N 441-0342Built 1984 · Meander Air LLCN4803Christen Industries A-1 · S/N 1126Molek JonN5238QCessna 150L · S/N 15073138Built 1972 · Molek JonN5288QCessna 150L · S/N 15073188Ernie Hall Aviation Museum IncN5473QCessna 150L · S/N 15073373Built 1972 · Bell Craig SN5480DVector HD 580 · S/N 5300C7A3Crosswind Farms LLCN5489TCessna 172E · S/N 17251389Built 1964 · Dunn ScottN5499EEugene Molek ACUB · S/N 0-360-3Built 2016 · Molek EugeneN5618MTaylorcraft BC12-D · S/N 12018Built 1948 · Molek EugeneN651JRCirrus Design SR22 · S/N 3491Sumar Electrical Systems IncN6558FCessna 150F · S/N 15063158Molek JonN665DGFlight Design CTLS · S/N 08-04-13Built 2008 · Broviak William EN71228Cessna 182M · S/N 18259542Built 1969 · Ryan DavidN7569EChampion 7FC · S/N 7FC-263Built 1958 · Paul Mark AN75DKCessna U206F · S/N U20603217Paul Mark AN76774Cessna 120 · S/N 11206Molek JonN794CHSharp Bradford L BABY ACE D · S/N 29Lach John FN8032MMolek Jonathan P ACUB · S/N 0-360Built 2009 · Molek Jonathan PN8649KStinson 108-1 · S/N 108-1649Built 1947 · Morelli Kenneth AN9194DPiper PA-22-160 · S/N 22-6253Built 1958 · Daniels Daryl AN9194NPiper J3C-65 · S/N 22321Crawford David BN9298Brown Dennis W WAG AERO SPT TRNR · S/N 2918Built 1999 · Brown Dennis WN94HWWeter Howard T RV9A · S/N 90045Built 2002 · Lach John FN95777Taylorcraft BC12-D · S/N 8077Molek JonN969SDPiper PA-28-140 · S/N 28-7225045Thompson James RN999VFPiper PA-28R-200 · S/N 28R-7135143Built 1971 · Crawford David B
Back to Warren, OH