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.

N78WWPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N TH-1747 N7958DNewcomb Clint M · Benton, ARS/N TH-1019 N7DHBrown Michael D · Bloomington, INBuilt 1970 · S/N TH-118 N7DMNix Terry W · Golden, MSBuilt 1972 · S/N TH-214 N7MWSeven Aces LLC · Chesterfield, NJBuilt 1982 · S/N TH-1353 N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599 N801TMajestic Enterprises Ltd · Wilmington, DEBuilt 1973 · S/N TH-330 N8051UChandler Christian J · Ashfield, MABuilt 1990 · S/N TH-1607 N807THSan Mateo Real Estate Inc · San Mateo, CABuilt 1977 · S/N TH-807 N80BGBatesville Aircraft LLC · Batesville, ARBuilt 1980 · S/N TH-1174 N810DTWiley Aviation LLC · Kalispell, MTBuilt 1994 · S/N TH-1738 N8111MDcf30 Corp · Doral, FLBuilt 1991 · S/N TH-1617 N811CWJ & H Aviation LLC · Lumpkin, GABuilt 1982 · S/N TH-1351 N811PBMathis Timber LLC · Corinth, MSBuilt 1972 · S/N TH-194 N811TBM Goss LLC · Vidalia, GABuilt 1990 · S/N TH-1576 N8123NReplica Sales & Engineering Inc · Muscatine, IABuilt 1992 · S/N TH-1671 N8124LEliza Air Inc · New Orleans, LABuilt 1991 · S/N TH-1623 N812JCLfgsgb LLC · Greenville, SCBuilt 1992 · S/N TH-1676 N8151REnterprise Aviation Holdings LLC · Wilmington, DEBuilt 1974 · S/N TH-510 N8172RDerby City Aviation LLC · Vero Beach, FLBuilt 1974 · S/N TH-515 N81CLGlassman Aaron · Virginia Beach, VABuilt 1981 · S/N TH-1296 N81DDJdj Transport LLC · Wilmington, DEBuilt 1980 · S/N TH-1212 N81DRCommonwealth Aviation Service Inc DBA · Richmond, VABuilt 1978 · S/N TH-971 N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600 N81TEMichaud Nathan M · Willows, CABuilt 1980 · S/N TH-1195 N81UCRegistration Pending · Orchard Park, NYRegistration pendingBuilt 1971 · S/N TH-142 N823RDJojabella LLC · Jonesboro, ARBuilt 1995 · S/N TH-1741 N8248BSmith Kirk A · Searcy, ARBuilt 1991 · S/N TH-1633 N8257HS And G Ventures LLC · Wilmington, DEBuilt 1992 · S/N TH-1650 N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601 N8278TRegistered aircraftBuilt 1992 · S/N TH-1672 N827EBEbor Management Inc · Alpharetta, GABuilt 1970 · S/N TH-135 N827TSCurless Harley · Havana, ILBuilt 1977 · S/N TH-836 N828TTLoud LLC · Carthage, NCBuilt 1994 · S/N TH-1729 N8290ULets Fly LLC · Fortson, GABuilt 1993 · S/N TH-1688 N82LBLakeland Aircraft Maintenance LLC · Lakeland, FLBuilt 1978 · S/N TH-910 N82UCMajesty Air Inc · Wilmington, DEBuilt 1972 · S/N TH-276 N830CCCreson John L Jr · Augusta, GABuilt 1970 · S/N TH-31 N83AVEllis Andrew N · Cocoa Beach, FLBuilt 1983 · S/N TH-1385 N8564RAnderson Hans C · Leavenworth, WABuilt 1974 · S/N TH-534 N8568RDavenport Gregory · Edmond, OKBuilt 1974 · S/N TH-525 N858LPFulps Aviation LLC · Winston Salem, NCBuilt 1978 · S/N TH-902 N858NCIal Corp · Lewes, DEBuilt 1977 · S/N TH-813 N858PBEast Ky Mobile Movers Inc · Pikeville, KYS/N TH-1541 N858PRMelbourne Air Partners LLC · Indialantic, FLBuilt 1981 · S/N TH-1221 N85FS7353r Co Partnership · Pottstown, PABuilt 1974 · S/N TH-486 N869KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1993 · S/N TH-1692 N871ANWnd Aircraft Management LLC · Miami, FLBuilt 1993 · S/N TH-1678 N872WHTheologos Charles · Waveland, MSBuilt 1993 · S/N TH-1679 N873WHG & A Viation LLC · Miller, MOBuilt 1993 · S/N TH-1680

Back to Beech 58