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.

N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389 N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393 N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392 N1701WJagz Aviation LLC · Akron, OHS/N D-9394 N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303 N1717WAdkins Zachary R · Scottsboro, ALBuilt 1972 · S/N D-9368 N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092 N1725WEdwards John G · Stoneville, NCS/N D-9400 N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403 N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405 N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404 N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966 N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406 N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978 N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983 N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984 N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409 N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259 N17629Haven Av LLC · New Braunfels, TXBuilt 1977 · S/N D-9991 N1762WWillis Frederick A · Scottsdale, AZS/N D-9410 N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993 N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995 N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926 N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998 N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413 N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003 N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004 N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010 N17814Sellers Scott · Solsberry, INBuilt 1978 · S/N D-10144 N17816Legal Flying Service Inc · Pembroke Pines, FLBuilt 1977 · S/N D-10011 N17827Cumins Douglas · Mechanicsville, VABuilt 1977 · S/N D-10015 N17840Es Investments LLC · Chandler, AZS/N D-10017 N17865Wcs Inc · Troy, ALBuilt 1977 · S/N D-10021 N17988Gonneville Donald E Jr · Durango, COBuilt 1977 · S/N D-10026 N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179 N17CCReinhart Alan · Ventura, CABuilt 1969 · S/N D-9087 N17FECox Matthew B · Russiaville, INBuilt 1979 · S/N D-10280 N17VMPayne Jerry L · Baton Rouge, LABuilt 1973 · S/N D-9515 N17WFDraper Russell E · Camarillo, CABuilt 1978 · S/N D-10191 N1803LNielsen James I · Waddell, AZBuilt 1976 · S/N D-9871 N1803WCooper Properties Inc · Denver, COBuilt 1972 · S/N D-9421 N1805LJacoby Peter A · Tucson, AZBuilt 1976 · S/N D-9873 N1812LVintage Aviation LLC · Huntington, INBuilt 1976 · S/N D-9875 N1815DOdell Ryan S · Yukon, OKS/N D-10376 N1815GGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N D-10379 N181CBBuchanan Clayton W · Fernandina Beach, FLBuilt 1970 · S/N D-9124 N181PJPeake Herschel S · Dallas, TXBuilt 1976 · S/N D-9876 N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377 N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424 N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877

Back to Beech V35B