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.

N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORBuilt 2005 · S/N T18208379N379MATurtle With Wings LLC · Yukon, OKBuilt 1999 · S/N 18280443N379SAAerofeather Aviation Inc · Suffolk, VABuilt 2002 · S/N T18208074N379TAChuck Smith Aircraft Inc · Torrance, CABuilt 2003 · S/N 172S9379N37CJFly172s LLC · Peoria, AZBuilt 1999 · S/N 172S8232N37GGAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280353N37HDJohnston-Matejek Aviation LLC · Houston, TXBuilt 2006 · S/N 18281850N37JAFlying Start Aero Services LLC · Reno, NVBuilt 1997 · S/N 17280095N37JFNexga Aircraft Inc · Greensboro, NCBuilt 2009 · S/N T20608934N37MTBeaver Valley Flying Club Inc · Beaver Falls, PABuilt 1999 · S/N 172S8205N37SDAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13250N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035N380CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282459N380ESZak William Roy Jr · Kissimmee, FLBuilt 1997 · S/N 18280053N380MA75 East Air LLC · Valparaiso, INBuilt 1999 · S/N 18280561N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559N3810Nerio Antonio · Eagle Pass, TXBuilt 2013 · S/N T20609096N381CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12139N381ESFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280081N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192N382CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282461N382JSDap Aviation Ventures LLC · Missoula, MTBuilt 2021 · S/N 18283156N383DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12648N383KDT-6 LLC · Wilmington, DEBuilt 2012 · S/N 18282358N383MEParlu Ventures LLC · Eagles Mere, PABuilt 2000 · S/N 172S8567N383SPKv Helicopters LLC · Lititz, PABuilt 1999 · S/N 172S8279N383TCSpengler Raymond Francis Jr · Longview, TXBuilt 2003 · S/N 172S9383N384EAMatisoff Noah · Helena, MTBuilt 2008 · S/N T18208884N384JVan Bortel Aircraft Inc · Arlington, TXBuilt 2025 · S/N T18209175N384MCAero-Tech Services Inc · Lancaster, PABuilt 2007 · S/N 172S10438N384MESj Flyers LLC · San Jose, CABuilt 2000 · S/N 172S8569N3852BGromley Kevin M · Farmington, MIBuilt 2011 · S/N T18209028N385CSCosmos Holdings Group LLC · Newark, DEBuilt 2016 · S/N T20609231N385DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12651N385KLIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8116N385MAPesek Larry Paul · Steinhatchee, FLBuilt 1998 · S/N 18280419N385RBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282199N385TCLiebl Holdings LLC · Claremore, OKS/N T18208385N386CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283344N386EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12912N386ESJet Air Inc · Iowa City, IABuilt 1997 · S/N 17280106N386MEHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8583N386SPUsaf Academy Aero Club · Usaf Academy, COBuilt 1999 · S/N 172S8283N387AFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2006 · S/N 172S10387N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287N387DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12652N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284N387TCBass Joel W · Okeechobee, FLBuilt 2005 · S/N T18208386N388UTFree Bird Air LLC · La Crosse, WIS/N T20608620
Back to AD 2003-24-13