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.

N187DHPsl Surveys · Bristow, VABuilt 2015 · S/N T20609187N187HSGlidewell Aviation Inc · Parkland, FLBuilt 2005 · S/N 172S9945N1882SWings Over L A Aviation LLC · West Hills, CABuilt 2005 · S/N 172S9930N1884MMontgomery Aviation LLC · Zionsville, INBuilt 2005 · S/N 172S9931N188AGRvest Management LLC · Boulder City, NVBuilt 1999 · S/N T20608039N188AHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13467N188CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283260N188CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282343N188CSJaae Inc · North Miami Beach, FLBuilt 2014 · S/N T20609118N188MESenior Mi LLC · Batavia, ILBuilt 2000 · S/N 20608108N188SSNby Productions · Bristow, VABuilt 2015 · S/N T20609188N188VEFly Skyhawk LLC · Peoria, AZBuilt 2000 · S/N 172S8391N1896BSmart John B III · Southlake, TXBuilt 2005 · S/N 18281731N189CBOtv Leasing · Bristow, VABuilt 2015 · S/N T20609189N189CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281989N189JCTulare County Sheriff · Visalia, CABuilt 2017 · S/N T20609510N189JMJsc Rentals LLC · Missoula, MTS/N T20608782N189JPMontana Skies LLC · Kalispell, MTBuilt 2011 · S/N T18209053N18ACHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9737N18HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281071N18LWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280403N18PMNoel Michael Patrick · Poplar Grove, ILS/N 18280300N190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 2002 · S/N 172S9190N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190N190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRBuilt 2015 · S/N T20609161N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182N19194Smokey Bear Air LLC · Cascade Locks, ORBuilt 2005 · S/N T18208428N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243N191FAHarvey Taz E · Danville, CABuilt 2003 · S/N T18208191N191MBFvx Research · Bristow, VABuilt 2015 · S/N T20609191N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436N19277Roundtree Sod Service Inc · Jacksonville, FLBuilt 2005 · S/N T18208437N192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2005 · S/N 172S9894N192MCWarrington Flying Club Inc · Doylestown, PABuilt 2006 · S/N 172S10162N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454N192TGSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 18281524N192WBPsl Surveys · Bristow, VABuilt 2015 · S/N T20609192N192YSanders Leonard S III · Electric City, WABuilt 2000 · S/N 18280912N1931HMountain Air Aviation LLC · Fruit Heights, UTBuilt 2006 · S/N 172S10128N1934GAero-Tech Services Inc · Lititz, PABuilt 2006 · S/N 172S10129N19369Aci Aviation LLC · Costa Mesa, CABuilt 2006 · S/N 172S10130N1939SFallon Timothy · Center Barnstead, NHBuilt 2005 · S/N 172S9974N193GMRkt Productions · Bristow, VABuilt 2015 · S/N T20609193N193MEHorizon Flight Center LLC · Chesapeake, VABuilt 2000 · S/N 172S8458N193PNc Wildlife Resources Commission Enforcement Div · Raleigh, NCBuilt 2008 · S/N 20608307N193THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11551N193VBAli Suleiman Md Inc · Beckley, WVBuilt 2013 · S/N T18209093N1941BSan LLC · Knoxville, TNBuilt 2021 · S/N 18283158N1947LCal Aggie Flying Farmers · Davis, CABuilt 2016 · S/N 172S11765
Back to AD 2003-24-13