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.

N124DRendezvous Island Air LLC · Fort Collins, COS/N 10002 N125PCRegistered aircraftBuilt 1978 · S/N D-10148 N125TR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1973 · S/N D-9560 N126WGN126wg LLC · Oak Brook, ILBuilt 1972 · S/N D-9315 N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789 N12RCSkipper Thomas · Coburg, ORS/N D-9308 N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393 N135BEJeff Proctor Holding Lc · Park City, UTBuilt 1973 · S/N D-9524 N135DWWagner Dennis L · Zionsville, INBuilt 1982 · S/N D-10399 N135PGKom Aviation LLC · Southern Pines, NCS/N D10394 N135VBPriori Holdings Inc · Jacksonville, FLS/N D-10263 N137TWDixon Daniel N · Millersville, MDBuilt 1974 · S/N D-9631 N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647 N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083 N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652 N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634 N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633 N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334 N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061 N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924 N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161 N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298 N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160 N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332 N1527WRegistered aircraftBuilt 1972 · S/N D-9335 N1530WMather Aviation LLC · Rancho Cordova, CABuilt 1972 · S/N D-9338 N1548WCrabb Joseph M · Tempe, AZBuilt 1972 · S/N D-9344 N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837 N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370 N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862 N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349 N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350 N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863 N1581WBrown David C · Overland Park, KSS/N D-9352 N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353 N1589LCain James W · Big Rapids, MIS/N D-9866 N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869 N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359 N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356 N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936 N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360 N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615 N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365 N1628WT W Air LLC · Worthington, KYS/N D-9366 N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363 N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378 N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382 N1684WHaller Philip L · Peoria, AZS/N D-9386 N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388 N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391

Back to Beech V35B