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.

N271AFBurke Aircraft Service Co LLC · Portsmouth, OHBuilt 2003 · S/N 18281188N271CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13090N271DCForum Aviation LLC · Middletown, DEBuilt 2005 · S/N 18281579N271JLSouthwest Aviation Enterprises · Haslet, TXBuilt 2024 · S/N T20609778N271LDVan Well Trucking LLC · Dallas, ORBuilt 2010 · S/N T20608977N271SLVan Bortel Aircraft Inc · Arlington, TXBuilt 2024 · S/N 18283271N271SPIndiana Department Of Administration · Greenwood, INBuilt 2000 · S/N 18280911N27216Jjep Aviation LLC · Seattle, WABuilt 1998 · S/N 18280320N2722FBowen Michael D DBA · Noblesville, INBuilt 1998 · S/N 18280352N2724REcho Flight LLC · Tucson, AZBuilt 1998 · S/N 18280322N2726XSuttman Robert · Dayton, OHBuilt 2007 · S/N 18281913N272ARWinging It Inc · Stephenson, MIS/N T18208055N272FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13454N272HFHorizon Flight Center LLC · Chesapeake, VABuilt 2022 · S/N 172S12776N272LPAa-Aero Inc · Fairfield, NJBuilt 2002 · S/N 172S9272N272MMTownair LLC · Sandy, UTBuilt 2006 · S/N 172S10105N272SBBailey Aviation LLC · Chesapeake, VABuilt 2001 · S/N 172S8908N272SPBlue Ryan LLC · Billings, MTBuilt 1998 · S/N 172S8016N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202N273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217N273TCStanford Doug · Oak Harbor, WABuilt 2013 · S/N T18209090N2740K2740k LLC · Prospect, KYBuilt 2006 · S/N T18208514N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587N2747RWilliams Dwight M · Paragould, ARS/N 18280343N2748FWirth Gerald J Trustee · New Lenox, ILBuilt 1998 · S/N 18280345N274BBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282270N274CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609127N274DGBourne Michael Paul · Crystal Bay, NVBuilt 2004 · S/N T18208260N274MESabra Davis Corp · Wilmington, DEBuilt 2000 · S/N 20608122N274MMHanzawa George DBA · Wahiawa, HIBuilt 2003 · S/N 172S9320N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635N276GTChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9281N276MEBoersma Rances LLC · Warden, WABuilt 2000 · S/N 20608124N276SALiberty University · Lynchburg, VABuilt 2013 · S/N 172S11276N276TATextron Aviation Inc · Wichita, KSS/N 18283366N2772Lewis University · Romeoville, ILBuilt 2005 · S/N 17281252N277GTSvetfur Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9286N277MTException LLC · Manning, SCBuilt 2022 · S/N 18283174N277TCTranslift Inc · Holly, MIBuilt 2005 · S/N 20608257N277USCooper Robert · Sugar Grove, ILBuilt 2000 · S/N 18280894N278CA278ca LLC · Union Gap, WABuilt 2008 · S/N 172S10801N278FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13453N278JHRaytheon Co · Tucson, AZBuilt 2007 · S/N T20608715
Back to AD 2003-24-13