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.

N294CSState Of Wisconsin Department Of Administration · Madison, WIBuilt 2011 · S/N 18282294N294EMClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13557N294MAWalker Leasing LLC · Browerville, MNBuilt 1998 · S/N 18280263N294PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12870N294PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13017N294RWAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12898N294SPMazurek Harold Wayne · Sidney, TXBuilt 2003 · S/N 172S9479N294TFTextron Aviation Inc · Wichita, KSS/N 172S13619N295CSLarsen Levitation LLC · Wasilla, AKBuilt 2020 · S/N T20609595N295LPWildridge Aviation LLC · Layton, UTBuilt 2003 · S/N 172S9295N295MEWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2000 · S/N 172S8553N295PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12871N295PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13018N295TFTextron Aviation Inc · Wichita, KSS/N 172S13621N296CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281995N296CS1928 LLC · Salmon, IDBuilt 2020 · S/N T20609596N296DEDouble T Flyers LLC · Fort Worth, TXBuilt 2020 · S/N T20609619N296FSD7 Roofing LLC · New Baden, ILBuilt 2016 · S/N T20609236N296MEJwl Aviation LLC · San Carlos, CABuilt 2000 · S/N 172S8554N296NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11096N296PBChurch Aviation LLC · Christmas Valley, ORBuilt 2015 · S/N T20609175N296PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10211N296PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13324N297BBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12962N297BCUnderwood David · Sarasota, FLFirst renewal noticeBuilt 2007 · S/N T20608764N297CMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609602N297CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12503N297MET L B Inc · Howell, NJBuilt 2000 · S/N 172S8556N297PEPhoenix East Aviation LLC · Daytona, FLBuilt 2006 · S/N 172S10338N297PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13328N297TCMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1997 · S/N 17280016N298CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283020N298DBButler John P · Hazelhurst, WIBuilt 2005 · S/N 18281595N298MCJ C B Aircraft Sales And Leasing · Princeton, NJBuilt 1997 · S/N 17280303N298MEVermont Flight Academy Inc · South Burlington, VTBuilt 2000 · S/N 172S8557N298PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10147N298PLTextron Aviation Inc · Wichita, KSS/N 172S13653N298PN206 Cat Air LLC · Salem, ORBuilt 2001 · S/N T20608298N298SCCharlie Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13241N299CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209199N299KCKings County Sheriff'S Office · Hanford, CABuilt 2000 · S/N T20608177N299KJN299kj LLC · Auburn, WABuilt 2016 · S/N 172S11749N299MCN299mc LLC · Auburn, WABuilt 2014 · S/N T20609122N299PLTextron Aviation Inc · Wichita, KSS/N 172S13654N299SPNorth Dakota Highway Patrol · Bismarck, NDBuilt 2007 · S/N T20608797N29AFDale Michael · Murrieta, CABuilt 1998 · S/N 17280456N29AJWest Alabama Aviation Leasing LLC · Tuscaloosa, ALBuilt 2014 · S/N T20609119N29HTTrede 2023 LLC · Aurora, ORBuilt 2024 · S/N 172S13215N29NPCrown Air LLC · Bend, ORBuilt 2010 · S/N T20608974N2GTT20608770 Inc Trustee · Wilmington, DES/N T20608770
Back to AD 2003-24-13