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.

N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395 N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251 N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255 N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256 N38CEBrad Keener Dds Pa · Harrison, ARBuilt 1971 · S/N TH-116 N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577 N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642 N39HLCoastal Mobility LLC · Wilmington, NCBuilt 1985 · S/N TH-1500 N3PEJabr Aviation LLC · Milford, IABuilt 1977 · S/N TH-820 N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138 N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641 N403PAFergany Amr Farouk · Sebastian, FLBuilt 1980 · S/N TH-1182 N406PASale Reported · Rantoul, KSSale reported, canceledBuilt 1982 · S/N TH-1338 N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593 N40JBElk River Aero LLC · Noel, MOS/N TH-338 N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166 N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605 N4115SDanielson Adam M · Chassell, MIS/N TH-644 N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464 N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612 N414SWRmi Air LLC · Ocilla, GABuilt 1977 · S/N TH-797 N415LWWest Thomas Lee · Payson, AZBuilt 1984 · S/N TH-1417 N416DMcginnis Aviation LLC · Kentwood, MIBuilt 1974 · S/N TH-500 N416JSC Randy Landis Dds Inc · Oroville, CABuilt 1973 · S/N TH-416 N4178SGlad Aviation LLC · Gilford, NHBuilt 1975 · S/N TH-652 N4188SMajor Air LLC · Charleston, SCBuilt 1975 · S/N TH-620 N418RWPower Aero Inc · Scituate, RIBuilt 1978 · S/N TH-917 N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471 N41LM92 Aviation LLC · Whiteville, NCS/N TH-967 N4203ABas Part Sales LLC · Greeley, COBuilt 1970 · S/N TH-22 N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394 N424QLj Sutter Aviation LLC · Shavertown, PABuilt 1990 · S/N TH-1582 N426DDRare Air Aviation Services LLC · Santa Rosa, CABuilt 1970 · S/N TH-93 N42FQSp Aviation Group LLC · Weston, FLBuilt 1984 · S/N TH-1406 N430RTTortorigi Aviation LLC · Birmingham, ALBuilt 1984 · S/N TH-1411 N432DLWhitecotton William W · Eldersburg, MDBuilt 1974 · S/N TH-561 N4331WRicca Gregory F Trustee · Bentonville, ARBuilt 1974 · S/N TH-436 N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953 N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489 N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448 N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460 N43HPBarbara Aviation Inc · Middletown, DEBuilt 1977 · S/N TH-885 N440BLL R Aviation LLC · Plymouth, NCBuilt 1977 · S/N TH-801 N4449WJameson Clarke Enterprises LLC · Houston, TXBuilt 1974 · S/N TH-451 N4474WR And S Aviation LLC · Corning, ARBuilt 1974 · S/N TH-431 N4492JJohnson Richard E · Waynesboro, MSBuilt 1980 · S/N TH-1199 N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670 N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298 N451SBModleski Matthew · Noblesville, INBuilt 1978 · S/N TH-897

Back to Beech 58