OpenAirDocs.org
Tiffin, OH

Registered aircraft · 31

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

N1171FCessna 172G · S/N 17254766Blohm Paul J.N19WWDJI AGRAS T50 · S/N 1581F6BUB2435001Q222Trc Drone Services LLCN28761Piper PA-28-161 · S/N 28-7916415Built 1979 · Hall James KN377STPiper PA 46-350P · S/N 4636737Built 2018 · Newman Aviation Services IncN38741Piper PA-28R-201T · S/N 28R-7703267Built 1977 · Hoyda Jeffrey AN41217Piper PA-28-151 · S/N 28-7415387Built 1974 · Kraut William AN444RCPiper PA-31T · S/N 31T-7520030Built 1975 · Tiffin Aire IncN473GGPiper PA-31T · S/N 31T-7820026Tiffin Aire IncN475ETDJI AGRAS T50 · S/N 1581F6BUB2435001354CTrc Drone Services LLCN589FTDJI AGRAS T100 · S/N 1581F8ZLC25AC002H78UTrc Drone Services LLCN6175APiper PA-31T · S/N 31T-7920011Built 1979 · Tiffin Aire IncN637APiper PA-22 · S/N 22-39Snyder Kenneth EN653GRDJI AGRAS T100 · S/N 1581F8ZLC258H002N5VLTrc Drone Services LLCN6547HPiper J3C-65 · S/N 19739Built 1946 · Newman Bradley WN67196Boeing 75 · S/N 75-4641Built 1942 · Newman Bradley WN723JPPiper PA-31T · S/N 31T-7920009Built 1978 · Tiffin Aire IncN74455Bellanca 14-13-2 · S/N 1568Bell Joseph BN748BLTextron 525 · S/N 525-1116Built 2022 · 755 Holdings LLCN79FARaven S55A · S/N S55A-507Tiffin Aire IncN8145WPiper PA-28-180 · S/N 28-2259Built 1965 · Nagel Thomas HN834HPNew Piper PA-32R-301T · S/N 3257426Built 2006 · Newman Aviation Services IncN86802Bellanca 14-13-2 · S/N 1163Built 1946 · Bell Joseph BN86CMPiper PA-31-310 · S/N 31-468Built 1969 · Newman Aviation Services IncN888NMPiper PA-32R-301T · S/N 32R-8529012National Machinery LLCN9030DPhillips Virgil PIETENPOL AIRCAMPER · S/N 403-56-6288Bell Joseph BN910HGPiper PA-31T · S/N 31T-7400009Tiffin Aire IncN918MAPiper PA-32R-301 · S/N 3246118Built 1998 · Newman Aviation Services IncN9266YPiper PA-31T1 · S/N 31T-1104008Tiffin Aire IncN9313CPiper PA-28-161 · S/N 28-7816459Built 1978 · Wright Terrence RichardN9515EAeronca 11AC · S/N 11AC-1151Built 1946 · Barron ShawnN99ARPiper PA-30 · S/N 30-1881Built 1969 · Tiffin Aire Inc
Back to Tiffin, OH