Skip to content

Universal GLOBE GC-1B

Registered aircraft · 45

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

N17GSTingle Terence M · Desmoines, IABuilt 1946 · S/N 17 N1WSCj And Sons Aircraft Club · Wilmington, DEBuilt 1946 · S/N 2169 N2341BHowell Harley L · Colville, WAS/N 3641 N2345BBartholomew Don B · Gardnerville, NVBuilt 1948 · S/N 3645 N2347BPace John W · Bothell, WAS/N 3647 N2415BWomack Jeff M · Jackson, LABuilt 1949 · S/N 3715 N2417BRamsay Danny M · San Antonio, TXBuilt 1949 · S/N 3717 N3263KJennings Shawn Thomas · Chetek, WIBuilt 1946 · S/N 1256 N3272KBossola Raymond L · Suffolk, VABuilt 1946 · S/N 1265 N3314KBartholomew Don · Gardnerville, NVBuilt 1946 · S/N 1307 N3320KZema Monte L · Colville, WABuilt 1946 · S/N 1313 N3334KOneil Thomas E · Salem, OHBuilt 1946 · S/N 1327 N3345KClevenger Jim B · Kissimmee, FLBuilt 1946 · S/N 1338 N3364KShadick Roger R · Eagle River, WIBuilt 1946 · S/N 1357 N3388KMartens John J · Sierra Madre, CABuilt 1946 · S/N 1381 N3389KKaufman Bruce A Trustee · Elm Grove, WIBuilt 1946 · S/N 1382 N3745KMangels Christopher L · Wasilla, AKBuilt 1946 · S/N 1438 N3789KLee Robert E · Medford, WIS/N 1482 N3827KRaibley David M · Redding, CAS/N 3516 N3845KSmith Jeffrey C · Asheboro, NCBuilt 1948 · S/N 3545 N3898KStubblefield Daniel R · Chino Hills, CABuilt 1948 · S/N 3598 N41PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 1128 N42WWZahler Mitchell J · Stillwater, MNS/N 3688 N46KMMoses Kenneth J · Geneseo, NYBuilt 1946 · S/N 95 N59GLLangford Mark A · Harvest, ALBuilt 1946 · S/N 1088 N655SMcclellan George M · Salem, ORBuilt 1946 · S/N 374 N666EEBauer Lawrence L · Grand Rapids, MIBuilt 1948 · S/N 3603 N699RMars Christopher M · Mantua, OHBuilt 1946 · S/N 1084 N711MTaddeo Annie M · Punta Gorda, FLBuilt 1946 · S/N 157 N78097Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1946 · S/N 2097 N78110Fries Tyler · Kenai, AKBuilt 1946 · S/N 2110 N78217Gibsons Gas Inc · Holland, NYS/N 2217 N80589Wight Nathan B · Bethel, MEBuilt 1946 · S/N 92 N80684Domino Adam P · Saint Petersburg, FLBuilt 1946 · S/N 1089 N80749Dalton Gary A · Belton, SCBuilt 1946 · S/N 152 N80808Bauman Michael F · Olney, ILBuilt 1946 · S/N 211 N80836Kirby Jerry N · Westmoreland, TNBuilt 1946 · S/N 239 N80861Mouton Charles J Jr · Gladewater, TXBuilt 1946 · S/N 264 N80947Butler Steve L · Sioux City, IABuilt 1946 · S/N 1140 N90334Watson Gary R · Modesto, CABuilt 1946 · S/N 348 N90354Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1946 · S/N 368 N90385Willis Roger A · Petaluma, CABuilt 1946 · S/N 399 N909UNNiederkorn Richard · Galesville, WIS/N 237 N90CMKing James A · Hines, ORBuilt 1946 · S/N 1119 N99BTaylor Jeffrey S · Cinnaminson, NJBuilt 1946 · S/N 1037

Back to Universal GLOBE GC-1B