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.

N909EDEdwards Aero Club · Edwards Afb, CABuilt 2012 · S/N 172S11155N909EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12973N909KSKingsky Flight Academy LLC · Lakeland, FLBuilt 2005 · S/N 172S10031N90FLTegridy Equipment Leasing LLC · Aurora, ORBuilt 1998 · S/N 17280562N90HPOklahoma Department Of Public Safety · Norman, OKBuilt 2007 · S/N 18282017N90LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13586N90SUOhio State University · Columbus, OHBuilt 2000 · S/N 172S8475N9101RMiddle Village Enterprises LLC · Maspeth, NYBuilt 2011 · S/N 172S11090N9103ZMountain Pro Imaging Pllc · Omak, WABuilt 2011 · S/N T18209036N910AAWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8173N910CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8332N910HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281012N910LFNby Productions · Bristow, VABuilt 2011 · S/N 18282284N910MABbmd LLC · Wichita, KSBuilt 1999 · S/N T20608098N910SEBates Jonathan R · Chatsworth, CABuilt 2004 · S/N 172S9604N91126Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N T18208489N91160Brown Jeffrey C · Saint Augustine, FLBuilt 2011 · S/N 18282297N911JSTextron Aviation Inc · Wichita, KSS/N T20609872N911LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280639N912AZN912az LLC · Miami, FLBuilt 2003 · S/N 172S9475N912EXObr Leasing · Bristow, VABuilt 2010 · S/N 18282231N912JRN912jr LLC · Dover, DEBuilt 1999 · S/N 172S8200N912LBArizona Flyers Club Inc · Tucson, AZBuilt 2000 · S/N 172S8609N912VMAbove Standard Aviation Inc · South Lake Tahoe, CABuilt 2004 · S/N T18208293N9138WHartford Aviation LLC · Farmdale, OHBuilt 2010 · S/N T20608973N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333N913ECSmith Drake · Dolores, COS/N T20608474N913JCRkt Productions · Manassas, VAFirst renewal noticeS/N T20609109N913MAKennedy Michael J · Gilbert, AZBuilt 1999 · S/N 17280777N913MGValiair Lc Trustee · Casper, WYBuilt 2026 · S/N T20609854N914JBSwartz Eric C Trustee · Aptos, CABuilt 2000 · S/N 18280786N914JPNelen Richard Jj · Fort Collins, COBuilt 2008 · S/N T18208893N914NCCarter Aviation LLC · Tucson, AZBuilt 2013 · S/N T20609113N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399N914SCHotel Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13438N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160N914TALankenau John · Lake Havasu City, AZBuilt 2024 · S/N T18209114N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971N9157A9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12755N915AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13546N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335N915CRVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N T18208519N915DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12071N915DDWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8149N915EATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609850N915JTLd Aviation LLC · Durango, COBuilt 2005 · S/N T18208444N915LSBlack Bear Aviation LLC · Camden, DEBuilt 2023 · S/N 18283235N915NJTight Lines Aviation LLC · Adams, TNBuilt 2006 · S/N T20608667N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358N915WCBarr Air Patrol LLC · Mesquite, TXBuilt 2003 · S/N T20608412
Back to AD 2003-24-13