Skip to content

Schweizer SGU 2-22E

Registered aircraft · 32

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('8050612')
  ORDER BY 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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8050612')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N173JSCleveland Soaring Society Inc · Hartville, OHS/N 173 N2411WKramer Dean E · Bernville, PABuilt 1966 · S/N 249 N2413WFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 251 N2677NFreeland Christopher G · Brownwood, TXS/N 243 N2747ZMidwestern Soaring Association · Peculiar, MOBuilt 1964 · S/N 195 N2748RGoebel James W · Loveland, OHBuilt 1963 · S/N 168 N2749Z2019 Glider LLC · Pipersville, PABuilt 1964 · S/N 197 N2753ZDavenport Peter B · Harrington, WABuilt 1964 · S/N 208 N2761RCarlton Koby A · Warsaw, KYBuilt 1963 · S/N 174 N2762RWilliams Jimmy Z · Sherman, TXBuilt 1963 · S/N 175 N2764ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1964 · S/N 210 N2772ZWright Alan L · Independence, ORBuilt 1965 · S/N 215 N2784ZAerodrome Services LLC · Maple Park, ILS/N 218 N349SCEastern Iowa Gliders Inc · Muscatine, IABuilt 1966 · S/N 245 N371MSWells Air Service Inc · Scotia, NEBuilt 1966 · S/N 236 N5828VGoofys Glider Club · Wichita, KSBuilt 1964 · S/N 202 N6230LAas LLC · Ovid, MIBuilt 1964 · S/N 182 N681UBishop Thomas W · Decatur, TXBuilt 1965 · S/N 217 N685UMaglaughlin Ronald D · Udall, KSBuilt 1965 · S/N 220 N694UCaprock Soaring Association · Lubbock, TXS/N 222 N695UMessner Dale A · Uniontown, OHBuilt 1965 · S/N 223 N8679RMaglaughlin Ronald D · Udall, KSBuilt 1963 · S/N 162 N8686RChautauqua Soaring Society · Mayville, NYBuilt 1963 · S/N 166 N8694RCondon Anthony Brian II · Wichita, KSBuilt 1963 · S/N 167 N9848EZellers Clyde E · Springfield, ILBuilt 1965 · S/N 229 N9853EHilton Loye Lee · Bullhead City, AZBuilt 1965 · S/N 231 N9903JRaven Nw Llp · Acme, PABuilt 1965 · S/N 237 N9904JKuydendall David E · Roland, IABuilt 1965 · S/N 239 N9905JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1965 · S/N 240 N9918JMueller Douglas G · Boulder City, NVBuilt 1966 · S/N 246 N9919JCollins James C Jr · Whitehouse Station, NJBuilt 1966 · S/N 247 N999ZZRegistration Pending · Crown Point, INRegistration pendingBuilt 1965 · S/N 225

Back to Schweizer SGU 2-22E