OpenAirDocs.org
AD 93-24-15

Registered aircraft · 8,460

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:93-24-15')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-24-15')
  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.

N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056N1014MWeisinger Jason Aaron · Kyle, TXBuilt 1969 · S/N 15070994N1015MEppenbrock Elena C · Fort Worth, TXS/N 15070995N1016JRoberts Nettie R · Bowling Green, KYBuilt 1968 · S/N 15068595N101DPStancy Marc A · Crystal Lake, ILBuilt 1967 · S/N 15067860N1021MMcconnell Frank V Jr · Woodstock, GABuilt 1969 · S/N 15070991N102LAIowa Lakes Community College · Estherville, IAS/N 17259038N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221N106WSMarriott Ed · Manhattan Beach, CAS/N R172-0107N107PSLadies In Aviation LLC · Mocksville, NCBuilt 1965 · S/N 17253618N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306N1102FGrant County State Bank · Carson, NDBuilt 1966 · S/N 17254697N1104FMiller Jonathan A · Apo, APBuilt 1966 · S/N 17254699N1105FGibbard Donald R · Walla Walla, WABuilt 1966 · S/N 17254700N1107FMedic Choppers LLC · Springdale, ARS/N 17254702N1108FAom Aircraft LLC · Wilmington, DES/N 17254703N1110FSallade William L · Coudersport, PABuilt 1966 · S/N 17254705N1114FRegistration Pending · Florence, SCRegistration pendingBuilt 1966 · S/N 17254709N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846N1117THimes Austin M · Wentworth, MOBuilt 1965 · S/N 17252759N111HSMacav Flight Training LLC · Abilene, TXBuilt 1965 · S/N 17253989N111TBNeswest Inc · Los Angeles, CABuilt 1968 · S/N 15069477N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828N111WLCj Aero LLC · Fort Valley, VABuilt 1973 · S/N 18052407N1120DCompher Charles D · Berryville, VABuilt 1966 · S/N 17254131N1120FHaidle Wayne M · Bismarck, NDBuilt 1966 · S/N 17254715N1122FDollosso Frank G · Lakeport, CABuilt 1966 · S/N 17254717N1125FAeropark LLC · Michigan City, INBuilt 1966 · S/N 17254720N1127FPricemeyer Aviation LLC · St Pete Beach, FLS/N 17254722N1128FLockridge James · Adairsville, GAS/N 17254723N1129FKoch Bradley D · Billings, MTBuilt 1966 · S/N 17254724N1129MTechair LLC · Playa Vista, CAS/N 17252240N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387N112SSOlsen John · Wasilla, AKS/N 18052510N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729N1137FSale Reported · New Hudson, MISale reported, canceledBuilt 1966 · S/N 17254732
Back to AD 93-24-15