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.

N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581N20887N20887 LLC · Augusta, GABuilt 2005 · S/N T18208452N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502N208DGDelta Golf Aviation LLC · Pompton Plains, NJBuilt 2008 · S/N T20608866N208FT423 East Young LLC · Warrensburg, MOBuilt 2005 · S/N T20608573N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571N2095JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608554N2095SMrk Aviation LLC · Delray Beach, FLBuilt 2004 · S/N T20608442N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762N2098CLynch Stephen J · Stamford, CTBuilt 2004 · S/N T18208228N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333N2099YThompson And Harvey Holdings LLC · Orcutt, CABuilt 2004 · S/N T20608444N209CSMat Air LLC · Bridgeport, TXBuilt 2011 · S/N T20609002N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826N20ADDdd Partnership · Davis, CABuilt 2020 · S/N T20609612N20APF & M Holdings LLC · Goshen, ALS/N T18208160N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216N20CNRegistration Pending · Bedford, PARegistration pendingBuilt 2019 · S/N T20609584N20DBLsn Air LLC · Morrison, COBuilt 2004 · S/N T18208331N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623N21002Gr Aircraft LLC · Rancho Mirage, CABuilt 2007 · S/N T18208677N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589N21019Svetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9595N2101GCarter James E · Thornville, OHBuilt 2004 · S/N T18208230N2101VWell Hung Metal LLC · Sulphur, LABuilt 2007 · S/N T18208733N2101ZPico'S Plane LLC · Rockport, MEBuilt 2007 · S/N T20608712N21022Ameriflyers Of Texas Inc · Addison, TXBuilt 2004 · S/N 172S9660N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660N2104HGrenier Chad · Moorpark, CABuilt 2007 · S/N 172S10432N21056N21056 LLC · Wayne, PABuilt 2007 · S/N 172S10434N2105XAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12585N2107UFlight World Inc · San Juan, PRBuilt 2004 · S/N 172S9603
Back to AD 2003-24-13