AD 2003-24-13

Registered aircraft · 7,870

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

N60155Jls Aviation LLC · Sarasota, FLBuilt 2006 · S/N 172S10167N60166Gabriel/Jordan Holdings Gp Inc · Henderson, TXBuilt 2006 · S/N T18208543N6016BTnj Adventures LLC · Kalispell, MTBuilt 2006 · S/N T18208539N6016VTiseo Paul J · Chester, CTBuilt 2006 · S/N T18208541N6017LAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10170N6017NGood Dog Leasing LLC · Vienna, VABuilt 2006 · S/N 172S10171N6018KChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10174N6018ZWarner Aviation Co · Council Bluffs, IABuilt 2006 · S/N 172S10175N6019VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10177N6019XRuegg Charles E · Belfast, MEBuilt 2006 · S/N 18281812N601LSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12853N6020F7l Air LLC · Franklin, TXBuilt 2006 · S/N 18281814N6020KDuont LLC · Portola Valley, CABuilt 2004 · S/N T18208236N6020ZTisdale Enterprises LLC · Pensacola, FLS/N T18208545N6021FB R S Leasing Inc · Wilmington, DEBuilt 2006 · S/N 172S10180N6021KRegistration Pending · Grand Forks, NDRegistration pendingBuilt 2006 · S/N 172S10181N6021MPark Rapids Avionics Inc · Park Rapids, MNBuilt 2006 · S/N 18281817N6022JPavise LLC · Midland, TXBuilt 2006 · S/N T18208550N6022NStrong Brothers Aviation Inc · Leesburg, FLBuilt 2006 · S/N T18208551N6023FAviation Systems & Service LLC · Mounds, OKBuilt 2006 · S/N T20608628N6023SChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 17281337N6023VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10198N6024EDhs Operations LLC · Wilmington, DEBuilt 2006 · S/N 172S10200N6024TDouglass Bruce · Conway, MABuilt 2006 · S/N 172S10202N6025DMorgan Joel E · Mcalester, OKBuilt 2006 · S/N 18281830N6025EVictor Air LLC · Kirkland, WABuilt 2006 · S/N T18208565N6025FLeeloo Air LLC · Reno, NVBuilt 2006 · S/N T18208566N6025PThagair LLC · Reno, NVBuilt 2006 · S/N T18208567N6025ZWind River Aviators LLC · Dubois, WYBuilt 2006 · S/N T18208568N6026SPhoneix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10206N6026ZAerodynamic LLC · Aurora, ORBuilt 2006 · S/N 172S10208N60279Tensco Inc · Twin Falls, IDBuilt 2006 · S/N 18281804N6027ZSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10159N6028UDesert Sky Aviation LLC · La Quinta, CABuilt 2006 · S/N T18208538N6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 2006 · S/N 172S10173N602CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283072N602DDSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609057N602DEPpp Aviation LLC · Jasper, GABuilt 2022 · S/N T20609716N602EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12698N602NDRainer Flight Service LLC · Renton, WABuilt 2012 · S/N 172S11253N602TCSanderson Kimberly L · Swartz, LABuilt 2000 · S/N 172S8383N602TLCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10736N6031LRegistered aircraftBuilt 2006 · S/N 172S10188N6031WWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10189N6032DBravo Gulf Zulu Aviation LLC · Newark, DEBuilt 2006 · S/N 18281820N6032THard Times Wy LLC · Helena, MTBuilt 2006 · S/N T18208554N6032WKolb Jonah Allan · Underhill, VTBuilt 2006 · S/N T18208555N60337Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10192N6033BRmp Management Co Inc · Rancho Cucamonga, CABuilt 2006 · S/N T18208559N6033KAirborne LLC · Spring Hill, FLBuilt 2006 · S/N T20608631
Back to AD 2003-24-13