Skip to content

Registered aircraft · 459

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

N225SPGross Flying Service Inc · Larned, KSBuilt 1964 · S/N D-7488 N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523 N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609 N22NPPayne David · Maryville, TNS/N D-7354 N22QWCaiati Ulysses H · Fresno, CABuilt 1964 · S/N D-7487 N2340BHenefeld Mark J · Milton, GABuilt 1964 · S/N D-7451 N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326 N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841 N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893 N23DLKnight Robert T · Baton Rouge, LAS/N D-7363 N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311 N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698 N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503 N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429 N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473 N285WAN285wa LLC · Carthage, NCS/N D-7889 N287HHaught Herbie B Jr · Mountain View, ARBuilt 1965 · S/N D-7763 N288FGroove LLC · Afton, VABuilt 1965 · S/N D-7970 N28DJMccrorie David M · Port Angeles, WABuilt 1964 · S/N D-7320 N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372 N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943 N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318 N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811 N317SWMcnaughton Aviation LLC · Bondurant, IABuilt 1965 · S/N D-7854 N327DBonanza Flyers LLC · Aurora, COBuilt 1965 · S/N D-7801 N329XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1964 · S/N D-7509 N32PPDenison Aviation Inc · Atlantic, IABuilt 1964 · S/N D-7702 N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576 N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752 N33HTGroove LLC · Afton, VABuilt 1965 · S/N D-7885 N341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589 N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562 N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659 N354JMountain V-Tail LLC · Denver, COS/N D-7857 N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612 N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516 N35BKNiemi Brian R · Monterey, CABuilt 1964 · S/N D-7685 N35ESMurphy Joel · Flowermound, TXBuilt 1965 · S/N D-7918 N35MSHazeltine Hugh J · Saint Petersburg, FLBuilt 1964 · S/N D-7637 N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393 N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481 N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812 N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321 N3693AC And F Enterprise L L C · Milford, MIBuilt 1964 · S/N D-7384 N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899 N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406 N3JWJason Flood · Vineland, NJBuilt 1964 · S/N D-7591 N3MDMcdavid James J · Weatherford, TXBuilt 1965 · S/N D-7856 N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437 N406WCCebulski Wade E · Seeley Lake, MTBuilt 1964 · S/N D-7723

Back to Beech S35