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.

N2PSUnited States Department Of The Interior · Boise, IDS/N T20609243N3005YGreen Acres Aviation LLC · Berryville, ARBuilt 2022 · S/N T20609681N300EPVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 18280903N300KXAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11607N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135N302AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281190N302CFEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 17281137N302MPKqm Aviation · Bristow, VABuilt 2010 · S/N 18282273N302TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13221N302WDAmado'S Holdings LLC · Rice, MNBuilt 2016 · S/N T20609241N3033LDaniel Gary · Fallston, MDBuilt 2008 · S/N 18282109N303EHNavigation Leasing LLC · Keizer, ORBuilt 2023 · S/N 172S13058N303HBFly The Coop LLC · Newton, KSBuilt 2019 · S/N T20609577N303KATjs3 Aviation LLC · Wilmington, DEBuilt 2013 · S/N T18209094N303RHNavigation Leasing LLC · Kaizer, ORBuilt 2022 · S/N 172S12926N303SFSnohomish Flying Service Inc · Snohomish, WABuilt 2025 · S/N 172S13478N303STVolar Vii LLC · Edmond, OKBuilt 2012 · S/N 172S11242N3040MAustin 206 Aviation LLC · Americus, GABuilt 2023 · S/N T20609732N304CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283267N304CGVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281609N304CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12511N305CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11532N305DKWashington State Patrol · Olympia, WABuilt 1999 · S/N 20608080N305FGRidgeline Assets LLC · Wilmington, DES/N 172S13274N305JGAbeona-Adeona Aviation LLC · Wilmington, DEBuilt 2023 · S/N T20609718N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692N305MTMtc Air LLC · Homestead, FLBuilt 2025 · S/N T20609809N305RCWashington State Patrol · Olympia, WABuilt 2001 · S/N 18281001N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834N305TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13227N305WTToro Procurement LLC · San Angelo, TXBuilt 2015 · S/N T20609164N3064CN3064c LLC · San Tan Valley, AZBuilt 2012 · S/N T18209084N306CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13082N306CSSecurity Alert Aviation LLC · Gilroy, CABuilt 2016 · S/N T20609225N306DPHer Airway LLC · Boca Grande, FLBuilt 2016 · S/N 172S11736N306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12968N306PPSl Aviation LLC · Seattle, WABuilt 2010 · S/N 172S11042N307BZSummit Aviation Inc · Belgrade, MTBuilt 2003 · S/N 172S9486N307CSDetwiler Jeffrey D · Lancaster, PABuilt 2013 · S/N T20609105N307RJGv Air Inc · Medford, ORBuilt 2012 · S/N T20609060N308AROverstreet Investments Inc · Boonville, MOBuilt 2024 · S/N T20609756N308CLRodoni William · Santa Cruz, CABuilt 2008 · S/N T18208825N308CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609128N308DMD&M Aircraft Co Inc · Thonotosassa, FLBuilt 2023 · S/N T20609745N308NRState Of Wisconsin · Madison, WIBuilt 2024 · S/N 18283262N308SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9487N309BRValdosta Flying Service Inc · Valdosta, GABuilt 1999 · S/N 172S8101N309DKNby Productions · Bristow, VABuilt 2021 · S/N T20609643N309GMScroggins Aero LLC · Cabot, ARBuilt 2022 · S/N 18283166
Back to AD 2003-24-13