Skip to content

Registered aircraft · 118

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

N37LSKing Jay C · Vero Beach, FLBuilt 1973 · S/N P3370084 N397Ioannou Yiannakis C · Wilmington, NCBuilt 1976 · S/N P3370248 N3CMOxbow Investments LLC · Sonora, CABuilt 1972 · S/N P337-0025 N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022 N407Lyford Charles A IV · Bellevue, WABuilt 1976 · S/N P3370251 N424Ross Michael J · Los Angeles, CABuilt 1976 · S/N P3370259 N493WCOsness Rhonda R · Bisbee, NDBuilt 1973 · S/N P3370090 N49920Maw Robert J Jr · Albuquerque, NMBuilt 1973 · S/N P337-0092 N4BFFlying W Aircraft LLC · Brookfield, CTBuilt 1974 · S/N P3370190 N4CFPotomac Skymasters LLC · Alexandria, VAS/N P3370038 N4CTSos David M · Chico, CAS/N P3370004 N4CYAndersen Crossan R · Los Angeles, CABuilt 1973 · S/N P3370081 N4PFZamaga LLC · Saint Petersburg, FLS/N P3370186 N4SLTime Air LLC · Mendon, UTBuilt 1972 · S/N P3370049 N54EPortland Community College · Portland, ORBuilt 1973 · S/N P3370156 N54JRBlock John R · Pittsburgh, PABuilt 1977 · S/N P3370278 N55791Steve Roundy Family Lp · St George, UTS/N P337-0085 N56DSM E L LLC · Wilmington, DEBuilt 1973 · S/N P3370048 N56SLemberger John R · West Lake Hills, TXBuilt 1974 · S/N P3370173 N57CCavu Aviation LLC · Tulsa, OKBuilt 1973 · S/N P3370091 N58CSierra 1 Tech Inc · Blue Jay, CABuilt 1973 · S/N P3370102 N5CYKawasaki Clyde H · Carson City, NVS/N P337-0083 N5ZXPush Pull LLC · Lewes, DEBuilt 1977 · S/N P3370273 N619DT6 Dt Flyers LLC · Corpus Christi, TXS/N P3370123 N62NAAdventure Aviation West LLC · Kalispell, MTS/N P3370269 N62SGozashti Farid H · Abilene, TXBuilt 1973 · S/N P3370160 N639GCCenterline Thrust LLC · Ingleside, TXBuilt 1977 · S/N P3370287 N648NHVenice Group LLC · Hopkinton, NHS/N P3370063 N64SN81c Corp LLC · Wilmington, DES/N P3370179 N65SKenyon Ray · Sherburne, NYBuilt 1974 · S/N P3370166 N662KC216 Skymaster Series LLC · Keller, TXS/N P3370216 N67SSchultz Daniel A · Tipp City, OHBuilt 1974 · S/N P3370168 N685VAlpha Golf Flyers Inc · Wilmington, DEBuilt 1976 · S/N P3370265 N69SInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N P3370170 N6CSJj Ventures LLC · Billings, MTBuilt 1973 · S/N P3370088 N6CVEubanks Edward · Tulsa, OKBuilt 1973 · S/N P3370053 N6CXMora Leo G · Groveland, CAS/N P3370076 N6LRClipper 6 Lima Romeo LLC · Rapid City, SDS/N P3370119 N70SFreedman Daniel · Santa Ana, CABuilt 1974 · S/N P3370187 N718RWWestern Skymasters LLC · Salt Lake City, UTS/N P3370211 N71SNorth Pine Properties LLC · Queen Creek, AZBuilt 1974 · S/N P3370171 N72CABrooks Duane T · Mt Shasta, CABuilt 1972 · S/N P3370027 N77CMRegistered aircraftBuilt 1973 · S/N P337-0015 N79CNew World Wind Ltd · Quartzsite, AZS/N P3370108 N7CXChapman Daniel W · Soldotna, AKBuilt 1972 · S/N P337-0077 N80NInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N P3370197 N82ESkymaster Mods & Parts LLC · Castalian Springs, TNBuilt 1973 · S/N P3370126 N84CWestern Summit Enterprises Inc · Pacoima, CAFirst renewal noticeBuilt 1973 · S/N P3370115 N84EBas Part Sales LLC · Greeley, COBuilt 1973 · S/N P3370142 N84LCRegistered aircraftBuilt 1976 · S/N P3370246

Back to Cessna T337G