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.

N620ZJStrategic Investment Counsel Corp · Richardson, TXBuilt 2003 · S/N T18208218N6210VEgnatchik James · Orchard Park, NYBuilt 2008 · S/N T18208908N6210YBddixon Aviation LLC · Springfield, MOBuilt 2008 · S/N T20608890N6210ZKatawba Eagle LLC · Lancaster, SCBuilt 2008 · S/N T20608891N6213CMacadam Aviation LLC · Henderson, COBuilt 2008 · S/N T20608873N6213LMeh Air LLC · Benton, ARBuilt 2009 · S/N T18208909N6214NLamplighter82 LLC · Seguin, TXBuilt 2009 · S/N T18208912N6217NXing Kong Aviation Service LLC · Atwater, CAS/N 17281544N6217QZulu Kilo LLC · Seven Valleys, PABuilt 2008 · S/N 18282140N6218BBrant Air LLC · Davidsonville, MDBuilt 2008 · S/N 18282141N62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 172S10833N621CLN621cl LLC · Overland Park, KSBuilt 1999 · S/N 18280618N621DAdams Consulting & Programming Inc · Quincy, ILBuilt 2004 · S/N T18208306N621MCDr Carlton J Lewis And Nina Lewis Family Lp · Lufkin, TXBuilt 2006 · S/N T18208622N621PMAtp Aircraft 1 LLC · Wilmington, DEBuilt 2012 · S/N 172S11177N621TCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8506N62245Gabrieles Wings LLC · Oldwick, NJBuilt 2008 · S/N 172S10694N62276Harris Steven E · Steamboat Springs, COBuilt 2008 · S/N T18208834N6228NGreenwich Venture Partners LLC · Greenwich, CTBuilt 2008 · S/N 172S10695N6229QChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10697N622CMMcgill Charles · Sunriver, ORBuilt 2000 · S/N 172S8467N622EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12821N622FHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282184N622KCAir Burt LLC · Rochester Hills, MIBuilt 2001 · S/N 18281043N622WBRegistration Pending · Missoula, MTRegistration pendingBuilt 2018 · S/N T20609532N6235TCrystal Air Inc · Chattanooga, TNBuilt 2008 · S/N 17281515N6236MJlkd LLC · Lewes, DEBuilt 2008 · S/N 18282075N6238AExecutive Flight Institute LLC · Murrieta, CABuilt 2008 · S/N 172S10702N623DWHtft LLC · Las Vegas, NVS/N 18281094N623EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13097N623HBRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12397N623KWLanier Equipment Leasing LLC · Gainesville, GABuilt 2013 · S/N 172S11269N623RTTextron Aviation Inc · Wichita, KSS/N 18283363N623SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8614N623UTTextron Aviation Inc · Wichita, KSS/N 18283362N62404Tech Flyers LLC · Asheville, NCBuilt 2008 · S/N T18208838N6240JJw2bar Montana LLC · Bozeman, MTBuilt 2008 · S/N T18208837N6241BAces Aviation LLC · Awendaw, SCBuilt 2008 · S/N T20608825N6241ZVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N T20608826N6242FAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10701N6245BInternational Air Services Inc Trustee · Carson City, NVS/N 172S8318N6245CWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10723N6245EDirty Side Down Aviation LLC · Georgetown, TXBuilt 2000 · S/N 172S8674N6245NRoy Robert William · Cumming, GABuilt 2008 · S/N 18282086N6245XWarrington Flying Club Inc · Doylestown, PABuilt 2008 · S/N 18282089N6247CSan Simeon Air LLC · San Francisco, CABuilt 2008 · S/N T18208848N6248SValiair Limited Company Trustee · Casper, WYBuilt 2008 · S/N T18208849N624BBravo Aircraft LLC · Alpharetta, GABuilt 2025 · S/N 172S13347N624CFCorona Jose Jr · Corona, CAS/N 18281059N624MAVotaw Michael · Wilton, CAS/N T20609063
Back to AD 2003-24-13