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.

N728SPFleetshares N728sp Inc · Leesburg, VABuilt 2000 · S/N 172S8665N728TAWbl Air II LLC · Minneapolis, MNBuilt 2008 · S/N T20608829N729CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281757N729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILBuilt 2023 · S/N 172S12965N729ELRegistered aircraftBuilt 2023 · S/N 18283209N729LUTextron Aviation Inc · Wichita, KSS/N 172S13596N729MTHochreiter Heinrich · Bellingham, WABuilt 1999 · S/N 172S8272N729SPMars Aerospace Inc · Bay Shore, NYBuilt 2000 · S/N 172S8666N72CEChad A Mcgowan Pc · Rock Hill, SCBuilt 2025 · S/N T20609824N72EFN72ef LLC · Canton, GABuilt 2000 · S/N 172S8636N72FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12936N72KFKirkpatrick John Drew · Post, TXBuilt 2004 · S/N 18281361N72MCAa-Aero Inc · Fairfield, NJBuilt 2005 · S/N 18281653N72MRSnide Thomas C · Dublin, OHBuilt 1998 · S/N 18280123N72RKAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N T20608315N72USUnited States Aviation Underwriters Inc · Toledo, OHBuilt 2001 · S/N 18280936N72ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608700N730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZBuilt 2023 · S/N 172S13036N730LUTextron Aviation Inc · Wichita, KSS/N 172S13599N730WMDennings Greg B · New Bremen, OHBuilt 1998 · S/N 18280361N731CLNby Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282256N731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12573N732CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11568N732LUTextron Aviation Inc · Wichita, KSS/N 172S13602N732VFVictor Fox Aviation LLC · Newport Beach, CABuilt 1998 · S/N 18280296N7339MBroadwell Group Inc · Acworth, GABuilt 2022 · S/N 172S12918N733CNChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12733N733EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13162N733KMKhm LLC · Chardon, OHBuilt 2016 · S/N T20609226N733LUTextron Aviation Inc · Wichita, KSS/N 172S13605N733PRTextron Aviation Inc · Wichita, KSS/N T20609868N733SHChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12735N733TUChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12734N734FGTextron Aviation Inc · Wichita, KSS/N 172S13644N734LUTextron Aviation Inc · Wichita, KSS/N 172S13608N735CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609571N735KMDureiko Martin · Miami, FLS/N T18208037N735RRMiga Holdings LLC · Flower Mound, TXBuilt 2006 · S/N 172S10172N735SW5 Sierra Whiskey LLC · Sonora, CABuilt 2003 · S/N 18281240N735WWRegistered aircraftBuilt 1997 · S/N 18280005N736SCGolf Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13437N7371Registered aircraftBuilt 1998 · S/N 18280212N737EBVx Ventures LLC · Castle Rock, COBuilt 2002 · S/N T18208135N738CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281761N739CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281762N739TWAviolease LLC · Vancouver, WABuilt 2002 · S/N 172S9073N739VJ739vj LLC · Brooklyn, NYBuilt 2008 · S/N T18208860N73CHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13234N73ESWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 18283074N73MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13003
Back to AD 2003-24-13