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.

N206JAFabick John D · Saint Louis, MOBuilt 1999 · S/N 20608014N206KMHoskins Marc R · Kennett, MOBuilt 2001 · S/N 20608153N206LWestern Air Pilots LLC · Mountain Home, ARBuilt 2004 · S/N T20608498N206LBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608055N206LEFort Worth And Western Air Express LLC · Southlake, TXBuilt 2008 · S/N T20608810N206LGHotel Kilo Aviation LLC · Anchorage, AKBuilt 2007 · S/N T20608714N206LLMoondog Motorsports LLC · Missoula, MTBuilt 2012 · S/N T20609058N206MBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2023 · S/N T20609746N206MDAuction Aviation Inc · Boulder City, NVBuilt 1999 · S/N T20608014N206MESouthwest Erosion Control · Mckinney, TXBuilt 2025 · S/N T20609816N206MFMission Aviation Fellowship · Nampa, IDBuilt 2015 · S/N T20609160N206MNMartin Nelson & Co Inc · Seattle, WABuilt 2006 · S/N T20608646N206MTBlue Spruce LLC · Bigfork, MTBuilt 1999 · S/N T20608076N206MWZaludy Aviation LLC · Paynesville, MNS/N T20608314N206MXFrogfeet LLC · BarcelonaBuilt 2001 · S/N 20608149N206MZKtbr Holdings LLC · Statesboro, GABuilt 2005 · S/N T20608551N206PFPatriot Fuels Inc · Alexander, NDBuilt 2025 · S/N T20609817N206PJIllingworth Paul John · Georgetown, TXBuilt 2008 · S/N T20608876N206PMTunnel Aviation LLC · Tunnel Hill, GABuilt 2002 · S/N T20608376N206PQHogue LLC · Paso Robles, CABuilt 2001 · S/N T20608299N206RAAcord Transportation Inc · Chandler, OKBuilt 2021 · S/N T20609654N206RPFinley Aviation LLC · Fort Worth, TXBuilt 2005 · S/N T20608516N206RR206 Adventures LLC · San Juan, PRBuilt 2013 · S/N T20609102N206SBCounty Of Santa Barbara · Santa Barbara, CAS/N 20608167N206SJUrbana Aviation LLC · Woodstock, OHBuilt 1998 · S/N T20608007N206TBAir Supply LLC · Tuscumbia, ALBuilt 2025 · S/N T20609813N206UESmith Peter I Trustee DBA · Ocala, FLS/N T20608744N206VBN206vb LLC · Batavia, OHBuilt 2013 · S/N T20609084N206VSBos Ranch LLC · Reno, NVBuilt 1999 · S/N T20608030N206WEM&B Holdings LLC · Verdi, NVS/N T18208635N206WKKaw Corp · Mcallen, TXBuilt 2001 · S/N T20608318N206WYAerotrust Services Corp Owner Trustee · Wilmington, DEBuilt 2000 · S/N T20608187N206YPIm Aviation LLC · Laredo, TXBuilt 2020 · S/N T20609620N206ZB16d LLC · Vashon, WABuilt 2006 · S/N 20608276N20704Atpce LLC · Wilmington, DES/N 172S12531N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562N20711Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12563N20727Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12577N20747Above And Beyond Aviation LLC · Austin, TXBuilt 2020 · S/N 172S12578N20773Smtm Holdings Inc · Wilmington, DEBuilt 2004 · S/N 172S9570N2077NLilylands Aviation LLC · Redvale, COBuilt 2004 · S/N T18208225N207ALU S Imaging Flight Ops LLC · Bartow, FLBuilt 2015 · S/N T20609163N207CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13071N207CDCheek Gary L · Chandler, AZBuilt 2007 · S/N T18208791N207PBBernstein Petra M · Salisbury, MDBuilt 2006 · S/N 18281771N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485N2080QHyperion Enterprises LLC · Warrenton, VABuilt 2005 · S/N T18208450N20818N20818 LLC · Wilmington, DES/N 172S12579N2081JWings Over Texas Holdings LLC · Denton, TXS/N 17280995
Back to AD 2003-24-13