OpenAirDocs.org
AD 2003-24-13

Registered aircraft · 7,866

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.

N1074XKelley Air LLC · Milford, MIBuilt 2005 · S/N 20608233N10782Kearbey Brandon · Hillsboro, ORBuilt 2007 · S/N T20608773N10797Federal Flight LLC · Fairfax, VABuilt 2005 · S/N T20608525N107AFKummer Michael · Floyd'S Knobs, INBuilt 2001 · S/N 17281056N107ALAero Tech Services Inc · Lititz, PABuilt 2023 · S/N 172S12989N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202N107ELAa-Aero LLC · Lewes, DEBuilt 2024 · S/N 172S13140N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220N107TLGeier Jeffrey E · Colfax, WABuilt 2003 · S/N T18208216N107WTDld Aviation LLC · Ogden, UTBuilt 2024 · S/N T18209133N1082JWild Bills Aviation Inc · Tustin, CAS/N T20608775N1087CPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10268N10897Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10606N1089DHeavy Metal Air LLC · Farmingdale, NYBuilt 2006 · S/N 172S10269N108CTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608212N108ED95 Msg/Svra Aero Club · Edwards Afb, CABuilt 2007 · S/N 172S10631N108HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9049N108PFKeith Wilcox & Sons Inc · Rexburg, IDBuilt 1998 · S/N 18280092N108PTHenrie Aviation LLC · Fairfield, NJBuilt 2005 · S/N 172S10089N108TCAmeriflyers Of Texas Inc · Addison, TXBuilt 2001 · S/N 172S8801N108TLDomus Capital Holdings LLC · Dallas, TXBuilt 2003 · S/N T18208217N10909Bouldin Aviation LLC · Mcminnville, TNBuilt 2006 · S/N T18208628N1090JRocky Mountain Flight Consultants LLC · Boulder, COFirst renewal noticeBuilt 2006 · S/N 172S10271N1090VAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10283N1090WMedary Aviation LLC · Brookings, SDBuilt 2006 · S/N 172S10284N1092AGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10286N1092UBrakke Barak · Clear Lake, IABuilt 2006 · S/N T18208630N10936Illusion Yacht Charters Inc · Fort Pierce, FLBuilt 2006 · S/N T18208631N10965Clampitt Darrell · Gray, GABuilt 2007 · S/N 18281976N1097NSale Reported · Peoria, AZSale reportedBuilt 2005 · S/N 172S9821N1097YAtlas Aviation Tampa Inc · Tampa, FLBuilt 2006 · S/N 172S10296N109CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609748N109CQWatkins Eric Brian · San Diego, CABuilt 2016 · S/N 18282462N109CRBabcock Jimmie J Jr · Bowling Green, KYBuilt 2006 · S/N T18208553N109DLBoon Aviation LLC · Spring Lake, MIBuilt 2006 · S/N T18208636N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985N10AVMaak Holdings LLC · Missoula, MTBuilt 1999 · S/N 18280129N10CXAlameda County Sheriffs Office · Livermore, CAS/N 20608082N10HPAviation Systems And Service LLC · Mounds, OKBuilt 2004 · S/N 18281428N10YRAj Aviation LLC · Colby, KSBuilt 1999 · S/N T2068011N11019Cc Ventures LLC · Bowling Green, KYBuilt 2006 · S/N 172S10300N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913N1103HSlezak David · Davison, MIBuilt 2006 · S/N T18208637N1104XFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10297N1105XGay Faith E · Johnstown, NYS/N 18281980N1107GLunken Flight Training Center LLC · Cincinnati, OHBuilt 2006 · S/N 172S10303N1108PRay Lee LLC · Cody, WYBuilt 2006 · S/N T18208639N110GCAltitude Ventures LLC · Lexington, NCBuilt 2019 · S/N 18283062N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326
Back to AD 2003-24-13