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.

N5132RChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9001N5133KAa-Aero Inc · Fairfield, NJBuilt 2001 · S/N 172S9002N5134BSalinas Four LLC · Salinas, CABuilt 2001 · S/N T18208103N5135PChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10936N5135UEchols Mill Aviation LLC · Elberton, GAS/N 172S9008N51362Caputi J Gary · Mashpee, MABuilt 2001 · S/N 172S9010N5136CMonadnock Aviation Inc · Keene, NHBuilt 2002 · S/N 172S9150N5138710fss - Usafa Aero Club · Usafa, COBuilt 2001 · S/N 172S9013N51388Flight Line Resources Inc · Chandler, AZBuilt 2001 · S/N 172S9014N5138VAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2001 · S/N 172S9012N51390Mustang Sally Aviation LLC · Camden, SCS/N 172S10892N5139UCoosa Valley Aviation Inc · Wilmington, DEBuilt 2001 · S/N 172S9016N5139WConnelly James · Spearman, TXBuilt 2009 · S/N T18208926N513CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10925N513EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13047N513FMenzia Brian Edward · La Valle, WIBuilt 2025 · S/N T20609796N513HPVeracity Aviation LLC · Seguin, TXBuilt 2001 · S/N T20608285N513KMFreedom N513km LLC · Pacific City, ORBuilt 2013 · S/N T18209097N513LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2007 · S/N 172S10494N513MCWilliams Val · Victor, IDBuilt 2006 · S/N 18281811N513NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10764N513SPPlane Old Inc · New York, NYBuilt 2000 · S/N 172S8373N513TDWeber Sandra L · Simpsonville, SCBuilt 1997 · S/N 18280030N513VMMccabes Supply Inc · Watertown, NYBuilt 2004 · S/N T18208310N513WFMeow Meow LLC · Seattle, WABuilt 2004 · S/N 172S9756N51413Mcpike William C · Ludington, MIBuilt 2002 · S/N 172S9042N5141JSasser Nancy Elizabeth · Petaluma, CABuilt 2001 · S/N 18281062N5141YCommonwealth Of Virginia · Fort Monroe, VABuilt 2002 · S/N 18281077N5143QMelnyk George · Sheridan, ORBuilt 2002 · S/N T18208108N5146ECanyon Air LLC · Tucson, AZS/N T20608347N5147JN5147j LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 2001 · S/N 172S9021N5148VAyres Aviation LLC · Santa Monica, CABuilt 2002 · S/N 172S9025N5148YIe3 Enterprise LLC · Elk Grove, CABuilt 2009 · S/N T18208929N51495Wallace State Community College · Hanceville, ALBuilt 2009 · S/N 172S10891N514DGSilver Surfer Enterprises LLC · Hot Springs, ARBuilt 2007 · S/N T18208722N514ERTextron Aviation Inc · Wichita, KSS/N 172S13658N514FCState Of Alabama · Montgomery, ALBuilt 2024 · S/N 18283282N514HPState Of Ohio / Department Of Public Safety · Columbus, OHBuilt 2005 · S/N 18281651N514KMOtv Leasing · Manassas, VAFirst renewal noticeBuilt 2013 · S/N T20609106N514MRDmc Holdings LLC · Bullard, TXBuilt 2012 · S/N 18282328N514MTTrede 2020 C172 LLC · Aurora, ORBuilt 2022 · S/N 172S12922N514NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10765N514NYJones Christopher S · Twin Falls, IDBuilt 2010 · S/N 18282271N5153GHeath Sean · Valley Center, CABuilt 2002 · S/N T18208114N5156MRojas Jose Luis Gomez · Thermal, CABuilt 2002 · S/N T18208145N5157ALongford Aviation Inc · West Chester, OHBuilt 2002 · S/N T20608350N5157ZAspire Aviation LLC · Farmingdale, NYBuilt 2002 · S/N 172S9026N5158JTfs Air LLC · Loveland, COBuilt 2002 · S/N 172S9027N51590Kadena Aero Club · Apo, APS/N 172S9030N515ADJackalope Air LLC · Afton, WYBuilt 2018 · S/N T20609540
Back to AD 2003-24-13