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.

N3BKTextron Aviation Inc · Wichita, KSS/N T20609882N3YUT2 Aviation LLC · Missouri City, TXBuilt 2004 · S/N 18281453N4000XJp Skyward LLC · Ontario, CABuilt 1998 · S/N 172S8010N4007SBrennan Richard · Norfolk, VABuilt 2000 · S/N 18280682N400KXSpritzair LLC · Durham, NCBuilt 2003 · S/N T18208212N400USUnited States Aviation Underwriters Inc · Millington, TNBuilt 2004 · S/N T18208276N401AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2020 · S/N 172S12509N401EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 172S12535N401LPMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9401N401SWAnderson James Kenneth Jr · Tulsa, OKBuilt 2011 · S/N 18282301N4022WAero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10131N402CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13235N402CPA & A Drug Co · Fremont, NEBuilt 2009 · S/N T20608923N402CVCivil Air Patrol · Maxell Afb, ALBuilt 2016 · S/N 18282442N402DJFlying Mermaid LLC · Aiea, HIS/N 172S9290N402ERLeighnor Aircraft LLC · Prescott, AZBuilt 1997 · S/N 17280242N402PEDiegos Pet Rescue LLC · Orlando, FLBuilt 1998 · S/N 17280594N403CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13237N403CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282448N403EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12639N403ESPlumdaffy LLC · West Chatham, MAS/N 18280050N403FRBas Part Sales LLC · Greeley, COS/N 17280245N403GFSky Mates Inc · Wilmington, DEBuilt 2005 · S/N 172S9918N403SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 172S8295N403SWBsf Skylane LLC · Buford, GAS/N 18280830N404DCN404dc LLC · Kennesaw, GABuilt 2023 · S/N 172S13065N404EPSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11436N404FREdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280282N404KRCenterline Aviation Inc · Middletown, DEBuilt 2009 · S/N 18282203N4053FBluebird & Blue Skys LLC · St Simons Is, GABuilt 2023 · S/N 18283210N405CCLussier Michael N · Sutton, MABuilt 2006 · S/N T18208602N405CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282439N405DBSn 0048 LLC · Wilmington, DEBuilt 2006 · S/N T20608622N405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FLBuilt 2012 · S/N 172S11154N405ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280219N405FAWestosha Flying Club Inc · Kenosha, WIBuilt 2003 · S/N 172S9405N405SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 172S8298N405TBPiland Donald A · Gulf Shores, ALBuilt 2006 · S/N T18208608N405TTGramling Terry Dewayne Jr · Corinth, MSBuilt 2007 · S/N T18208768N405WFVan Bortel Aircraft Inc · Arlington, TXBuilt 1999 · S/N 18280563N406CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282440N406EPChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11437N406FRLunken Flight Training Center LLC · Cincinnati, OHS/N 17280297N406JASpartan Education LLC · Tulsa, OKBuilt 2007 · S/N 172S10628N406LBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208406N406TAAircraft Unlimited Inc · Pierre, SDBuilt 2003 · S/N 172S9406N406VCVercruyssen Max · Honolulu, HIS/N T18208092N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438
Back to AD 2003-24-13