Skip to content

Registered aircraft · 319

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

N9626YLester Jon M · Lancaster, OHBuilt 1963 · S/N D-7172 N9628YDowning Eric D · Saint Charles, MOBuilt 1962 · S/N D-7060 N9629YSorbi Aviation Inc · El Cajon, CABuilt 1962 · S/N D-7061 N962SBBlack Steven C · Rocklin, CAS/N D-6844 N9630YLuggelle Michael · Hull, MABuilt 1962 · S/N D-7056 N9631YTidwell James · Rio Linda, CABuilt 1962 · S/N D-7100 N9633YFortson Aviation LLC · Brighton, MIBuilt 1963 · S/N D-7150 N9638YKaufman Michael J · Richland Center, WIBuilt 1962 · S/N D-7064 N963QModer Michael T · New Holstein, WIBuilt 1961 · S/N D-6853 N9640YCampbell Dennis R · Edmonds, WABuilt 1962 · S/N D-7085 N9642YGeorge Raymond R · Lake Havasu City, AZBuilt 1962 · S/N D-7062 N9645YBlue Sky Aero LLC · Appleton, WIBuilt 1962 · S/N D-7065 N9647YChampion Aeromotive LLC · Chesterland, OHBuilt 1962 · S/N D-7066 N9650YZorn Marc E · Sherman Oaks, CABuilt 1962 · S/N D-7081 N9651YBeech O Sphere LLC · Casper, WYBuilt 1962 · S/N D-7069 N9653YRoberts Chance A · Hooper, UTBuilt 1962 · S/N D-7086 N9654YSchwerd Robert E · Prescott, AZBuilt 1962 · S/N D-7073 N9655YHenry Brian J · Napa, CABuilt 1962 · S/N D-7071 N9657YLimor Yoram · Brentwood, CABuilt 1962 · S/N D-7072 N9658YNolf Ruben C · Vancouver, WABuilt 1962 · S/N D-7075 N9659YR & N Associates Worldwide Inc · Port Orange, FLBuilt 1962 · S/N D-7076 N965QHamilton Richard D Jr · Catawba, NCBuilt 1961 · S/N D-6843 N9660YCrawford Russell W · Hickory Creek, TXS/N D-7087 N9662YBerry Brian R · Tahlequah, OKBuilt 1962 · S/N D-7078 N9670YWild Blue Aviation LLC · Eagle Rock, MOBuilt 1962 · S/N D-7091 N9673YSale Reported · Lakeside, MTSale reportedBuilt 1962 · S/N D-7094 N9675YKarpenke Christopher · Rochester, NYBuilt 1962 · S/N D-7093 N9680YSmutny Joseph Robert · Downers Grove, ILBuilt 1963 · S/N D-7106 N9681YHampson Robert J Jr · Oro Valley, AZBuilt 1962 · S/N D-7098 N9685YSmd Air LLC · Cleveland, OHBuilt 1963 · S/N D-7107 N9688ZZimmerman Gerald M · Savannah, GAS/N D-7108 N9693YHodges Christopher · Loganville, GABuilt 1962 · S/N D-7103 N9696YSonoran Sunset Realty LLC · Scottsdale, AZBuilt 1962 · S/N D-7104 N9709YSolo LLC · Hurst, TXBuilt 1963 · S/N D-7119 N9714YSanders Jason · Midland, TXBuilt 1963 · S/N D-7120 N9715YHill Ronald D · Fort Myers, FLBuilt 1963 · S/N D-7122 N9719YRech Ronald P · Woodinville, WABuilt 1963 · S/N D-7121 N9720YNation Robert S · Chesterfield, MOS/N D-7124 N9728YLarson Kenneth J · Lake Havasu City, AZBuilt 1963 · S/N D-7127 N972QN972q LLC · Sheridan, WYBuilt 1961 · S/N D-6851 N9735YWhalen Mark P · Millington, MDBuilt 1963 · S/N D-7131 N9736YAshura-Smith Mary F · Steamboat Springs, COBuilt 1963 · S/N D-7132 N9744YDouble P Creative LLC · Pleasanton, TXBuilt 1963 · S/N D-7141 N9747YRichardson LLC · Henderson, NVBuilt 1963 · S/N D-7136 N974QBailey Jerry D · Sulpher, OKBuilt 1961 · S/N D-6849 N9757YVectair Aviation LLC · League City, TXBuilt 1963 · S/N D-7147 N9761YAllen Karen J · Walnut Grove, CAS/N D-7146 N9763YGrimes Glenn · Greers Ferry, ARBuilt 1963 · S/N D-7148 N9765YHutchinson Kevin J · Poplar Grove, ILBuilt 1963 · S/N D-7151 N9766YGleo LLC · Downers Grove, ILBuilt 1963 · S/N D-7152

Back to Beech P35