Skip to content

Registered aircraft · 425

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

N62EMHarris Jesse C IV · Laurel Park, NCBuilt 1966 · S/N D-8081 N62GBBeavers Glenn A · Wichita Falls, TXBuilt 1967 · S/N D-8566 N635VSun Up Farm LLC · Nacogdoches, TXBuilt 1966 · S/N D-8083 N647DKSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1967 · S/N D-8583 N65AJAitkens Larry · Port Saint Lucie, FLBuilt 1966 · S/N D-8099 N65BWBuzzard Max · Tulsa, OKS/N D-8294 N65LVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N D-8238 N661SBLusby Robert G Jr · Knoxville, TNBuilt 1966 · S/N D-8233 N66TCJohnson Dennis A · Bowman, GAS/N D-8061 N66VVFarrell William J · Fort Myers, FLBuilt 1966 · S/N D-8271 N670TWThunderbolt Ltd · Salem, NEBuilt 1967 · S/N D-8434 N671SHEnochian Gary F · Santa Rosa, CABuilt 1966 · S/N D-8034 N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470 N67RCBueter Eric J · Wauseon, OHS/N D-8049 N67VBRegistration Pending · Athens, TNRegistration pending, pending cancellationBuilt 1967 · S/N D-8428 N680RSSamples Ryan · Edmond, OKBuilt 1966 · S/N D-8298 N6AYTwin Cities Aviation Inc · Yuba City, CABuilt 1966 · S/N D-8344 N6MYPruitt Robert G · Russellville, ARS/N D-8107 N700BTHogan Christopher S · Colorado Springs, COBuilt 1966 · S/N D-8076 N707BRCawood William Richard · Mountain Rest, SCBuilt 1966 · S/N D-8312 N70SSJones Terry L · Danville, VABuilt 1966 · S/N D-8024 N721RSStill Charles · Fountain Valley, CABuilt 1966 · S/N D-8086 N74SKKoontz Construction Inc · Livingston, MTBuilt 1966 · S/N D-8148 N755XLandis David A · Perryton, TXBuilt 1967 · S/N D-8578 N756EEHoster Keith DBA · Gordon, TXS/N D-8549 N757ERJohnson Nathaniel D · Attalla, ALBuilt 1966 · S/N D-8139 N767TMJavelina Aero LLC · Sheridan, WYBuilt 1967 · S/N D-8556 N774SDr Leasing Ltd · Wilmington, DEBuilt 1966 · S/N D-8088 N777BCBas Part Sales LLC · Greeley, COBuilt 1966 · S/N D-8230 N777JMFulton David S · Austin, TXBuilt 1966 · S/N D-8085 N777TLStemmer Steven N · Huntersville, NCBuilt 1966 · S/N D-8302 N777YAerotrack Inc · Hemet, CABuilt 1966 · S/N D-8296 N779RBRbi Trading LLC · Morton Grove, ILBuilt 1966 · S/N D-8244 N7856LGall Peter D · Morgantown, WVBuilt 1966 · S/N D-8289 N7868LJacob William G · Glendora, CABuilt 1966 · S/N D-8292 N7869LCrawford Scott · Newalla, OKBuilt 1966 · S/N D-8293 N7875LRegistered aircraftBuilt 1966 · S/N D-8295 N7879LCjp Air LLC · Mustang, OKBuilt 1966 · S/N D-8318 N7883LJinnette James G · Raleigh, NCBuilt 1966 · S/N D-8301 N7885LGriffin Brad W · Salome, AZBuilt 1966 · S/N D-8303 N7893LLilya Trever L · Mesa, AZBuilt 1966 · S/N D-8306 N7895LRemington Pierce S · De Kalb, MOS/N D-8297 N789PDSwords Steven T · Rancho Mirage, CABuilt 1966 · S/N D-8290 N7900MRegistered aircraftBuilt 1966 · S/N D-8223 N7902MBig Blue Sky LLC · Indianapolis, INBuilt 1966 · S/N D-8227 N7911MGillette David L · Mount Pleasant, TXBuilt 1966 · S/N D-8225 N7921MMiller Dennis J · Bartlett, TNBuilt 1966 · S/N D-8251 N7922MDestination Aero LLC · Lubbock, TXBuilt 1966 · S/N D-8235 N792DMDkl Inc · Ardmore, OKBuilt 1966 · S/N D-8354 N7932MPower James P · Box Elder, SDBuilt 1966 · S/N D-8241

Back to Beech V35