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.

N788RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282321N788VBKrajkovich John B · Honesdale, PABuilt 2006 · S/N T18208644N789BGM9c146 Aviation LLC · Boynton Beach, FLBuilt 2000 · S/N 17280938N789DRVaquero Skies LLC · El Paso, TXBuilt 2022 · S/N T20609673N789EPEastbourne Holdings LLC · Woodstock, GAFirst renewal noticeBuilt 1999 · S/N 172S8135N789FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13167N789PFSherman Aviation LLC · Fairfield, NJBuilt 2011 · S/N 172S11115N789PRChampignon LLC · Miami, OKBuilt 2012 · S/N T20609059N789RSH6 Aviation LLC · Concord, NCBuilt 2006 · S/N T20608644N789SDStrain Derick J · Arbuckle, CAS/N T20608719N789TCMadden Contracting Co Inc · Minden, LABuilt 2000 · S/N 18280788N78ASAerial Services Inc · Cedar Falls, IABuilt 1999 · S/N T20608078N78BKKang Byung · Kansas City, MOBuilt 2024 · S/N 18283277N78LGSecond Winds Aviation LLC · Camden, DEBuilt 2025 · S/N T18209170N78MLDakota Wings LLC · Brookings, SDS/N T20608731N78NDApollo One One LLC · Bedminster Townshi, NJBuilt 2006 · S/N T20608681N78WESouth Delta Aviation Inc · West Helena, ARBuilt 2000 · S/N 18280832N790FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13169N790SATavern Aviation LLC · Tavernier, FLBuilt 2001 · S/N 20608160N790SPMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8716N791FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13170N792FAAb Prop Plane II LLC · Chicago, ILBuilt 2024 · S/N 172S13172N792GWSmith Brothers Aviation LLC · Bryan, TXBuilt 2000 · S/N 18280792N792MD150th Aero Flying Club Inc · Morristown, NJBuilt 2004 · S/N 172S9750N792SALynn John R Jr · Laconia, NHBuilt 2001 · S/N 172S8901N792SPUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2001 · S/N 172S8717N793FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13173N793HFMid Continental Aviation LLC · Wilmington, DEBuilt 2007 · S/N T20608793N793SPLeading Edge Aviation Inc · Doylestown, PABuilt 2001 · S/N 172S8718N793STPoor Boy Aviation LLC · Wilmington, DEBuilt 2024 · S/N T18209157N793WTRaritan Valley Flying School · Princeton, NJBuilt 1997 · S/N 17280080N794CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282127N794FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13174N794RGFb Aviation LLC · Minot, MEBuilt 1999 · S/N 18280538N794SATmb Aviation LLC · Fresno, CABuilt 2001 · S/N T18208062N795DHSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609061N795FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13176N795THOcean Aviation Inc · Georgetown, DEBuilt 2022 · S/N 172S12795N796CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209196N796HAJatavallabhula Narasimha Sastry · Longview, TXBuilt 2006 · S/N 18281796N796SPOpensky Airways LLC · Los Angeles, CABuilt 2001 · S/N 172S8720N796THSanders Flight Training Center Inc · Jasper, ALBuilt 2022 · S/N 172S12796N796WWCrist Aviation Services LLC · Woodland, CABuilt 2000 · S/N 172S8635N797BBKurt Aviation · Middleton, DEBuilt 2002 · S/N T18208148N797FAChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12728N797SPSundowners Inc · Fort Myers, FLBuilt 2001 · S/N 172S8721N797TMMilliren Karl · Thomasville, NCBuilt 1998 · S/N 18280169N798FAChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12729N798NGSouthwest Aviation Enterprises · Haslet, TXBuilt 2014 · S/N T20609153N798SMPointer Logistics LLC · Rancho Cucamonga, CABuilt 1998 · S/N 18280266
Back to AD 2003-24-13