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.

N3174BRegistration Pending · Lago Vista, TXRegistration pendingBuilt 1994 · S/N TH-1724 N3178AMarine Aviation LLC · New Bedford, MABuilt 1970 · S/N TH-3 N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428 N3194XAutry Mark T · Sumter, SCBuilt 1994 · S/N TH-1723 N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735 N320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426 N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571 N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488 N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667 N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746 N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748 N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292 N3260FGilbert Aviation Inc · Wilmington, DEBuilt 1995 · S/N TH-1760 N3270JBerry Matthew G · Creedmoor, NCBuilt 1996 · S/N TH-1770 N3281KWallace Architects LLC · Columbia, MOBuilt 1979 · S/N TH-1006 N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869 N3330MMaine Instrument Flight · Augusta, MEBuilt 1979 · S/N TH-1031 N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779 N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739 N33SFRoseville Aviation LLC · Roxboro, NCBuilt 1972 · S/N TH-190 N344RCHome Perfection General Contractors Inc · Pelham, ALBuilt 1984 · S/N TH-1412 N344SRegistered aircraftBuilt 1972 · S/N TH-210 N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943 N3509W92nd West Aviation Inc · Lonoke, ARS/N TH-350 N358CMEathcirc 08 LLC · Tucson, AZBuilt 1989 · S/N TH-1546 N358YJuliet Air LLC · Cincinnati, OHS/N TH-1551 N359PTilloo Aviation LLC · Pensacola, FLS/N TH-1229 N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479 N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653 N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143 N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150 N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149 N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151 N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157 N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159 N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145 N3694LRegistered aircraftBuilt 1980 · S/N TH-1176 N3695NWalton Jerry Prince Jr · Monticello, FLBuilt 1980 · S/N TH-1192 N36AVCook Greg R · Willis, TXBuilt 1992 · S/N TH-1657 N36CTExecutive Mission LLC · Round Rock, TXBuilt 1990 · S/N TH-1579 N3701DN3701d LLC · Wilmington, NCBuilt 1980 · S/N TH-1187 N3707TFisher Kurt A · San Luis Obispo, CABuilt 1970 · S/N TH-110 N3711YAero Venture Lc · Shreveport, LABuilt 1977 · S/N TH-828 N3715BBombers And Barons LLC · Haughton, LABuilt 1980 · S/N TH-1200 N3739BClipper Air LLC · Cresson, TXBuilt 1980 · S/N TH-1198 N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208 N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381 N3806XTessec LLC · Cincinnati, OHBuilt 1980 · S/N TH-1215 N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218 N3809KGeneral Aviation Services LLC · Franklin, TNBuilt 1981 · S/N TH-1219

Back to Beech 58