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.

N1557W557 Whiskey LLC · Superior, WIBuilt 1972 · S/N TH-229 N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717 N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6 N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549 N1566WPsl Aviation Inc · Atlanta, GABuilt 1994 · S/N TH-1713 N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567 N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542 N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715 N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639 N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592 N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045 N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540 N158BJPerfectus Inc · Wilmington, DES/N TH-324 N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244 N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178 N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444 N158PA2 Laikas LLC · Helena, MTBuilt 1978 · S/N TJ-141 N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941 N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543 N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826 N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359 N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242 N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245 N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251 N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258 N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606 N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999 N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501 N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73 N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810 N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827 N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832 N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840 N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372 N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263 N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266 N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270 N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271 N1827LCone James R Jr · Lubbock, TXS/N TH-741 N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844 N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282 N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849 N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855 N18358Life Is A Beech LLC · Los Lunas, NMBuilt 1977 · S/N TH-814 N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290 N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854 N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856 N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879 N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329 N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345

Back to Beech 58