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.

N558RT558rt LLC · Rocky Mount, NCBuilt 1993 · S/N TH-1691 N558WHRex Aero LLC · Wilmington, DEBuilt 1982 · S/N TH-1356 N5591ABig Dog I LLC · Wallace, MIBuilt 1989 · S/N TH-1566 N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901 N5634QLegacy Aero LLC · Jonesboro, ARBuilt 1990 · S/N TH-1598 N5636GTres Locos Gringos LLC · Lubbock, TXBuilt 1990 · S/N TH-1586 N5643CAdvance LLC · Waterville, MES/N TH-1573 N5690ZGold Aviation LLC · Greenville, SCBuilt 1990 · S/N TH-1594 N56BKoch & Koch Inc · Grass Valley, CABuilt 1994 · S/N TH-1730 N56KMBudake LLC · Macon, GABuilt 1983 · S/N TH-1391 N56TLAviation Manpower Solutions Inc · Nashville, TNBuilt 1990 · S/N TH-1597 N577WGta Air Inc · Addison, TXBuilt 1973 · S/N TH-375 N57PGulf Sierra Aviation LLC · Owasso, OKBuilt 1979 · S/N TH-1059 N580EN580e LLC · Hickory, NCBuilt 1995 · S/N TH-1758 N580JKMarshall John · Cold Spring, MNBuilt 1977 · S/N TH-792 N580WFry Michael David · Madeira Beach, FLBuilt 1976 · S/N TH-774 N581CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1183 N581ECoobac Dean P · Alpine, WYBuilt 1973 · S/N TH-423 N581GHarper Abe L Jr · Daphne, ALBuilt 1976 · S/N TH-716 N581PFFox Arrow 542 LLC · Jonesboro, ARBuilt 1993 · S/N TH-1707 N5822WKanza Aviation LLC · Andover, KSBuilt 1971 · S/N TH167 N583CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1291 N5844YLindsey Charles A · Madison, GABuilt 1980 · S/N TH-1148 N584BLSale Reported · Greeley, COSale reportedBuilt 1974 · S/N TH-446 N584CKKalitta Charters LLC · Ypsilanti, MIBuilt 1973 · S/N TH-319 N584CLKetcham Francis A · Sausalito, CAS/N TH-1034 N584DFHangar 3 LLC · Milledgeville, GABuilt 1990 · S/N TH-1605 N584DGN584dg LLC · Nashua, NHBuilt 1979 · S/N TH-1042 N584DTTiger Flight LLC · Florence, SCBuilt 1995 · S/N TH-1745 N584HPN305yv LLC · Doral, FLBuilt 1983 · S/N TH-1365 N584JTGoff James T · Sunriver, ORBuilt 1980 · S/N TH-1127 N584METwo Spinny Things LLC · Overland Park, KSBuilt 1974 · S/N TH-427 N584MJC5 Aviation LLC · Harrison, ARBuilt 1987 · S/N TH-1512 N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615 N584RCrooked Creek Enterprises LLC · Nacogdoches, TXBuilt 1985 · S/N TH-1464 N584SMRegistered aircraftBuilt 1973 · S/N TH-412 N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699 N585CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1299 N585RJMr Aeronautics LLC · Clarksville, TNBuilt 1985 · S/N TH-1479 N586CKKalitta Charters LLC · Ypsilanti, MIS/N TH-1084 N587ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH1530 N587CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1189 N588CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N TH-965 N588PAirstar LLC · Lees Summit, MOBuilt 1994 · S/N TH-1725 N588TBac LLC · Aliceville, ALBuilt 1977 · S/N TH-791 N589PUniversity Of Central Missouri · Warrensburg, MOBuilt 1989 · S/N TH-1559 N589YDennis Aviation LLC · Bartlett, TNBuilt 1977 · S/N TH-852 N58ARAnnis Aviation LLC · Gray, GABuilt 1987 · S/N TH-1525 N58BSJordan Corporation · Jackson, MIS/N TH-1142 N58BYFry Shawn Trustee · Baxter, TNBuilt 1970 · S/N TH-25

Back to Beech 58