AD 75-16-10

Registered aircraft · 2,695

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10')
  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.

N12KSWalton Cheryl H · Indianapolis, INBuilt 1974 · S/N TE-1005N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119N12WLLauterbach Christian · Carmel, CABuilt 1975 · S/N TC-1870N1302ZPlaisier Matthew · Lafayette, TNBuilt 1961 · S/N TC-173N1305ZReynolds James Patrick · Lebanon, TNBuilt 1961 · S/N TC-119N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463N1311ZJprg Aviation Inc · Orlando, FLBuilt 1961 · S/N TC-120N13131Premier Capital Enterprises LLC · Hurricane, UTBuilt 1958 · S/N TD-42N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963N132BMds Flying LLC · Deephaven, MNBuilt 1981 · S/N TE-1189N132TWRc Flyers LLC · Wilmington, DEBuilt 1974 · S/N TC-1654N1332ZUp And Up Aviation LLC · Spring, TXBuilt 1961 · S/N TC-141N1333Beech Nut Flyers LLC · San Diego, CABuilt 1968 · S/N TC-1100N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173N1340ZLogue Andrew Douglas Trustee · Port Saint Lucie, FLBuilt 1961 · S/N TD-474N1341ZAustin Bill DBA · Sparta, TNBuilt 1961 · S/N TD-473N134CBGlobal Coin Logistics LLC · Lexington, KYBuilt 1967 · S/N TG-40N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868N1351ZErickson David R · West Point, UTS/N TC-148N1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeS/N TC-157N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816N135KAcord Aviation Co L L C · Chandler, OKBuilt 1967 · S/N TD-691N1365ZSkans David K · Henderson, NVBuilt 1961 · S/N TC-160N1366ZPfetsch Mitchell R · Daggett, CABuilt 1961 · S/N TC-166N1373ZHoitt Edward D Jr · Deerfield, NHBuilt 1961 · S/N TD-479N1377ZCoen Brady · Wiley, COBuilt 1961 · S/N TC-165N137FSmith Nathan · Citra, FLBuilt 1956 · S/N TE-32N137JPRitec LLC · Sandown, NHBuilt 1982 · S/N TH-1322N1385ZWilson Tommy V · Greenleaf, IDBuilt 1961 · S/N TD-486N138QKyff Jeffrey V · Traverse City, MIBuilt 1964 · S/N TC-612N139PTCroley John T Jr · Fitzgerald, GABuilt 1964 · S/N TC-758N139QMoles Timothy E · New Cumberland, WVBuilt 1964 · S/N TC-638N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678N13HMN13hm LLC · Punta Gorda, FLBuilt 1970 · S/N TE-813N13MKLjh Consulting Services LLC · Greenleaf, IDBuilt 1968 · S/N TE-515N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468N1403G1403g LLC · Wheat Ridge, COBuilt 1961 · S/N TC-227N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155N140WLMorning Air LLC · Indian Rocks Beach, FLBuilt 1979 · S/N TC-2231N141CLFulbright Charles M · Toccoa, GABuilt 1967 · S/N TD-692N141PCCleggs Termite And Pest Control · Morehead City, NCS/N TH-2091N1420GRamsey April Dawn · Saraland, ALBuilt 1962 · S/N TC-238N142DRHj & L Air LLC · Sacramento, CABuilt 1985 · S/N TH-1458N142FGall Peter · Morgantown, WVBuilt 1966 · S/N TE-221
Back to AD 75-16-10