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.

N327ADGundry Adam · Superior, WIBuilt 2024 · S/N T18209164N327GHTextron Aviation Inc · Wichita, KSS/N 18283369N327MTHayden LLC · Tiburon, CABuilt 2019 · S/N T20609559N327SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8254N327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CABuilt 2005 · S/N T18208447N3288Mewmew Investment II LLC · Palo Alto, CABuilt 2020 · S/N 172S12430N328CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283309N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328N328TMMathews Thomas J · New Castle, INBuilt 2024 · S/N T18209148N329CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609130N329CSOvercast 329 LLC · Jonesboro, ARBuilt 2021 · S/N T20609637N329KBMagee Brad D · Durango, COBuilt 2007 · S/N T18208788N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329N32HSFarm Boy Aviation LLC · Boynton Beach, FLBuilt 2006 · S/N T20608645N32LPBartlett Paul H · Nebo, NCBuilt 2025 · S/N 18283331N32LTLt Leasing LLC · Saint Petersburg, FLBuilt 2021 · S/N 18283154N32MTHeading 406 LLC · Kalispell, MTBuilt 2021 · S/N T20609652N32PSDepartment Of The Interior · Boise, IDBuilt 2021 · S/N T20609651N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267N330JEWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280299N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863N332CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12137N332MCClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13551N332SCSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608332N332SPMh Aviation LLC · Foster City, CABuilt 2020 · S/N 17281118N3338VAero-Tech Services Inc · Lititz, PABuilt 2025 · S/N 172S13307N333FRHofstetter Seth · Jacksonville, ORBuilt 2024 · S/N T18209131N333JEJs Aviation Inc · Valparaiso, INBuilt 2026 · S/N 172S13562N333PFDennis Bruce · Hesperus, COBuilt 2011 · S/N T18209027N333TCKaty Partnership Leasing LLC · Watertown, SDBuilt 2025 · S/N T18209166N333TSAerostar Management Services LLC · Kissimmee, FLBuilt 1999 · S/N 172S8240N334SASchaumburg Flying Club Nfp · Palatine, ILBuilt 1998 · S/N 18280393N334SPSierra Pop Air LLC · Wilmington, DEBuilt 2003 · S/N 172S9494N334WDSouthwest Aviation Enterprises · Haslet, TXBuilt 2011 · S/N 20608334N335JWN335jw LLC · Hilton Head Island, SCBuilt 2019 · S/N T20609579N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466
Back to AD 2003-24-13