Skip to content

Registered aircraft · 978

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

N321DBDc Aviation Maintenance Inc · Bryant, ARBuilt 1978 · S/N CE-797 N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173 N326KB4 Wingmen LLC · Sandy, UTBuilt 1973 · S/N CE-422 N327ESeager Carl E · Greensboro, NCBuilt 1977 · S/N CE-733 N329CBullard Aviation Services Inc · Ormond Beach, FLBuilt 1973 · S/N CE-444 N32NBSteele Kathleen N · Scottsdale, AZBuilt 1990 · S/N CE-1514 N330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALBuilt 1992 · S/N CE-1707 N330WH2k Partners LLC · Dallas, TXBuilt 1989 · S/N CE-1322 N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651 N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691 N332HPDolan Charles A · Augusta, GABuilt 1990 · S/N CE1508 N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553 N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692 N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860 N3344MSmith Andrew L · Hillsboro, TXBuilt 1993 · S/N CE-1731 N3349ADoherty David R · Thief River Falls, MNBuilt 1970 · S/N CE-306 N334DBrady Michael H Trustee · Healdton, OKBuilt 1993 · S/N CE-1756 N334HPN334hp LLC · Sheridan, WYBuilt 1974 · S/N CE-519 N334JDGolden Bear Properties LLC · Lakeside, AZBuilt 1993 · S/N CE-1718 N334KWRoberts Dorel Lynn · Sheridan, WYS/N CE-523 N334MBSutherland Scott G · Longmont, COBuilt 1982 · S/N CE-1012 N334PBConway Brian · Denver, COBuilt 1990 · S/N CE-1543 N334PCMagic Valley Auction LLC · Jerome, IDBuilt 1990 · S/N CE-1534 N334PWGary Bass Restorations LLC · Monett, MOBuilt 1974 · S/N CE-488 N334RN566rw LLC · Hensley, ARBuilt 1991 · S/N CE-1561 N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837 N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111 N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499 N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685 N335HPOlympus Leasing LLC · Bremerton, WABuilt 1992 · S/N CE1663 N335TBJkh Enterprises LLC · Westfield, INBuilt 1987 · S/N CE1166 N3364BDilley Darrel L · La Salle, COBuilt 1977 · S/N CE-734 N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312 N3389MRoberts Roger W Trustee · Wichita, KSBuilt 1989 · S/N CE-1412 N338HPN338hp LLC · Omaha, NEBuilt 1993 · S/N CE-1724 N338MGEjdeha LLC · Boston, MABuilt 1989 · S/N CE-1325 N33ANeo Terra Aviation LLC · Setauket, NYBuilt 1988 · S/N CE-1222 N33CVMaintain Aviation LLC · Pomona, MOBuilt 1992 · S/N CE-1678 N33EJReinke Bradley H · Pascagoula, MSBuilt 1993 · S/N CE-1721 N33GKDugger Glenn · Denton, TXBuilt 1990 · S/N CE-1468 N33JSBroughton Corp · Newtown Square, PABuilt 1976 · S/N CE664 N33KSMeggers Roger D · Baker, MTBuilt 1987 · S/N CE-1142 N33MKFessele Martin · Bridgewater, NJBuilt 1990 · S/N CE1478 N33MUKteg LLC · Bridgeport, TXBuilt 1993 · S/N CE-1742 N33MY3 Wings LLC · Highland, MIBuilt 1987 · S/N CE-1160 N33RMTrivisonno Dominick P · Skaneateles, NYBuilt 1978 · S/N CE-776 N33TDLightning 35 Aviation LLC · Wilmington, DEBuilt 1973 · S/N CE-415 N33TNThree Six Bonita LLC · Georgetown, TXBuilt 1990 · S/N CE-1487 N33UBStubbs Thomas A · Knoxville, TNBuilt 1990 · S/N CE-1496 N33YMDiedrich William Walter · Firebaugh, CABuilt 1979 · S/N CE-840

Back to Beech F33A