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.

N58CHChase Brandon C · Plains, KSBuilt 1978 · S/N TH-949 N58CKMajestic Fleet LLC · Miami, FLBuilt 1974 · S/N TH-567 N58DAUniversity Of Central Missouri · Warrensburg, MOBuilt 1984 · S/N TH1402 N58DCDream Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1206 N58DLHam John T · Murfreesboro, TNBuilt 1975 · S/N TH-692 N58ELN1107u LLC · Lewisville, NCBuilt 1979 · S/N TH-1003 N58EVLittle Tree Aeromotive LLC · Banner Elk, NCBuilt 1976 · S/N TH-704 N58GELje Air LLC · Park Ridge, ILBuilt 1985 · S/N TH-1480 N58GKMvm LLC · Lewes, DEBuilt 1976 · S/N TH-763 N58HCMedina Sky LLC · Medina, OHBuilt 1975 · S/N TH-637 N58JZAcv Group LLC · Mckinleyville, CABuilt 1976 · S/N TH-710 N58KERacego Corp · San Juan, PRBuilt 1978 · S/N TH-921 N58LDHenderson Leon Jr · Ellisville, MSBuilt 1985 · S/N TH-1472 N58LFAckley Ray · Charlotte, NCBuilt 1972 · S/N TH-237 N58MFTurk Mike F · Pinehurst, TXBuilt 1972 · S/N TH-279 N58MHA Pro LLC · Hernando, MSBuilt 1995 · S/N TH-1752 N58PBDirect Flight LLC · Kitty Hawk, NCBuilt 1983 · S/N TH-1379 N58PFVeilleux Jean-Christophe · Escondido, CAS/N TH-888 N58PWPapa Leasing LLC · Helena, MTBuilt 1974 · S/N TH-459 N58QPHk Ventures LLC · Paynesville, MNBuilt 1990 · S/N TH-1612 N58RHHubbard Robert R Dds · Harrison, ARBuilt 1973 · S/N TH-362 N58SLHome Air Inc · Gainesville, GABuilt 1980 · S/N TH-1121 N58TPDiamond Aircraft Corporation · Miami, FLBuilt 1977 · S/N TH-843 N58TWHouck Christopher · Cary, NCBuilt 1973 · S/N TH-369 N58UATunica Air Inc · Tunica, MSBuilt 1980 · S/N TH-1194 N58WFHohlrieder Automotive Co · Yorktown, VABuilt 1977 · S/N TH-831 N58WGN58wg LLC · Shreveport, LABuilt 1972 · S/N TH-208 N593RAMakonnen Iyob · Atlanta, GABuilt 1981 · S/N TH-1307 N59HMBaron International Ventures LLC · West Palm Beach, FLBuilt 1975 · S/N TH-635 N5ALSchapansky Justin · Mount Airy, GABuilt 1973 · S/N TH-356 N5BZBad Bird LLC · Elon, NCBuilt 1975 · S/N TH-662 N600BBGat Air & Ground LLC · Norwich, NYBuilt 1981 · S/N TH-1236 N6037MRaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N TH-1022 N6037PRegistered aircraftN-number assigned, not yet registeredS/N TH-1023 N6038WDidden Gary E · La Crescenta, CABuilt 1979 · S/N TH-1025 N6040RSixtyforty LLC · Mequon, WIBuilt 1979 · S/N TH-1026 N6058AAlpha Air LLC · Sparks, NVBuilt 1979 · S/N TH-1017 N6078SWhisero Aero Inc · Tullahoma, TNBuilt 1975 · S/N TH-625 N6096SMortensen Daniel R Trustee · Newhall, CABuilt 1975 · S/N TH-699 N612MAAndraos Aviation Solutions LLC · Northville, MIBuilt 1979 · S/N TH-975 N612TNClear Spot Inc · New Smyma Beach, FLBuilt 1981 · S/N TH-1272 N617PTSmart Motion Aviation LLC · Frisco, TXBuilt 1979 · S/N TH-1043 N6188MDanze Alex · Riverside, CABuilt 1982 · S/N TH-1318 N61PZRoughneck Supply LLC · Muskogee, OKBuilt 1982 · S/N TH-1352 N620ZSix Twenty Zulu Aviation LLC · Wilmington, DEBuilt 1973 · S/N TH-385 N621NMAirmorgan Limited LLC · Reno, NVBuilt 1974 · S/N TH-422 N624TELenbob Aviation LLC · Southaven, MSS/N TH-1588 N625HWBsw Acceptance Inc · Muleshoe, TXBuilt 1993 · S/N TH-1694 N625MOverbeek Michael F · Holland, MIBuilt 1974 · S/N TH-434 N6271RAir Jag LLC · Garden City, KSBuilt 1982 · S/N TH-1331

Back to Beech 58