Skip to content

Registered aircraft · 237

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

N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076 N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009 N126SAS2 Aviation LLC · Biloxi, MSBuilt 1959 · S/N D5817 N12711Oxman Judith R · Riva, MDBuilt 1965 · S/N D-5834 N131MDWoodley Aerial Leasing LLC · Walnut, ILBuilt 1959 · S/N D-5978 N135RRMorse-Ellington Bruce P · Phoenix, MDBuilt 1959 · S/N D-5935 N159MDLaw Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1959 · S/N D-5849 N16MJHangarfinds LLC · Westminster, COBuilt 1959 · S/N D-6023 N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857 N184QSchmuker David Joseph · Grand Rapids, MIBuilt 1959 · S/N D-5954 N189AAJungclaus Karl F · Piedmont, SDBuilt 1959 · S/N D-6024 N191AAPelz Thomas G · Boscobel, WIBuilt 1959 · S/N D-5914 N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964 N199AAHeide Charles H · Kenosha, WIBuilt 1958 · S/N D-5781 N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760 N2088CBeech K Holdings LLC · Sheridan, WYBuilt 1959 · S/N D-6044 N2110Firczak Scott William · Mt Ulla, NCBuilt 1959 · S/N D-5901 N213PBKofman Peter M · Mountain Grove, MOBuilt 1959 · S/N D-5791 N217AAMoore Augustus Shine · Denver, COBuilt 1959 · S/N D-6004 N2217YLehmer Kenneth D Trustee · Pls Vrds Est, CABuilt 1959 · S/N D-6056 N221BDMerrell Jacob Everette · Pace, FLBuilt 1958 · S/N D-5748 N235AADifferent Auto LLC · Twin Falls, IDBuilt 1959 · S/N D-5967 N247AAN247aa LLC · Benton, KSBuilt 1959 · S/N D-6034 N24RMTittlemier Warren L · Ventura, CABuilt 1959 · S/N D-5805 N254AAKelly Charles M · San Angelo, TXBuilt 1959 · S/N D-6032 N261AARoy Michael W · Pear Valley, TXBuilt 1959 · S/N D-5855 N3047CEver Fast LLC · Kalispell, MTS/N D-5771 N3061CTharp Aerospace LLC · Charleston, SCBuilt 1958 · S/N D-5757 N3067CGoncharov Serge S · Monroe, NCBuilt 1958 · S/N D-5731 N3071CSimpkins Randolph J · Eagan, MNBuilt 1958 · S/N D-5727 N3079CTre Aviation Corp · Wilmington, DEBuilt 1958 · S/N D-5759 N3083CBear Boss LLC · Missoula, MTBuilt 1958 · S/N D-5754 N3084CHeft Joel R · Mcgregor, TXBuilt 1958 · S/N D-5755 N3085CRoberts Marc A · Thomasville, PABuilt 1958 · S/N D-5761 N3088CMeester Daniel J · Longmont, COBuilt 1958 · S/N D-5773 N3089CWeatherly Richard A · Newport, WABuilt 1958 · S/N D-5772 N308EShannon Jesse L · Boise City, OKS/N D-5763 N3092CAhmed Sharfaraz · Houston, TXBuilt 1959 · S/N D-5786 N3094CHamllin Jeffry S · Double Oak, TXBuilt 1958 · S/N D-5783 N3095CLittle Karley Y · Baytown, TXBuilt 1958 · S/N D-5774 N3096CGrant Benjamin D · Chesterfield, MIBuilt 1958 · S/N D-5789 N3097CAviation Hangar LLC · Wentzville, MOBuilt 1958 · S/N D-5787 N3099CTurpin Terry S · Foster City, CABuilt 1958 · S/N D-5782 N311JWBonanza 311 Jw Limited · Urbandale, IABuilt 1959 · S/N D-5925 N313FFerguson John Edward · Santa Ysabel, CABuilt 1958 · S/N D-5764 N321XVerrall Charles Peter Jr · Florence, AZS/N D-5990 N35ABElk River Aero LLC · Noel, MOBuilt 1959 · S/N D-6067 N35JWN35jw LLC · Enid, OKBuilt 1959 · S/N D-5872 N409RCrawford Russell W · Hurricane, UTS/N D-6011 N40NLVetter Brent E · Helena, MTBuilt 1958 · S/N D-5743

Back to Beech K35