Skip to content

Registered aircraft · 50

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

N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024 N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202 N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023 N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127 N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102 N2125XMathews Wade · Wichita Falls, TXBuilt 1965 · S/N 337-0025 N2131XBrown Jerry D · Rockport, TXS/N 337-0031 N2138XSpencer Douglas J · Greenwood, CABuilt 1965 · S/N 337-0038 N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039 N2168XOrtiz Stewart Flynn · San Diego, CABuilt 1965 · S/N 337-0068 N2186XAshiku Phillip · Ukiah, CABuilt 1965 · S/N 337-0086 N2192XGoldsmith Alejandro J · Houston, TXBuilt 1965 · S/N 337-0092 N2200XPowell George · Locust Grove, GABuilt 1965 · S/N 337-0100 N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116 N2222XOrtiz Stewart Flynn · San Diego, CAS/N 337-0122 N2224XRegistered aircraftBuilt 1965 · S/N 337-0124 N2238XStyron Mark A · Pasadena, TXS/N 337-0138 N2240XTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1965 · S/N 337-0140 N2243XSmith Debra A · Louisville, KYS/N 337-0143 N2244XPlane Life LLC · Wilmington, DEBuilt 1965 · S/N 337-0144 N2255XProp & Jet Air Museum Inc · Romoland, CAS/N 337-0155 N2256XPoole Douglas G · California, MDBuilt 1965 · S/N 337-0156 N2262XStampfler Richard D · Groveland, MABuilt 1965 · S/N 337-0162 N2266XBarney Julius C · Lutz, FLBuilt 1965 · S/N 337-0166 N2267XRound Engine Aero · Nashville, MIBuilt 1965 · S/N 337-0167 N2271XSantaska Inc · Palmer, AKBuilt 1965 · S/N 337-0171 N2273XAll Florida Recovery Corp · Palm Coast, FLS/N 337-0173 N2274XDutko Adam M · Elyria, OHBuilt 1965 · S/N 337-0174 N2279XSander Farms Inc · Wilmington, DEBuilt 1965 · S/N 337-0179 N2284XWilson Gregory S · Cairo, MOBuilt 1965 · S/N 337-0184 N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190 N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194 N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199 N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159 N337AFKinetic Concepts LLC · Pensacola, FLBuilt 1967 · S/N 67-21344 N337LASturgeon Kenneth V · Winter Garden, FLBuilt 1965 · S/N 337-0134 N337RTTorres Ramon A · Mulberry, FLBuilt 1965 · S/N 337-0089 N337WGGrady Charles Martin · La Verne, CABuilt 1965 · S/N 337-0091 N4311UMoreland Wesley M · Mckinney, TXBuilt 1965 · S/N 337-0093 N4567GKris Noone Air LLC · Wilmington, DEBuilt 1965 · S/N 337-0110 N4NGWestern Skymasters LLC · Salt Lake City, UTS/N 33701787 N55CSHammond Neil K · Manhattan, KSBuilt 1965 · S/N 337-0222 N621GTFox Edward Philip Jr · New Market, ALS/N M337-0292 N6220FHeberle David B · Castroville, TXBuilt 1965 · S/N 337-0220 N6228FLynch Kent · Edwards, ILBuilt 1965 · S/N 337-0228 N655CFCarter James W · Dyersburg, TNBuilt 1964 · S/N 337-0016 N6ZDCawley Galen P · Coloma, MIBuilt 1965 · S/N 337-0209 N727JTStory Billy G · Kempner, TXBuilt 1965 · S/N 337-0200 N740MHumphrey William A · Grosse Ile, MIBuilt 1965 · S/N 337-0160 N748XMorgan Bryon E · Eugene, ORS/N 3370029

Back to Cessna 337