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.

N2423CGriffin Aviation LLC · Ventura, CAFirst renewal noticeBuilt 2007 · S/N T18208760N24240Vantage Asset Management LLC · Edinburg, TXBuilt 2007 · S/N T18208763N24245Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13145N24246Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13147N24247Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13148N24249Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13149N2424PMize Craig · Cerulean, KYBuilt 2007 · S/N T18208762N24251Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13150N24256Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13151N24257Career Track I LLC · Wilmington, DEBuilt 2024 · S/N 172S13152N24258Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13153N24259Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13154N24262Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13156N24263Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13157N24265Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13158N24267Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13160N24268Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13161N2426BDBA Investments LLC · Eldon, MOBuilt 2006 · S/N T18208516N2427BKbtp Holdings LLC · Sewickley, PABuilt 2007 · S/N T18208764N24280Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13183N24281Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13185N24283Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13186N24285Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13188N24287J B C Development LLC · Evans, GAS/N T20608605N24289Collen Rodney J · Tacoma, WABuilt 2006 · S/N T18208518N2428JWilliams Shirley A Trustee · Alpine, TXS/N T18208512N24293Digitalev LLC · Westminster, COBuilt 2006 · S/N T20608608N2429QKaufer Peter H · Tucson, AZBuilt 2006 · S/N T18208521N2429RJones Adam · Fairbanks, AKBuilt 2000 · S/N T20608161N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183N242AKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 172S11091N242AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13204N242EPEpic Aviation Inc · New Smyma Beach, FLBuilt 2024 · S/N 172S13243N242JWAviation Leasing Co LLC · Ooltewah, TNBuilt 2019 · S/N 172S12279N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112N242RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11131N242RDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283334N242RT9614m Aviation LLC · Boynton Beach, FLS/N 17280537N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530N242TJMagee Timothy I · Gulfport, MSBuilt 2022 · S/N T20609706N242TWTw Airplane LLC · San Antonio, TXBuilt 2005 · S/N 172S9896N242USilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608242N242WBUnited States Department Of Interior · Boise, IDBuilt 2011 · S/N T20609037N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139N2430QBeavercat Air LLC · Myrtle Point, ORBuilt 2006 · S/N T20608610N24314Weirich William T Jr · Waterman, ILBuilt 2000 · S/N 17280864N24318Milo Technologies LLC · Woodstock, GABuilt 2001 · S/N 17280994N2431GGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 18280681N2431QWade Consulting LLC · Aviston, ILBuilt 2000 · S/N 18280684
Back to AD 2003-24-13