Skip to content

Registered aircraft · 221

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

N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722 N1148TCorlett Samuel E · Fort Worth, TXBuilt 1958 · S/N D-5453 N119JBWagner Mathew J · Gary, SDBuilt 1958 · S/N D-5683 N12BRManning Richard F · Midway, GABuilt 1957 · S/N D-5391 N135ABShreds Aircraft LLC · Pittsburgh, PABuilt 1957 · S/N D-5399 N14DFCook Charles M · Jay, FLBuilt 1957 · S/N D-5336 N155BPooky Aviation LLC · Augusta, GABuilt 1958 · S/N D-5701 N159AMakray Joseph C · Port Charlotte, FLBuilt 1958 · S/N D-5598 N159PKRegistered aircraftBuilt 1957 · S/N D-5363 N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467 N1958Stonitsch Rudy H · Crestwood, ILBuilt 1958 · S/N D-5619 N213MEMcgough Craig N · Ferris, TXBuilt 1958 · S/N D-5686 N220DKey Larry Wallace II · Early, TXBuilt 1958 · S/N D-5642 N22RRHolmes Amy N · Madison Heights, VABuilt 1958 · S/N D-5445 N257MWillis Charles A · Arlington, TXBuilt 1958 · S/N D-5604 N263AAWilkey Michael B · Kingston, GABuilt 1958 · S/N D-5581 N269BACorporate Aviation Center LLC · Wilmington, DEBuilt 1958 · S/N D-5618 N26EPErid Air LLC · Blackfoot, IDS/N D-5533 N3001CHoyt Robert H · Canby, ORBuilt 1958 · S/N D-5664 N3002CAviation By Gosh LLC · Burlington, TXBuilt 1958 · S/N D-5665 N3005CFodor Vincent A · Doylestown, OHBuilt 1958 · S/N D-5668 N3008CTech Aero Avionics LLC · Denton, TXBuilt 1958 · S/N D-5671 N3012CHealy David Paul · Arlington, TXS/N D-5677 N3015CSorna Douglas J · Flower Mound, TXBuilt 1958 · S/N D-5680 N3016CMoore Todd M · Peoria, ILBuilt 1958 · S/N D-5681 N3020CBrosnan Daniel · Mary Esther, FLBuilt 1958 · S/N D-5685 N3027CPelayo Fernando · La Puente, CABuilt 1958 · S/N D-5692 N3029CHeyneman John M · Sheridan, WYS/N D-5694 N3032CPrice Michael J · Pulaski, NYS/N D-5687 N3033CMetzger James R · Payette, IDBuilt 1958 · S/N D-5688 N3036CSimpkins Larry D · Williamson, WVBuilt 1958 · S/N D-5691 N3039CDammel Stanley J · Odessa, WABuilt 1958 · S/N D-5698 N3043CSelby Air LLC · Lorida, FLBuilt 1958 · S/N D-5704 N3046CStehlik Dennis J · Wheaton, ILBuilt 1958 · S/N D-5610 N3048CThompson Sean R · Trabuco Canyon, CABuilt 1958 · S/N D-5710 N3051CMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5707 N3056CStorholt Wayne R Jr · Plano, TXBuilt 1958 · S/N D-5721 N3057CClb LLC · Lewes, DES/N D-5713 N3059CFellows David O · Mc Alpin, FLBuilt 1958 · S/N D-5715 N3066CBarham Micheal · Bluffton, OHBuilt 1958 · S/N D-5719 N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636 N321DSYoung Winston Shannon Jr · Del Rio, TXBuilt 1958 · S/N D-5661 N322NHBoyette Thomas E · Parker, COBuilt 1958 · S/N D-5646 N338JFElkins Quentin D · Andersonville, TNBuilt 1957 · S/N D-5401 N340QGuetter Steven T · Lakeville, MNBuilt 1958 · S/N D-5486 N354DGGaines Lawrence C · Stockton, CABuilt 1958 · S/N D-5573 N35JSkybound Shenanigans LLC · Dubuque, IABuilt 1958 · S/N D-5699 N35LGAnderson Charles · Bakersfield, CABuilt 1958 · S/N D-5529 N35XFCaudle David William · Arlington, TXBuilt 1958 · S/N D-5674 N36AOral & Maxillofacial Surgery Of Carbondale Inc · Carbondale, ILBuilt 1958 · S/N D-5451

Back to Beech J35