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.

N9487SBailey Hugh E · Gainesville, VABuilt 1966 · S/N D-8067 N9492SBlue Line Aerial Productions LLC · Lexington, KYBuilt 1966 · S/N D-8065 N9495SLsa LLC · Kalispell, MTBuilt 1966 · S/N D-8068 N9517QBrasco Inc · Huntley, ILBuilt 1966 · S/N D-8074 N9518QGeorgeson Troy D · Sheyenne, NDBuilt 1966 · S/N D-8080 N9553QTaylor Matt · Tahoka, TXBuilt 1966 · S/N D-8189 N9555QRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1966 · S/N D-8193 N9561QOliver James L · Orion, MIBuilt 1966 · S/N D-8171 N9565QBonanza II LLC · Milton, FLBuilt 1966 · S/N D-8282 N9566QMoskol Jake · Madison, WIBuilt 1966 · S/N D-8201 N9567QDreger Jeffrey W · Poplar Grove, ILBuilt 1966 · S/N D-8202 N9568QN9568q LLC · Lake Worth, FLBuilt 1966 · S/N D-8203 N9574QHarris Steven L Trustee · Sisters, ORBuilt 1966 · S/N D-8205 N9583QHangarfinds LLC · Westminster, COBuilt 1966 · S/N D-8211 N9587QCherokee Flyers Lc · Ellsworth, IABuilt 1966 · S/N D-8214 N9588QNsa LLC · Chandler, AZBuilt 1966 · S/N D-8215 N9598QN9598q LLC · Cincinnati, OHBuilt 1966 · S/N D-8222 N9598VTee William K Jr · Carlisle, MABuilt 1966 · S/N D-8115 N9599QDavis Eric · Pisgah Forest, NCBuilt 1966 · S/N D-8221 N960AGLane Jason R · Tuttle, OKBuilt 1967 · S/N D-8538 N97BJRegistration Pending · Dublin, TXRegistration pendingBuilt 1966 · S/N D-8218 N97WBBowditch Harold W Jr · Lancaster, PABuilt 1967 · S/N D-8386 N981YLavallee David A · Uxbridge, MABuilt 1967 · S/N D-8503 N999ERBalentine Joe B · Alvarado, TXBuilt 1967 · S/N D-8304 N99NTEdwards Mark A · Sedalia, MOBuilt 1965 · S/N D-8019

Back to Beech V35