Skip to content

Registered aircraft · 726

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

N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889 N235SMTriniair LLC · Warner Robins, GAS/N TH-926 N23PVLake Dana · Boxford, MABuilt 1987 · S/N TH-1513 N242RCCarrera Aviation LLC · Wilmington, DEBuilt 1972 · S/N TH-248 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301 N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390 N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892 N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740 N258MTK5 Aviation LLC · Lewes, DES/N TH-244 N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899 N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737 N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539 N269RAFuller Aire Inc · Wilmington, DEBuilt 1978 · S/N TH-998 N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406 N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376 N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105 N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228 N27MTFlying Dog Aviation LLC · Swanton, OHBuilt 1980 · S/N TH1120 N27PKOgary Aviation LLC · North Little Rock, ARBuilt 1993 · S/N TH-1687 N281ARKing Scott · Knoxville, TNBuilt 1978 · S/N TH-991 N283MAAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1975 · S/N TH-669 N2844DMichigan Aeronautics Commission · Lansing, MIBuilt 1994 · S/N TH-1726 N2852WButcher Charles · Germantown, TNBuilt 1973 · S/N TH-349 N285HABlacqjacq Aviation Co · Wilmington, DEBuilt 1975 · S/N TH623 N2871WBuess Wayne R · Shirley, NYBuilt 1974 · S/N TH-462 N288PBlue Water Aviation Inc · Jupiter, FLBuilt 1980 · S/N TH-1113 N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535 N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172 N29CPClifford Robert J · Dania Beach, FLBuilt 1970 · S/N TH-33 N29CSKntj Properties 1 LLC · Wildwood, MOBuilt 1989 · S/N TH-1558 N29DAJones David W · Carlisle, PABuilt 1975 · S/N TH-645 N2YCTaglavore Franklin · Irving, TXBuilt 1974 · S/N TH-487 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166 N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890 N3044W625 Mike Tango LLC · Dickinson, TXBuilt 1973 · S/N TH-344 N305WP3192 Golf Inc · Wauchula, FLBuilt 1984 · S/N TH-1426 N3066BAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1987 · S/N TH-1514 N30771Dodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N TH-1518 N3077ZBravo Air LLC · Troy, MIBuilt 1987 · S/N TH-1516 N30787Jetsons Holdings LLC · Birmingham, ALBuilt 1987 · S/N TH-1521 N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74 N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534 N3118HAtlantic Aviation Group Inc · Miami, FLBuilt 1994 · S/N TH-1718 N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410 N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722 N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411 N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204

Back to Beech 58