Skip to content

Registered aircraft · 79

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 ('1152746')
  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 ('1152746')
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.

N100DRWolfe Stephen Charles · Tulsa, OKBuilt 1976 · S/N TK-2 N100HPHinds Community College · Raymond, MSBuilt 1980 · S/N TK-116 N105RKEwing John M · Cumming, GABuilt 1979 · S/N TK-104 N110CWMile High 1 LLC · Lakeway, TXBuilt 1980 · S/N TK-115 N115WEPhilips Robert Jay · Midlothian, TXBuilt 1976 · S/N TK-15 N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41 N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126 N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102 N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56 N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68 N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95 N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58 N18433J4 Aviation LLC · Lexington Park, MDBuilt 1977 · S/N TK23 N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145 N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14 N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13 N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16 N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44 N200RTRiley Nolan C · Lubbock, TXS/N TK-101 N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80 N201DRegistered aircraftS/N TK-24 N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85 N2058KCollins Jimmy · Spring, TXBuilt 1979 · S/N TK-66 N2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74 N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76 N2082LChronicle Aerospace Inc · Wilmington, DEBuilt 1976 · S/N TK-20 N2130LTds Property Holdings LLC · Gilmer, TXBuilt 1976 · S/N TK-25 N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77 N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31 N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78 N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91 N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69 N283DFrohbieter Alan · Superior, COBuilt 1979 · S/N TK-112 N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37 N311CHWings Of Eaglz LLC · Lamoni, IAS/N TK-149 N319CAAcree James · Euless, TXS/N TK93 N34549Octans Aviation Co · Watertown, SDS/N TK-62 N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124 N3705JAzuma Company · Salinas, CABuilt 1980 · S/N TK-132 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N3843SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TK-139 N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52 N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75 N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35 N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113 N4510MRcl Farms Leasing LLC · Bronwood, GAS/N TK-70 N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79 N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67 N55KJHope For Bethesda · Orange Park, FLBuilt 1977 · S/N TK-40 N584MBCenterline Holdings Inc · Camden, DES/N TK-151

Back to Beech 58TC