OpenAirDocs.org
Sylvania, OH

Registered aircraft · 40

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

N104VRDJI INSPIRE 1 · S/N W13DCE26040819Varner Reaty Ltd LLCN1152KMooney M20K · S/N 25-0626Built 1981 · Van Hook James WN11DMMillikan David L STARDUSTER II SA-300 · S/N 584Built 1998 · Suburban Aircraft Leasing And Sales LLCN182RNCessna R182 · S/N R18200311Built 1978 · Nensel Richard EN2709BCessna 335 · S/N 335-0037Built 1979 · A&R Investments IncN2885EAeronca 7AC · S/N 7AC-6468Built 1946 · N2885e LLCN29755Taylorcraft BL12-65 · S/N 2603Built 1941 · B & S Aviation LLCN36834Aeronca 65-TAC · S/N C1681TABuilt 1941 · B & S Aviation LLCN400HWAmerican Champion 8KCAB · S/N 739-95Built 1994 · Hotel Whiskey LLCN4109BBellanca 17-30A · S/N 75-30760Built 1974 · Mccowan Joseph FN4552KRyan NAVION · S/N NAV-4-1552Built 1948 · Domalski FrankN4656JPiper PA-28R-180 · S/N 28R-30550Built 1968 · Peters David EN49527Cessna 152 · S/N 15283469Built 1979 · B&S Aviation LLCN4996Dehavilland/Motes DH.C1 MK22A · S/N C1-0611Built 1952 · Aeroplane Co LLCN501WJCessna 501 · S/N 501-0143N501wj LLCN51TMPapa 51 THUNDER MUSTANG · S/N 018Wills DavidN52551Boeing A75N1(PT17) · S/N 75-1707Built 1942 · N52551 LLCN5744Lindstrom Bruce C WAGABOND · S/N BL1Built 2011 · Keller Kevin MN588SFRobinson Helicopter R44 II · S/N 11034Built 2006 · Intrepid Helicopters LLCN58HWRaytheon 58 · S/N TH-2058Hotel Whiskey LLCN617SSCessna LC41-550FG · S/N 411127Built 2009 · N617ss LLCN6364DCessna 172N · S/N 17272750Built 1979 · Suburban Aircraft Leasing And Sales LLCN66507Cessna 150M · S/N 15076087Gozdowski Matthew DN6880YPiper PA-23-250 · S/N 27-4228Built 1969 · Lavalley Richard G Jr TrusteeN700HWCessna T206H · S/N T20608034Built 1999 · Hotel Whiskey LLCN736WHCessna TR182 · S/N R18200779Built 1978 · B&B Island Aviation LLCN7412PPiper PA-24-250 · S/N 24-2600Built 1961 · Espyess Aviation LLCN7535YPiper PA-30 · S/N 30-598Built 1964 · N7535y LLCN75976Cessna 172N · S/N 17268079Built 1976 · Suburban Aircraft Leasing And Sales LLCN76791Cessna 140 · S/N 11223Built 1946 · Suburban Aircraft Leasing And Sales LLCN7733PPiper PA-24-250 · S/N 24-2947Built 1961 · Keller Kevin MN773DWCessna TU206F · S/N U20603202Built 1976 · Walerius DennisN8244QPiper PA-44-180T · S/N 44-8107011Built 1980 · Aeroplane Co LLCN831MNWilliam T Sallee VANS RV-9 · S/N 91445Built 2019 · Sallee William TN83CMCirrus Design SR22T · S/N 1690Built 2017 · Schmitt David WN870BCessna 550 · S/N 550-0870Tdc Transportation LLCN912HFBeech F33A · S/N CE-1540Built 1990 · Mcs Aviation LLCN9357UCessna 150M · S/N 15078306Built 1976 · Baldwin James SN958ARTextron T240 · S/N T24002131Built 2017 · Cj Leasing LLCN95JSSchleicher ASW-20 · S/N 20478Built 1981 · Slifer John R Jr
Back to Sylvania, OH