OpenAirDocs.org
Hudson, OH

Registered aircraft · 32

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

N1168NMooney M20K · S/N 25-0719Built 1982 · Cheung H MichaelN1206WFirefly Balloons 2010 FIREFLY 7-15 · S/N F7-2074Built 2019 · Kenyo R EugeneN1244APiper PA-18 · S/N 18-1037Built 1957 · Pickard Martha Anne GabrielN1271ZBeech N35 · S/N D-6723Built 1961 · V-Four LtdN12767Cessna 177B · S/N 17702386Built 1975 · Lipstreu William HN161TMCessna 550 · S/N 550-0867Built 1999 · Hudson Air LLCN1951TCessna A185F · S/N 185-04134Built 1980 · Bachmann Jochen WN22356Aeronca 50-C · S/N C-3559Built 1939 · Plunkett Robert GN233DPAmerican Champion 8KCAB · S/N 931-2003Built 2003 · Prop 2 Fox LLCN25LKLithuanian Factory Of LAK-12 · S/N 698Built 1995 · Kolar David MN294MCCirrus Design SR22 · S/N 2431Built 2007 · Northcoast Airsports LtdN316JZDiamond Aircraft Ind DA 62 · S/N 62.C062Built 2023 · Zockoll Janice MN34DJBeech F33A · S/N CE-483Brugman Edward JN45DFCessna 525A · S/N 525A0430Built 2008 · Forcountry LLCN46111Taylorcraft DCO-65 · S/N 5510Built 1943 · Northcoast Airsports LtdN464CWSchilthelm Mark W F1H ROCKET · S/N 001Built 2023 · Schilthelm Mark WN4854JPiper PA-28R-180 · S/N 28R-30611Built 1968 · Trio Bravo LtdN48CZBell 407 · S/N 53780Built 2007 · Zamparke Aviation - Agent Incorp ServicesN502RZHawker Beechcraft HAWKER 900XP · S/N HA-0082Built 2008 · Amici727ef LLCN522GGGreenwell Gary L SONERAI IIL · S/N 012304-0651Greenwell Gary LN55BCCary William K VANS RV6 · S/N 60360Built 2003 · Mcconnell Bert JN575LPCirrus Design SR22T · S/N 9616Built 2023 · Wildkat Aviation LLCN6125PCessna 182T · S/N 18281387Built 2004 · Thomas RogerN715BBPiper PA 46-350P · S/N 4636038Built 1996 · Martin L JeffreyN72651Cessna 140 · S/N 9827Built 1946 · Mx7 LLCN771VYGreat Lakes 2T-1A-2 · S/N 0742Built 1976 · Garcia PedroN7SKStamp-Kelly STEEN SKYBOLT · S/N SB-1Built 1975 · Mondora Robert MN88589Piper J3C-65 · S/N 16215Built 1946 · Mcconnell Bert JN9249HCessna 172M · S/N 17266044Built 1975 · Gencur Paul AN927CRCirrus Design SR22T · S/N 1500Built 2017 · Aero Fudo LLCN97ZZMaule MX-7-180B · S/N 22023CBuilt 2006 · Mx7 LLCN995WDCirrus Design SR22 · S/N 4908Tactical Capital LLC
Back to Hudson, OH