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.

N100JPAviation Consulting LLC · Ada, MIS/N TH-1683 N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249 N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554 N103LHKavalair LLC Series D · Marion, MTBuilt 1980 · S/N TH-1170 N1054WHeavers George S · Oakland, CABuilt 1973 · S/N TH-312 N1061FFoxtrot Flight LLC · Clarksdale, MSS/N TH-1761 N1064CBayside Development LLC · Bellingham, WAS/N TH-1764 N1065BRegistered aircraftS/N TH-1765 N1066HBaronhfl LLC · Jacksonville, FLS/N TH-1766 N106GATactical Safety Training LLC · Dublin, GAS/N TH-437 N1073SAlabama Department Of Transportation · Montgomery, ALBuilt 1996 · S/N TH-1773 N1075XFisher Creek Corp · Grove Hill, ALBuilt 1996 · S/N TH-1775 N1078SRegistered aircraftBuilt 1996 · S/N TH-1778 N1083WAeolus Aircraft LLC · Seminole, OKS/N TH-323 N111ALBc Builders Inc · Temecula, CAS/N TH484 N111AWC&A Aviation LLC · Mcintyre, GABuilt 1977 · S/N TH-841 N111XXBay Area Flying Service LLC · Burlingame, CABuilt 1983 · S/N TH-1389 N112PCTaylor Bradley S · Abilene, TXBuilt 1976 · S/N TH-720 N113LSOwnship Aviation Solutions LLC · Huntsville, ALBuilt 1987 · S/N TH1531 N114PCHeller Andrew R · Austin, TXBuilt 1975 · S/N TH-661 N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604 N118CFChaudoin Stephen G Trustee · Raymond, NHBuilt 1978 · S/N TH-924 N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506 N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188 N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533 N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128 N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748 N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416 N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335 N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937 N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923 N125BEGomez Eliud · Winter Park, FLS/N TH-43 N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868 N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816 N137JPRitec LLC · Sandown, NHBuilt 1982 · S/N TH-1322 N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678 N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468 N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155 N142DRHj & L Air LLC · Sacramento, CABuilt 1985 · S/N TH-1458 N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693 N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439 N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154 N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562 N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758 N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217 N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218 N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711 N1545WM T Air LLC · Olive Branch, MSBuilt 1989 · S/N TH-1545

Back to Beech 58