Skip to content

Registered aircraft · 319

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

N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158 N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035 N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962 N119JSFennen David A · Katy, TXBuilt 1961 · S/N D-6861 N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118 N13RTWoodhouse Dave · Battle Creek, MIBuilt 1962 · S/N D-6954 N1400GRotor Spec Aviation LLC · Star, IDBuilt 1961 · S/N D-6890 N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893 N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891 N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892 N1412GBruch Lance J · Emmetsburg, IABuilt 1961 · S/N D-6895 N1416GNixon Terry L · Enid, OKBuilt 1961 · S/N D-6896 N1417GRomney James J · Fruit Heights, UTBuilt 1962 · S/N D-6902 N1419GMcneal James B · Beaufort, SCBuilt 1962 · S/N D-6900 N1427GCarter Geoffrey R · Ormond Beach, FLBuilt 1962 · S/N D-6903 N1437GMason Mark D · Brighton, COBuilt 1962 · S/N D-6910 N1448GMotions Dynamics LLC · Campbellsville, KYBuilt 1962 · S/N D-6916 N144FFoster Gary E · Kress, TXBuilt 1963 · S/N D-7142 N144GMWilliams David · Golden, MOBuilt 1962 · S/N D-7010 N1454GN1454g LLC · Knoxville, TNBuilt 1962 · S/N D-6914 N1455GNell James E · Pagosa Springs, COBuilt 1962 · S/N D-6920 N1459GBeeson Chris · Graford, TXBuilt 1962 · S/N D-6917 N1477GDobson John F · Union, WABuilt 1962 · S/N D-6980 N1485GHarris John F III · Louisburg, NCBuilt 1962 · S/N D-6933 N1497GDiaz Jose R · Bakersfield, CABuilt 1962 · S/N D-6936 N1500SCianchette R Scott · Hermon, MEBuilt 1961 · S/N D-6897 N1501STaylor Counsel LLC · Hoschton, GABuilt 1962 · S/N D-6898 N1502SMakiva Sasha · Sonoma, CAS/N D-6899 N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037 N1507SArteta David A · Wake Forest, NCBuilt 1962 · S/N D-6935 N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940 N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941 N1525SFreund Edmund A · Lodi, CAS/N D-6967 N1526SMears Bradley J · Burlington, NCBuilt 1962 · S/N D-6969 N1528SWilson Brent S Trustee · Dyer, NVBuilt 1962 · S/N D-6966 N152TConrad Clayton M · San Jose, CABuilt 1962 · S/N D-6956 N1530SThrailkill Robert W · Stockton, CABuilt 1962 · S/N D-6973 N1532ZFlying Y Farms LLC · Klamath Falls, ORBuilt 1962 · S/N D-6855 N1535SGerard Aircraft Inc · Johnson, KSBuilt 1962 · S/N D-6982 N1535ZGsp Aviation LLC · Wichita, KSBuilt 1961 · S/N D-6859 N1538SDeneve Allen J · Herndon, VABuilt 1962 · S/N D-6985 N1539ZGelber Lisa G Trustee · Tujunga, CABuilt 1961 · S/N D-6866 N1544SSharrits Jeffrey J · Carson City, NVBuilt 1962 · S/N D-6925 N1546SBoese Bruce A · Oakdale, CABuilt 1962 · S/N D-6988 N1560ZYoung James Scott · Kemah, TXBuilt 1961 · S/N D-6863 N1565ZStowe Martin D · Carlsbad, CABuilt 1961 · S/N D-6867 N1567SWegener Properties LLC Series Bonanza · Aurora, ILBuilt 1962 · S/N D-6993 N1568ZKeenan Michael Richard Sr · Albuquerque, NMBuilt 1961 · S/N D-6870 N1570ZSalvay Michael E · Long Beach, CABuilt 1961 · S/N D-6872 N1577ZAthuil Philippe · Beverly Hills, CABuilt 1961 · S/N D-6878

Back to Beech P35