Skip to content

Registered aircraft · 96

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

N110NPJungemann Jeff D · Brigham City, UTBuilt 1973 · S/N 33701565 N122WB2sea2it LLC · Ossining, NYBuilt 1973 · S/N 33701487 N1311LCarpe Diem Atb LLC · Northfield, MNS/N 33701804 N1312LMccole Kevin · Brookline, NHBuilt 1977 · S/N 33701805 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N133NDHitch-Nel Partners LLC · Issaquah, WABuilt 1975 · S/N 33701669 N1871MHickam James R · Dayton, WABuilt 1973 · S/N 33701471 N1872MRenforth Michael · Yorktown, VAS/N 33701472 N1873MAsmus Edward W III · Sugar Grove, ILBuilt 1973 · S/N 33701473 N1880MPalm Hammock II LLC · Zolfo Springs, FLS/N 33701480 N1881MBrutlag Farms Inc · Wendell, MNBuilt 1973 · S/N 33701481 N1890MPutney Bruce N · Midlothian, TXS/N 33701490 N1952MLatimore Company LLC · Snohomish, WABuilt 1975 · S/N 33701665 N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684 N222LJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 33701764 N24DCCraig Joshua · Bonaire, GABuilt 1975 · S/N 33701640 N27JAPacific Aviation Management Inc · Fresno, CABuilt 1976 · S/N 33701747 N297DCPriority Farms · Glenn, CAS/N 33701697 N3048Speck Michael A · Friendswood, TXBuilt 1972 · S/N 33701470 N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731 N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782 N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491 N337BNDestiny Center Inc · Murfreesboro, TNBuilt 1972 · S/N 33701449 N337CDKeller Stephen P · Wichita, KSBuilt 1973 · S/N 33701495 N337CEBeam David M · Sabina, OHBuilt 1976 · S/N 33701762 N337DWR And R Aircraft Inc · Delray Beach, FLBuilt 1975 · S/N 33701652 N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600 N337EXTrepanier Dennis A · Agua Dulce, CAS/N 33701737 N337FRomain Dennis · Payson, AZBuilt 1973 · S/N 33701547 N337GDPorrima Photonix Inc · Las Cruces, NMBuilt 1979 · S/N 33701921 N337GSJc Holding LLC · Wilmington, DEBuilt 1973 · S/N 33701520 N337JRInternational Air Services Inc Trustee · Carson City, NVS/N 33701474 N337LPSkymaster Stc LLC · Mena, ARBuilt 1977 · S/N 33701750 N337PHayes James J · San Diego, CAS/N 33701535 N337SSState Of Wisconsin/Doa · Madison, WIBuilt 1976 · S/N 33701716 N337WAGyron Eagle Ltd · Pasadena, CABuilt 1975 · S/N 33701651 N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563 N37BJDodson Jeffrey C · Monroe, GABuilt 1973 · S/N 33701503 N49CBMacair Aviation LLC · Xenia, OHBuilt 1973 · S/N 33701551 N4ACWright Thomas L · Clyde, OHBuilt 1972 · S/N 33701464 N513International Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N 33701572 N5222TRcs Services LLC · California, MDBuilt 1975 · S/N 33701655 N53418N53418 LLC · Orlando, FLBuilt 1974 · S/N 33701611 N53420Kropp Christian Trustee · Azle, TXBuilt 1974 · S/N 33701613 N53434Caswell Jeff S · Durham, CABuilt 1974 · S/N 33701621 N53449Hyde Russell M · Rutherfordton, NCS/N 33701631 N53475Rw Aviation LLC · Fishers, INBuilt 1975 · S/N 33701649 N53504Aviation Adventures LLC · Hansen, IDBuilt 1975 · S/N 33701664 N53510Joey Os LLC · Darlington, PABuilt 1975 · S/N 33701670 N53519Gic Inc · Oneill, NEBuilt 1975 · S/N 33701677

Back to Cessna 337G