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.

N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902N2209HLynxaviation LLC · Carpinteria, CABuilt 2007 · S/N T18208672N220CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13256N220CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13046N220CSTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 18283220N220DETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608241N220WCJeffery & Weiss Holdings LLC · Long Beach, CAS/N 172S10519N2214LBlue Bird Aviation LLC · San Jose, CABuilt 2005 · S/N 18281718N2217LInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 18281674N221DWDm Private Aviation LLC · Kaukauna, WIBuilt 2026 · S/N T20609848N221EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12621N221GSBarientos Bryan I · Petaluma, CABuilt 2001 · S/N T18208034N221JTThompson Joseph · Marion, INBuilt 2017 · S/N T20609520N221MEKarabin Gerald D · Vicksburg, MIBuilt 2000 · S/N 172S8481N22206Slater Craig W · Brick, NJBuilt 2022 · S/N T20609682N2220YFarid Zia Physical Therapist A Professional Corp · El Centro, CABuilt 2005 · S/N 18281676N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681N2221XK C Leasing Corp · Woods Cross, UTBuilt 2007 · S/N T18208703N22237Aviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10025N2223UDylans Rv Center LLC · Waterford, NJBuilt 2005 · S/N 18281677N2225AFreedom Aviation Inc · Lynchburg, VABuilt 2007 · S/N 172S10467N2225FTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N 172S10468N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026N2227FBay Area Aviation LLC · Beach City, TXBuilt 2005 · S/N 18281681N2228THulsey Hunter · Madison, MSBuilt 2005 · S/N T18208480N222DCTextron Aviation Inc · Wichita, KSS/N 18283364N222FGoddspeed LLC · Encinitas, CABuilt 2000 · S/N T20608154N222KWHines Tommy · Calvert City, KYBuilt 2007 · S/N T18208759N222LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8919N222MTJw182 LLC · Kalispell, MTBuilt 1998 · S/N 18280108N222VWCool Beans LLC · Newtown, PAS/N 18280085N222XMSchlasinger Larry DBA · Chetek, WIBuilt 1998 · S/N 18280119N2231EState Of Iowa · Des Moines, IABuilt 2007 · S/N 18281924N2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 18281925N2233MPutnam John P · Weirsdale, FLS/N 18280069N2234UMountain States Casing Co LLC · Timnath, COBuilt 2006 · S/N T18208485N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928N2237SOregon State Police · Salem, ORBuilt 2006 · S/N T18208488N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580N223EMKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282252N223HCG206 LLC · San Juan, PRBuilt 2006 · S/N 20608269N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112N223JMEid Bradley · Greenwood, INBuilt 2006 · S/N T18208484N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223N223MEChem-Air LLC · Shreveport, LABuilt 2000 · S/N 18280746N223TB416b Heritage Hills Dr LLC · Palm Harbor, FLS/N T20609211N22412Time Flies LLC · Oak Brook, ILBuilt 2007 · S/N T20608737
Back to AD 2003-24-13