Skip to content

Registered aircraft · 913

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

N2035PHubert John P · Austin, TXBuilt 1978 · S/N D-10176 N2038UWorld Aero Space Ltd · Henderson, NCBuilt 1978 · S/N D-10180 N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898 N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183 N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181 N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185 N20478V35b Bonanza LLC · Temecula, CAS/N D-10194 N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190 N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193 N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198 N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196 N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204 N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247 N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202 N20603Burlington Air Center Inc · Burlington, WIBuilt 1978 · S/N D-10207 N2062BWalker Marshall E · Lancaster, SCBuilt 1979 · S/N D-10205 N20654Spatz Phillip D · League City, TXBuilt 1979 · S/N D-10212 N2065YAbel Instruments Inc · Riviera Beach, FLBuilt 1979 · S/N D-10211 N2066NBobo Kenneth · Auburndale, FLBuilt 1979 · S/N D-10215 N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902 N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904 N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908 N2090LBarnes Seth M · Hot Springs, ARS/N D-10074 N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371 N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411 N2105LBishop William E · Fredericksburg, TXBuilt 1976 · S/N D-9912 N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917 N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916 N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918 N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920 N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913 N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851 N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923 N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648 N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077 N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078 N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938 N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940 N222DTClipper Sky LLC · Las Vegas, NVS/N D-10130 N222SMMacknight James G · Morgan Hill, CABuilt 1976 · S/N D-9958 N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152 N2255NMalard Darren L · Bismarck, NDBuilt 1974 · S/N D-9580 N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939 N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944 N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945 N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682 N2283LMoser Jerald L · Tucson, AZS/N D-9948 N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949 N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947 N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997

Back to Beech V35B