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.

N951DSDerrick Schmidt Enterprises Inc · Vinita, OKBuilt 1978 · S/N TH-898 N955BRBuffalo River Aviation LLC · Bentonville, ARBuilt 1972 · S/N TH-230 N958CCSolomon Mark Trustee · Wilmington, DEBuilt 1989 · S/N TH-1565 N95KMAerial Logistics LLC Trustee · Lakeland, FLBuilt 1981 · S/N TH-1315 N95PJMoghimi Gholamali · Monroe, LABuilt 1980 · S/N TH-1162 N95PNM&B Aviation Services LLC · Wilmington, DEBuilt 1972 · S/N TH-282 N967VVolare USA Corp · Wilmington, DEBuilt 1977 · S/N TH-851 N9693ACavu LLC · Honolulu, HIBuilt 1991 · S/N TH-1627 N96BDRoberts Aircraft Inc · West Chicago, ILBuilt 1974 · S/N TH457 N96GBEagle Equity Inc · Valparaiso, INS/N TH-882 N96WEChase Aviation De LLC · Dover, DEBuilt 1996 · S/N TH-1782 N96WFBrockman Leland Jay · Horseshoe Bay, TXBuilt 1990 · S/N TH-1595 N970GCAurora Skies LLC · Fernandina Beach, FLBuilt 1981 · S/N TH-1313 N977GFBrown Bear Aircraft LLC · Hartland, MEBuilt 1972 · S/N TH-175 N97RSSchiffenhaus Robert · EspooBuilt 1984 · S/N TH-1414 N984BCRegistered aircraftBuilt 1978 · S/N TH-984 N98AABruno Anthony J III · Bryn Mawr, PABuilt 1985 · S/N TH-1461 N9955MBell Jason W · Mount Pleasant, TXBuilt 1989 · S/N TH-1575 N999AKBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N TH-1069 N999CWCrinklaw Farm Services Inc · Kingsburg, CABuilt 1973 · S/N TH-291 N99DAAuburn Aero Holdings LLC · Auburn, INBuilt 1975 · S/N TH-619 N99LFLake Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1261 N99RFEcho Bravo Aviation LLC · Nashville, TNBuilt 1974 · S/N TH-463 N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649 N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641 N99WPMarco Investments · Ripley, MSBuilt 1978 · S/N TH-958

Back to Beech 58