Skip to content

Great Lakes 2T-1A

Registered aircraft · 35

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 ('3910106')
  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 ('3910106')
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.

N1130HEnking Novak Teresa M · North Fond Du Lac, WIBuilt 1931 · S/N 253 N11324Madden William L · Las Cruces, NMBuilt 1931 · S/N 241 N11326Singer Saul Aaron · Sausalito, CAS/N 243 N11333Great Lakes Aircraft LLC · Palmer Lake, COBuilt 1931 · S/N 246 N11334Martin James David · Graford, TXBuilt 1931 · S/N 247 N11336Kushnir Bo · Tamuning, GUS/N 249 N11337Harris Hayden H · Chelsea, MIS/N 250 N11338Hofmann John M · Columbus, WIBuilt 1931 · S/N 251 N11339Airpower Museum Inc · Ottumwa, IABuilt 1932 · S/N 252 N204KBradley Gary C · Orchard Park, NYBuilt 1929 · S/N 30 N333HMcintyre Wayne F · Pebble Beach, CABuilt 1928 · S/N 136 N390HKlubichek Janet C · Winnemucca, NVBuilt 1972 · S/N 67717-F-331 N435YGreat Lakes Aircraft LLC · Palmer Lake, COS/N 152 N501GLSharp Aviation LLC · Pauls Valley, OKBuilt 1973 · S/N 0501 N502GLSky Dancing LLC · La Jolla, CABuilt 1973 · S/N 0502 N543KThoensen Thomas R · Delta, COS/N 49 N647KHoover Michael B · Ridgeland, WIBuilt 1930 · S/N 111 N648KNichols Charles F Trustee · Baldwin Park, CAS/N 183 N705KKelley Paul V Jr · Atlanta, GABuilt 1929 · S/N 52 N777PAce Aeromotive Inc · Miami, FLBuilt 1929 · S/N 128 N821KSdl Enterprises LLC · Akron, IABuilt 1931 · S/N 82 N828KLumley William B · Delray Beach, FLBuilt 1932 · S/N 89 N833KAshley James M · Greenwood, SCBuilt 1930 · S/N 94 N834KHoover Michael B · Ridgeland, WIS/N 95 N837KRouth Gary Lee · Lebanon, TNS/N 98 N839KMorozowsky Anthony M · Zanesville, OHS/N 103 N841HSaure Cameron G · Reynolds, NDBuilt 1929 · S/N 20 N849DDBishop David · Butlerville, INS/N 113 N856LSlack Troy Trustee · New Concord, OHBuilt 1930 · S/N 117 N863KCronin Robert B Jr · Candia, NHBuilt 1932 · S/N 124 N864KRouth Gary L · Lebanon, TNS/N 125 N866KSdl Enterprises LLC · Akron, IABuilt 1930 · S/N 127 N874KGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1929 · S/N 135 N909NPreston Robert J · Pittstown, NJBuilt 1930 · S/N 139 N915NMadden William L · Las Cruces, NMBuilt 1929 · S/N 145

Back to Great Lakes 2T-1A