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.

N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781N771SPIllinois State Police · Springfield, ILBuilt 2024 · S/N T20609769N771TMMid-South Aviation LLC · Caruthersville, MOBuilt 2011 · S/N 18282286N772FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13277N772GKAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9885N772MSSchmidt Barnet M · Oradell, NJBuilt 1999 · S/N 172S8180N773AAAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13476N773BAMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8773N773HPFlorida Highway Patrol · Tallahassee, FLBuilt 2000 · S/N T20608180N773SPFox Flying Club Inc · Wheaton, ILBuilt 2001 · S/N 172S8702N773TFRivergates Ivy Aviation LLC · Boca Raton, FLBuilt 2017 · S/N 18283004N773TTTim Twisselman Enterprises Inc · San Luis Obispo, CABuilt 2021 · S/N 18283124N7744SVista Air Inc · Pacoima, CABuilt 1999 · S/N 172S8274N774CFApperson Aviation LLC · Palm City, FLBuilt 2017 · S/N 18283021N774CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282257N774FLSacramento County Sheriff'S Office · Sacramento, CABuilt 2023 · S/N T20609736N774LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13117N774TMVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283088N775CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281779N775DSFlight Ventures LLC · Charlotte, NCS/N T18208498N775LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13121N775MRTorres Kim Renee · Castroville, TXS/N 18281073N775SP775sp LLC · Blaine, MNBuilt 2001 · S/N 172S8705N775WBSusanville Aviation LLC · Susanville, CABuilt 1998 · S/N 18280134N776AASolo Aircraft Rental LLC · Farmingdale, NYBuilt 2005 · S/N 172S9928N776CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281776N776MWAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13475N776SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12444N776VB40ac LLC · Hartford, WIBuilt 2000 · S/N 172S8508N776YBJ Wesley Hangar 1 LLC · Fargo, NDS/N T18208654N7772HGws Contractors Inc · Bonne Terre, MOBuilt 2004 · S/N T18208257N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336N7775BCessna 206 LLC · Sun Valley, IDBuilt 2000 · S/N T20608197N777HEUsoarflorida LLC · Fort Myers, FLS/N 172S8120N77812Wildman Gary C Trustee · Germantown, TNBuilt 2005 · S/N 18281549N7781EGibson Paul Trustee · Groveland, CABuilt 2005 · S/N 18281621N778AASolo Aircraft Rental LLC · Farmingdale, NYS/N 172S9933N778CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281778N778DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N T20608073N778MCWilkins Jason Samuel · Powell Butte, ORBuilt 2007 · S/N T18208711N778SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13582N7791CRohlfing Frederic L · Kirkwood, MOBuilt 2004 · S/N 18281423N779JABaumgart John · Nashville, TNBuilt 2024 · S/N 18283250N779MCDonahue Robert J · Akron, OHBuilt 2007 · S/N T18208770N779SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13583N77LARaintree Aviation LLC · Mesa, AZBuilt 2017 · S/N 172S12030N77LUGerman Farms Inc · Fullerton, NDBuilt 2003 · S/N 17281154N780BWBridgewater State University · North Dartmouth, MABuilt 2000 · S/N 172S8600N780CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281780N780EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13569
Back to AD 2003-24-13