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.

N874WHRed Oak Aviation LLC · Sunset, LABuilt 1993 · S/N TH-1681 N875DBDbco LLC · Greenwood Village, COBuilt 1980 · S/N TH-1135 N877CAHausman Benjamin · Merritt Island, FLBuilt 1994 · S/N TH-1727 N878BBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N TH-1710 N878CAKag Aviation LLC · Mc Carley, MSBuilt 1994 · S/N TH-1728 N87CA200 Knots LLC · Dover, DEBuilt 1983 · S/N TH-1382 N87MJBerdan Curtis A · Sterling Heights, MIBuilt 1972 · S/N TH-259 N87SM10269 Flight LLC · Bainbridge Island, WABuilt 1990 · S/N TH-1587 N882MTGta Air Inc · Addison, TXBuilt 1982 · S/N TH1343 N887ACBrg Enterprises LLC · Johns Island, SCS/N TH-603 N89GPanousis Steve · Kennett, MOBuilt 1975 · S/N TH-616 N8DPDelta Papa Aviation LLC · Wilmington, DES/N TH-1038 N8NGRetail Contracting Group Inc · Oakdale, MNBuilt 1969 · S/N TH-19 N9001QSaransor Properties LLC · Eden Prairie, MNBuilt 1970 · S/N TH-57 N900KBN900kb LLC · California, MDBuilt 1977 · S/N TH-863 N900NXAlva Family Holdings LLC · Fort Denaud, FLBuilt 1976 · S/N TH-723 N9021V9021 LLC · Sheridan, WYS/N TH-233 N9023QRegistered aircraftBuilt 1970 · S/N TH-68 N9044VThomas Richard D · Orange City, FLBuilt 1972 · S/N TH-216 N9058QHeffley Lynn · Pottsboro, TXBuilt 1970 · S/N TH-95 N9094QAhrens Nathan · Groveland, CABuilt 1970 · S/N TH-107 N9098QBuckeye Baron LLC · Sunbury, OHBuilt 1970 · S/N TH-109 N90EBJet Set Aircraft Inc · Van Nuys, CABuilt 1976 · S/N TH-793 N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646 N9134SDaytona Aircraft Services Inc · Daytona Beach, FLS/N TH-726 N917MPPool Shark Equipment LLC · Memphis, TNBuilt 1981 · S/N TH-1243 N917TRTry Trying Management And Promotions LLC · Indianapolis, INS/N TH-133 N9195QMeadowlake Airpark LLC · Lenoir City, TNBuilt 1971 · S/N TH-152 N91JRSpring Mountain Properties LLC · Fort Smith, ARBuilt 1973 · S/N TH-313 N91WMN2sb LLC · Southlake, TXBuilt 1983 · S/N TH-1396 N920GCSabre Drilling Consulting LLC · Summerfield, NCBuilt 1992 · S/N TH-1660 N922HBPovero Marcus E · Fort Worth, TXBuilt 1977 · S/N TH-825 N9239QRegistration Pending · Bessemer, ALRegistration pendingBuilt 1971 · S/N TH-139 N928HBRegistration Pending · New Brunswick, NJRegistration pendingS/N TH-172 N929D929 Delta LLC · Dublin, VABuilt 1985 · S/N TH-1453 N92FFAircraft 2 Go ! Inc · Wilmington, DES/N TH-1167 N92HJWoolley Air LLC · Kilgore, TXBuilt 1991 · S/N TH-1621 N92TTKent Oscar Kevin · Lucas, IABuilt 1972 · S/N TH-226 N930BDMomentum Air LLC · Brighton, MIBuilt 1973 · S/N TH-307 N9310QMc Types II LLC · Jacksonville, FLBuilt 1971 · S/N TH-180 N9326QLoyd Tracy · Broken Arrow, OKBuilt 1971 · S/N TH-186 N9385QOxer James E · Lake Placid, FLBuilt 1970 · S/N TH-49 N9403QBlue Sky Baron LLC · Highlands Ranch, COBuilt 1970 · S/N TH-54 N9411QWhite Tavis · Huntsville, ALBuilt 1970 · S/N TH-66 N9429QBuck Hollow Investments LLC · Austin, TXBuilt 1972 · S/N TH-200 N9446QGalt Gulch LLC · Ann Arbor, MIBuilt 1972 · S/N TH-236 N9466QLan Dale Co · Reno, NVBuilt 1972 · S/N TH-205 N9467QAg Aero Inc · Tallulah, LABuilt 1972 · S/N TH-206 N946TTTalley Tank Lines Inc · Madera, CABuilt 1992 · S/N TH-1673 N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816

Back to Beech 58