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.

N100ANWatson Family Investments LLC · Houston, TXBuilt 1977 · S/N D-10084 N100KJDrewyor Kenneth · Eaton Rapids, MIBuilt 1977 · S/N D-9987 N100KWBaldassarre Thomas Anthony · Gillette, NJBuilt 1980 · S/N D-10336 N100NNDunnair LLC · Panama City, FLBuilt 1973 · S/N D-9465 N100PRKinder Eric Eugene Trustee · Tucson, AZBuilt 1970 · S/N D-9167 N100SPWright Richard S · Half Moon Bay, CABuilt 1970 · S/N D-9107T N100TXJones Joseph Clayton · Bossier City, LABuilt 1976 · S/N D-9854 N1016WMichael Deem Crow · Pilot Point, TXBuilt 1973 · S/N D-9478 N1018WLampe Ryan · Leonardtown, MDBuilt 1973 · S/N D-9449 N101WEBadgerland Aero LLC · Las Vegas, NVBuilt 1971 · S/N D-9231 N1024TBarnwell John Randel · Conroe, TXBuilt 1976 · S/N D-9941 N1025WBancroft Maurice J · Rio, WIBuilt 1973 · S/N D-9453 N1026TEdens Erik · Scottsdale, AZBuilt 1976 · S/N D-9981 N102JMHeld John S · Cincinnati, OHBuilt 1979 · S/N D-10216 N1030WBowles David A · Matthews, NCS/N D-9452 N1032WOhlinger Mark A · Copley, OHBuilt 1973 · S/N D-9454 N1033WPunci Aviation II LLC · Port Washington, WIS/N D-9455 N1040WFoolish Pleasure Aviation Inc · Lewes, DEBuilt 1979 · S/N D-10203 N1044WAngier 66 LLC · Durham, NCBuilt 1973 · S/N D-9457 N1094WPolhemus Paul L Jr · Lodi, CABuilt 1973 · S/N D-9470 N10BPPeyton James L II · Granby, COBuilt 1973 · S/N D-9533 N10BVZondlo Todd · Phoenix, AZBuilt 1972 · S/N D-9345 N10EEBucci Dennis · Pittsburgh, PABuilt 1971 · S/N D-9307 N1102WEckberg Stephen A · Merritt Island, FLBuilt 1973 · S/N D-9472 N1110WFoulks Alan Lee Trustee · Glendale, AZBuilt 1972 · S/N D-9310 N111GMCarder Wiley C · Cameron Park, CAS/N D-10081 N111PFFinefield James P · Cary, ILBuilt 1971 · S/N D-9300 N111TMIreland David A · Eatonville, WABuilt 1976 · S/N D-9974 N1120MRichter Keith B · Oro Valley, AZBuilt 1972 · S/N D-9346 N1122PTroccoli Peter Trustee · Paradise Valley, AZBuilt 1978 · S/N D-10120 N1129TStapleton Thomas · Avon, INBuilt 1976 · S/N D-9867 N113TWD'Antoni Gary L · Katy, TXBuilt 1973 · S/N D-9539 N114JDVintage Motors Inc · Beattyville, KYBuilt 1973 · S/N D-9420 N114TPGrj LLC · Lexington, SCBuilt 1975 · S/N D-9801 N114WREstes Aviation LLC · Vicksburg, MSS/N D-10052 N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761 N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371 N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754 N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770 N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529 N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777 N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369 N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298 N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234 N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891 N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248 N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283 N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794 N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221 N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412

Back to Beech V35B