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.

N624TMKestrel Rentals LLC · Eden, UTS/N T18208244N62510Wilson Woodie J · Hattiesburg, MSS/N T20608836N6251AKma Air Venture LLC · Fontana, WIBuilt 2008 · S/N T18208852N6251KSutton Aircraft Salvage LLC · Palmer, AKBuilt 2008 · S/N T20608832N62546Kurtz Benjamin · Steamboat Springs, COBuilt 1999 · S/N T20608104N6259TRhys Vineyards LLC · Woodside, CABuilt 2008 · S/N T18208853N625EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13101N625HADenventures Aviation LLC · Wheat Ridge, COBuilt 2006 · S/N T18208626N625LSPhoenix Flyers Inc · Mesa, AZBuilt 2004 · S/N 18281356N625PLGv Air Inc · Medford, ORBuilt 2007 · S/N T20608787N625SPSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8616N625TALandeco LLC · Fincastle, VABuilt 2006 · S/N T20608625N62615Chopaire LLC · Decatur, ALBuilt 2008 · S/N T18208854N6261LWoodward Aviation LLC · Alpine, TXBuilt 2004 · S/N T18208289N6261RGray Joseph C · San Diego, CABuilt 2004 · S/N T18208290N6261XLines Gary K · Glendale, AZBuilt 2004 · S/N T18208292N6265TW Air LLC · Wheeling, ILBuilt 2008 · S/N 172S10733N6269QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10715N626CBWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10734N626DBJims Air LLC · Oconomowoc, WIBuilt 2004 · S/N T20608503N626EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13525N626GHSwordfish Enterprises LLC · Avenue, MDBuilt 2017 · S/N T20609525N626GMMike Smith Aviation International Inc · Napa, CABuilt 2021 · S/N 172S12688N626LSHollendonner Keith · Markleville, INBuilt 2005 · S/N T18208405N626PDC S A Inc · Ogallala, NEBuilt 2006 · S/N T18208547N62726Xing Kong Aviation Service LLC · Atwater, CAS/N 17281529N6275SMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2008 · S/N 18282100N62770Hog Island Flying LLC · Winter Park, FLBuilt 2008 · S/N 172S10747N6278AJohnstone Jon T · Brentwood, CABuilt 2008 · S/N T18208864N62799Dutchflier Captial LLC · New Hudson, MIBuilt 2008 · S/N 18282056N6279AVpc Aviation LLC · Cartersville, GABuilt 2008 · S/N T18208865N627ARTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13594N627CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281336N627EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13063N627SPFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8621N6281ZLawrence John · Portland, ORBuilt 2008 · S/N T18208866N62828Benchmark Farm Management Inc · Riverbank, CABuilt 2008 · S/N T18208867N6284SNorth Dakota Aeronautics Commission · Bismarck, NDBuilt 2008 · S/N T20608851N62875L&W Leasing LLC · Smyrna, TNBuilt 2008 · S/N 172S10756N628BHelsley William W · Mc Gaheysville, VABuilt 2019 · S/N T20609583N628CTAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12897N628FNFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280227N628GEJacob LLC · Oakland, NJBuilt 2000 · S/N T20608201N628GVClark R Judson · San Luis Obispo, CABuilt 2005 · S/N T20608520N628LAAircraft Holdings LLC · Scottsdale, AZBuilt 2024 · S/N 172S13126N628PDMessimer Joseph L Jr · Nacogdoches, TXBuilt 2000 · S/N 18280724N62926Peterson Business Promotions LLC · Portland, ORBuilt 2008 · S/N T20608854N6292HRkd Illinois Aviation LLC · Libertyville, ILBuilt 2008 · S/N T18208872N6292JVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N T18208873N6294YCarlson Ernest C Jr · Fairbanks, AKBuilt 2004 · S/N T18208295
Back to AD 2003-24-13