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.

N107DBSkymaster Stc LLC · Mena, ARS/N P3370034 N110RLProctor Charles L · Alachua, FLBuilt 1973 · S/N P3370095 N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017 N13FTFenix Private Capital Group LLC · Phoenix, AZS/N P3370245 N1425MRhino Capital Holdings LLC · Bonaire, GABuilt 1974 · S/N P3370162 N151PBarth Brian W · Port Orange, FLBuilt 1972 · S/N P3370058 N178EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N P3370285 N184Rocky Mountain Hangars LLC · Longmont, COBuilt 1974 · S/N P3370206 N187Molina Luis J · Broken Arrow, OKBuilt 1975 · S/N P3370208 N189Jones William Cody · Roxton, TXS/N P3370209 N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165 N19LVLeon Ruben D · Oviedo, FLBuilt 1972 · S/N P3370012 N19SBMcginnis Randall E · Redding, CABuilt 1972 · S/N P3370018 N1CTTre Aviation Corp · Queen Creek, AZBuilt 1972 · S/N P3370001 N1UFGrand Aviation Inc · Grove, OKBuilt 1973 · S/N P3370098 N1ZKSowela Technical Community College · Lake Charles, LAS/N P3370268 N1ZMNazari Nowzar · Rancho Cucamonga, CAS/N P3370200 N1ZRBio Mass LLC · Kalispell, MTBuilt 1977 · S/N P3370275 N20CNuxoll Randy G · Eagle, IDS/N P3370145 N255Sunset Aviation LLC · Klamath Falls, ORBuilt 1975 · S/N P3370213 N259Clark Jack E Jr · Mesa, AZBuilt 1975 · S/N P337-0220 N262Run For The Hills LLC · Kalispell, MTBuilt 1975 · S/N P3370217 N265E&S Management LLC · Miami, FLBuilt 1975 · S/N P3370232 N285Crawford Geoffrey E · Cottonwood, CABuilt 1975 · S/N P3370228 N291Northern Sky LLC · Dover, DEBuilt 1976 · S/N P3370234 N293Zer Holdings LLC · Woodinville, WABuilt 1975 · S/N P3370226 N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172 N2QDSpectraq · Las Vegas, NVS/N P3370277 N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280 N2QKPax Air LLC · Minden, NVS/N P3370283 N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290 N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291 N300Texas Sky Masters Inc DBA · Dallas, TXBuilt 1976 · S/N P3370236 N30GPCedar Mountain Respiratory Inc · Athol, IDBuilt 1975 · S/N P3370212 N30STennessee Technology Center At Morristown · Morristown, TNBuilt 1973 · S/N P3370147 N31ZWestern Skymasters LLC · Salt Lake City, UTBuilt 1973 · S/N P3370028 N326Nardi Greg · Missoula, MTS/N P33700238 N337CGH&J Flight One LLC · Sun City West, AZBuilt 1973 · S/N P3370143 N337JJJodice Timothy · Amherst, NHBuilt 1972 · S/N P3370026 N337KMAltamont Air LLC · Dublin, CAS/N P3370263 N337MWMtw Aerospace Inc · Montgomery, ALBuilt 1972 · S/N P3370021 N337RTillman Tracy S · Webberville, MIBuilt 1977 · S/N P3370282 N337RGStephens Kenneth Joe · Bristol, TNBuilt 1972 · S/N P3370067 N337RRLara Oscar · Bonita, CABuilt 1973 · S/N P3370116 N337RSDinwiddie Michael R · Sunbury, OHS/N P3370074 N337TGSafe & Sound LLC · Kalispell, MTBuilt 1979 · S/N P3370281 N337WWTobias John M · Sedona, AZBuilt 1973 · S/N P3370106 N34ECGerard Aircraft Inc · Battle Creek, MIBuilt 1975 · S/N P3370224 N355Roads Development LLC · Miami, FLS/N P3370239 N364Farmers Bank · Parsons, TNBuilt 1976 · S/N P3370243

Back to Cessna T337G