OpenAirDocs.org
Ohio State University

Registered aircraft · 24

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'OHIO STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'OHIO STATE UNIVERSITY')
  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.

N100SUTextron 172S · S/N 172S11739Columbus, OHN122WETextron 172S · S/N 172S12396Built 2019 · Columbus, OHN125WETextron 172S · S/N 172S12303Built 2019 · Columbus, OHN140SUCessna 172S · S/N 172S11563Built 2015 · Columbus, OHN150SUCessna 172S · S/N 172S11565Built 2015 · Columbus, OHN180SUTextron 172S · S/N 172S12161Built 2018 · Columbus, OHN20SUTextron 172S · S/N 172S11623Built 2015 · Columbus, OHN210SUTextron 172S · S/N 172S12431Built 2020 · Columbus, OHN240SUCessna 152 · S/N 15285153Built 1981 · Columbus, OHN260SUTextron 172S · S/N 172S12160Built 2018 · Columbus, OHN280SUTextron 172S · S/N 172S12432Built 2020 · Columbus, OHN30SUTextron 172S · S/N 172S11625Built 2015 · Columbus, OHN350SUTextron 172S · S/N 172S12304Built 2019 · Columbus, OHN4113QCameron Balloons US C-160 · S/N 6108First renewal noticeBuilt 1997 · Columbus, OH · Co-owner with Byrd Polar Research CenterN500SUCessna A150L · S/N A1500486Built 1974 · Columbus, OHN50SUCessna 172R · S/N 17280440Built 1998 · Columbus, OHN510SUCessna 150L · S/N 15074297Built 1973 · Columbus, OHN54628Cessna 172P · S/N 17275013Built 1981 · Columbus, OHN65784Cessna 172P · S/N 17275884Built 1982 · Columbus, OHN70SUCessna 172R · S/N 17280460Built 1998 · Columbus, OHN717THTextron 172S · S/N 172S12009Built 2017 · Columbus, OHN840SUTextron 172S · S/N 172S12433Built 2020 · Columbus, OHN90SUCessna 172S · S/N 172S8475Built 2000 · Columbus, OHN927SUPiper PA-44-180 · S/N 4496528Built 2021 · Columbus, OH
Back to Ohio State University