Skip to content

Registered aircraft · 55

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

N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431 N211EWJtb Logistics LLC · Byars, OKBuilt 1966 · S/N 337-0443 N337FTMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3370384 N337JFBeaty Andrew R Jr · Wichita Falls, TXBuilt 1966 · S/N 3370391 N337SMFlippin Birds Aircraft LLC · Miami, FLS/N 3370495 N337TSWalz Steve · Kiowa, KSBuilt 1966 · S/N 337-0300 N337VGBvj Skymaster Inc · Appleton, MNS/N 337-0435 N337YBrokaw Burton · Tucson, AZBuilt 1966 · S/N 337-0449 N389WAOlsen Donald Jr · Silverdale, WABuilt 1966 · S/N 337-0389 N446SNWarren Dennis · Las Vegas, NVBuilt 1966 · S/N 337-0454 N502CSIsr Platforms LLC · Mclean, VABuilt 1966 · S/N 337-0280 N5302SHazelip Jason A · Harrodsburg, KYS/N 337-0402 N5305SJohnson Brent C · Appleton, MNBuilt 1966 · S/N 337-0405 N5309SEnd Poverty Now Inc · Maumee, OHS/N 337-0409 N5315SDejean Karl J · Colorado Springs, COBuilt 1966 · S/N 337-0415 N5325SR & H Aviation LLC · Shady Shores, TXBuilt 1966 · S/N 337-0425 N5327SLowry Steve H · Sun River, MTBuilt 1966 · S/N 337-0427 N5342SFranco Gloria J · Las Vegas, NVS/N 337-0442 N5352SGustafson Steven R · Jamestown, NYBuilt 1966 · S/N 337-0452 N5353SBressler Lewis S · Simi Valley, CABuilt 1966 · S/N 337-0453 N5365SGamm Stephene Wade · Warrenton, VAS/N 337-0465 N5367SMedvetsky Dennis · Lincoln, RIBuilt 1966 · S/N 337-0467 N5380SRoss Rexford E · Phoenix, AZBuilt 1966 · S/N 337-0480 N5383SScharber Patrick · Monticello, MNBuilt 1966 · S/N 337-0483 N5386SDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 337-0486 N5387SGoyer Jeffrey A · Houston, TXBuilt 1966 · S/N 337-0487 N5420SLindquist Scott A · Minnetonka, MNS/N 337-0520 N59327Smith Steve W · Mackay, IDBuilt 1966 · S/N 337-0373 N613WCAmpaire Inc · Hawthorne, CABuilt 1966 · S/N 337-0372 N6243FReim Rodney D · Enid, OKBuilt 1965 · S/N 337-0243 N6244FRegistered aircraftBuilt 1965 · S/N 337-0244 N6245FCosse Harold C · Euless, TXS/N 337-0245 N6246FCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0246 N6248FStevenson David E · Grundy, VAS/N 337-0248 N6250FNeeper Philip A · Fayetteville, NCBuilt 1965 · S/N 337-0250 N6267FSkymaster Company LLC · Dover, DES/N 337-0267 N6276FHubler Bruce F · Caldwell, IDS/N 337-0276 N6284FMathews Wade A · Wichita Falls, TXS/N 337-0284 N6288FAircraft Leasing And Service · Malabar, FLBuilt 1965 · S/N 337-0288 N6297FHitchcock Lonnie G · Sparta, TNS/N 337-0297 N6298FKubik John A · Hardy, VAS/N 337-0298 N6299FLynch Gregory R · Pahrump, NVBuilt 1966 · S/N 337-0299 N6310FKierstead Andrew R · Alton Bay, NHS/N 337-0310 N6311FGlasow Eric J · Simpsonville, SCBuilt 1966 · S/N 337-0311 N6312FCade Steve DBA · Lopez Island, WABuilt 1966 · S/N 337-0312 N6315FSavidge Lenice M · Rogers, ARS/N 337-0315 N6342FNetherton Ricky D · Blair, OKBuilt 1966 · S/N 337-0342 N6352FFletcher John G · Diamondhead, MSS/N 337-0352 N6361FTramper Air LLC · Rockford, MIBuilt 1966 · S/N 337-0361 N6362FCabral Nicholas · Oldsmar, FLBuilt 1966 · S/N 337-0362

Back to Cessna 337A