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.

N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332 N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239 N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875 N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877 N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341 N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894 N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754 N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N1MFNvision LLC · Frisco, TXS/N TH-835 N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731 N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957 N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950 N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012 N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976 N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974 N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964 N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966 N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983 N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994 N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516 N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286 N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002 N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004 N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753 N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677 N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626 N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067 N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761 N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759 N212CHFlycarolina Ll · Concord, NCBuilt 1980 · S/N TH-1165 N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604 N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778 N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160 N2150LB-58 Inc · Albany, GAS/N TH-781 N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536 N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980 N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848 N222RBM & B Llp · Iowa City, IABuilt 1990 · S/N TH-1592 N222RGVaerus Jet Sales LLC · Topeka, KSBuilt 1994 · S/N TH-1698 N222RZP & M Reis Trucking Inc · Nantucket, MABuilt 1977 · S/N TH-857 N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447 N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64 N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771 N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344 N229TARemes Stephen · Northfield, MNBuilt 1978 · S/N TH-887 N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696 N233CTHoneycutt Danny · Angier, NCBuilt 1984 · S/N TH-1433

Back to Beech 58