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.

N7946MGriesinger William R Trustee · Colorado Springs, COBuilt 1966 · S/N D-8255 N7966MEagle Aviators LLC · Franklin, VABuilt 1966 · S/N D-8258 N7967MMercer Aero Service Inc · Aurora, COBuilt 1966 · S/N D-8260 N7969MN7969m LLC · Double Oak, TXBuilt 1966 · S/N D-8283 N7976MHudson Kent O · Anchorage, AKBuilt 1966 · S/N D-8268 N7977MLoskill Edwin R · Lubbock, TXBuilt 1966 · S/N D-8269 N7979MFrancis William · Lake Oswego, ORS/N D-8270 N797RHCya Ltd · Crystal Lake, ILBuilt 1965 · S/N D-8022 N7987MKrikorian Philip R · Fresno, CABuilt 1966 · S/N D-8273 N7988MBlandon Pedro Md Pa · El Paso, TXBuilt 1967 · S/N D-8471 N798RDSmith Lawrence M · Jacksonville, FLBuilt 1967 · S/N D-8528 N7998MBertelli Leonard DBA · Lancaster, SCBuilt 1966 · S/N D-8278 N8000LWeeks Stanley III · Taneyville, MOBuilt 1965 · S/N D-8000 N8109BBrent Alan Reiner · Dillon, MTBuilt 1966 · S/N D-8224 N815QSumo Tails Ltd · Wilmington, DEBuilt 1966 · S/N D-8286 N8272TWayne Clinton · Greenfield, INBuilt 1967 · S/N D-8473 N82MSShifflett Kenneth · Olive Branch, MSBuilt 1966 · S/N D-8108 N855DSAerolutions LLC · Preston, IDBuilt 1966 · S/N D-8287 N8577QRegistration Pending · Amarillo, TXRegistration pendingS/N D-8208 N858DFulmer Robert Alan · Irvine, CABuilt 1966 · S/N D-8200 N87565Jerrys Kids Aviation LLC · Wilmington, DEBuilt 1967 · S/N D-8490 N87DBBlanchat Manufacturing Inc · Harper, KSBuilt 1967 · S/N D-8570 N888KWHink Ronald · Memphis, TXBuilt 1966 · S/N D-8219 N8944DFerguson Parker W · Norman, OKBuilt 1966 · S/N D-8285 N89JSPh Flight Services LLC · Wilmington, DEBuilt 1967 · S/N D-8537 N8MPForeman Thomas H · Orange, TXBuilt 1966 · S/N D-8059 N9048SWienke Maximillian Martin · Sheppard Afb, TXBuilt 1966 · S/N D-8035 N9050SPense Jeff · Jenks, OKBuilt 1965 · S/N D-8038 N911GHamilton Jason W · Jefferson, TXBuilt 1966 · S/N D-8198 N911KRaper David A · Mesa, AZBuilt 1966 · S/N D-8253 N911VGlatt Christopher D · Saint Paul, MNBuilt 1966 · S/N D-8091 N916RCDw Aviation LLC · San Diego, CABuilt 1966 · S/N D-8326 N9405SHackbarth Dean R · Henderson, NVBuilt 1965 · S/N D-8010 N9406SMorales Harry · Hilton Head Island, SCBuilt 1965 · S/N D-8011 N9407SRobinett Barton L · Frankston, TXBuilt 1965 · S/N D-8012 N9410SMoore James F · Higden, ARS/N D-8013 N9412SSamels Randy · Simi Valley, CAS/N D-8014 N9420SBaumann James R · Muskogee, OKS/N D-8015 N9421SFugate Kirk A · El Dorado Springs, MOBuilt 1965 · S/N D-8017 N9422SWindwalker Adventures LLC · Scottsdale, AZBuilt 1965 · S/N D-8020 N9423STlc Aero LLC · Magnolia, TXBuilt 1965 · S/N D-8018 N9431SBurgdorf Dale A · Plano, TXBuilt 1965 · S/N D-8021 N9439SDocs Huckleberry LLC · Cornell, WIS/N D8025 N944RMKrol Matthew D · Hideaway, TXBuilt 1965 · S/N D-8026 N9450SDakota Sierra LLC · Horace, NDBuilt 1966 · S/N D-8045 N9455SBlythe Edward A · Dallas, TXBuilt 1966 · S/N D-8050 N9456SHerrick Richard J Trustee · Lenox, MABuilt 1966 · S/N D-8036 N9461SAndre David A Trustee · Webster Groves, MOBuilt 1966 · S/N D-8053 N9467SV35 LLC · Portland, ORBuilt 1966 · S/N D-8054 N9478SRocket Pjr LLC · Helena, MTBuilt 1966 · S/N D-8057

Back to Beech V35