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.

N36TPEichenour Daniel L · Willis, TXBuilt 2005 · S/N T18208387N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000N370ESPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280029N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191N370K370k LLC · Bethany, OKBuilt 2026 · S/N 172S13481N370MEFlying Circuss Aviation Services Inc · Wasilla, AKBuilt 2000 · S/N 20608126N370SPElite Approach LLC · Chesterfield, MOBuilt 2003 · S/N 172S9501N371CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282001N371MALets Fly LLC · Eugene, ORBuilt 1999 · S/N T20608028N371RHChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10414N372AFFlyslow Aviation LLC · Sterling, VABuilt 2003 · S/N 18281191N372AHRegier Tom · Dinuba, CABuilt 2006 · S/N 172S10156N372BHLewis University · Romeoville, ILBuilt 2006 · S/N 172S10110N372CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282002N372HBUnited States Air Force 21 Force Support Squadron · Colorado Springs, COBuilt 2005 · S/N 172S9983N372MEAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 20608130N372TADap Aviation LLC · Reston, VABuilt 2006 · S/N 172S10372N372TWTom Wood Aviation · Fishers, INBuilt 2015 · S/N 172S11632N373CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281986N373MAKropf Kevin G · Montrose, COBuilt 1999 · S/N T20608117N373SAValiair Lc Trustee · Casper, WYBuilt 2019 · S/N 18283087N373WDBeardall Ann · Kiowa, COBuilt 2004 · S/N T18208264N3744WTextron Aviation Inc · Wichita, KSS/N T20609863N3744YKt 2022 LLC · Broomfield, COBuilt 2020 · S/N 172S12435N374CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281987N374MASeatown Air LLC · Seattle, WABuilt 1999 · S/N 172S8076N374MEKelley Aviation LLC · Crescent, IABuilt 2000 · S/N T20608223N374SAFloris Flight Services LLC · Midland, TXBuilt 2013 · S/N 172S11274N374SPSkiles Richard L · Wimberley, TXBuilt 2003 · S/N 172S9503N374TCPrecision Aviation Services LLC · Columbiana, OHBuilt 1998 · S/N 18280374N375MASteinhardt Clark R Jr · Green Bay, WIBuilt 1999 · S/N 172S8077N375SRN375sr LLC · Hickory, NCBuilt 2020 · S/N T20609616N376MESpirit Air Inc · Salmon, IDBuilt 2000 · S/N T20608225N376SPTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2003 · S/N 172S9508N3776TFractional Villas Inc · Del Mar, CABuilt 2004 · S/N T18208314N377CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283308N377CSFreetown Partners LLC · Newark, DES/N T20609137N377EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608182N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086N377GKCholla Civil Construction LLC · Mesa, AZBuilt 2020 · S/N T20609615N377HAGrasse Louis Phillip Trustee · Saint Louis, MOBuilt 2004 · S/N T20608499N377MEBrandywine Enterprises Lp · Beverly Hills, CABuilt 2000 · S/N T20608226N378CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13260N378CSKerr Tractor Gp LLC · Beaumont, TXBuilt 2022 · S/N T20609678N378HDept Of The Interior · Boise, IDS/N T20608242N378MARussell Robert Q · Genoa City, WIBuilt 1999 · S/N 172S8078N378MECamelot Aviation LLC · Phoenix, AZBuilt 2000 · S/N T20608228N378MSJulius Kaleb · Tucson, AZBuilt 2002 · S/N T18208082N379BFDay Darrell Rodney · Sahuarita, AZBuilt 2004 · S/N T18208253N379DTN379dt LLC · Naples, FLBuilt 2007 · S/N T20608777
Back to AD 2003-24-13