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.

N9161TMenagerie Enterprises Inc DBA · Denison, TXBuilt 2011 · S/N 172S11093N9163TMcc Investments LLC · St Louis, MOBuilt 2010 · S/N T20608975N916BAMaya Aircraft Holdings LLC · Lee, NHBuilt 2002 · S/N 172S9116N916BQ9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12756N916ET9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12759N916FT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12758N916GW9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12760N916HT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12761N916KTPelican Flight Training LLC · San Carlos, CABuilt 2021 · S/N 172S12763N916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265N916MCJanicke Kenneth O · Wichita, KSBuilt 2009 · S/N T18208914N916NT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12762N916PBM & G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12765N916QTElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12766N916RR9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12767N916TAAtp Aircraft 4 LLC · Wilmington, DES/N 17281076N916UT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12768N916WRPsl Surveys · Manassas, VAFirst renewal noticeS/N 18282262N916WTRound Rock Aviation LLC · Douglas, WYBuilt 2007 · S/N T20608752N9171UAir Alpine Activities Inc Trustee · Wilmington, DES/N T18209032N91777Triple 7 Holdings LLC · Lewes, DEBuilt 2010 · S/N T20608984N9177VWorld Wide Life Services LLC · Short Hills, NJBuilt 2010 · S/N T20608979N917CFN917cf LLC · Tucson, AZBuilt 2005 · S/N T20608523N917CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8337N917MAKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 172S8270N9181PNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11084N918CMRodriguez Eduardo Urquidi · Santa Teresa, NMBuilt 2001 · S/N T20608281N918CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8338N918EEArchaeopteryx LLC · Harvey, LABuilt 2022 · S/N T20609708N918KGGreasewood Ranch Aviation LLC · Midland, TXBuilt 2006 · S/N T20608637N918MYFlying Pigs LLC · Tulsa, OKBuilt 2005 · S/N 18281512N918RGG & L Equipment Leasing LLC · Natchez, MSBuilt 2006 · S/N T20608682N918TPAzure Quest LLC · Cleveland, TNBuilt 2007 · S/N 18281904N918WMStone City Charters LLC · Anamosa, IABuilt 2008 · S/N 18282068N91920Brodel Adam · Grass Valley, CABuilt 2007 · S/N 18281921N91934N91934 LLC · Evergreen, COBuilt 2012 · S/N 17281613N91936Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281614N9195BSouthwest Aviation Enterprises · Haslet, TXBuilt 2015 · S/N T20609195N91966Wings Over Texas Holdings LLC · Denton, TXS/N 17281616N9196WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281615N9197MGlover Carl A · Albuquerque, NMBuilt 2006 · S/N T20608675N9198WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281617N91996Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281619N9199ZOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281618N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339N919CWGv Air Inc · Medford, ORBuilt 2006 · S/N T20608619N919EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12378N919MKRyan Jacqueline Lee · Bend, ORS/N T18208019N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843N919TCD & S Aviation LLC · Spring, TXBuilt 2005 · S/N 172S10019
Back to AD 2003-24-13