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.

N278SPSvetful Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9474N278TMBuena Vista Aviation LLC · Fresno, CABuilt 2023 · S/N T20609728N279MEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 172S8535N279TWPresotto David L Trustee · Palo Alto, CABuilt 2010 · S/N T18209015N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27DVDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N T20608111N27GHNelson Aviation LLC · Chesterfield, MOBuilt 2017 · S/N 18283019N27MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12599N27TJTj Aero LLC · Winchester, MABuilt 2021 · S/N 172S12656N27TPTandem Skydive Saipan Inc · Saipan, MPBuilt 2016 · S/N 172S11690N27VANorton Mark H Trustee · Stateline, NVBuilt 2015 · S/N T20609170N280CSYolo Farms LLC · Raleigh, MSBuilt 1999 · S/N 18280511N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620N280MEAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8536N280PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10834N280SCJuliet Charlie Aviation LLC · Oregon City, ORS/N 172S12443N280SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12432N280UOhio University · Athens, OHBuilt 2003 · S/N 172S9464N281AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281189N281DKN281dk LLC · Brandywine, MDBuilt 2005 · S/N 18281719N281EAElevation Air Capital LLC · Janesville, WIBuilt 2023 · S/N 172S13043N281PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10878N281RWR Wings LLC · Deland, FLBuilt 2026 · S/N 18283340N281WSWight David · Alvin, TXBuilt 2006 · S/N T20608611N28206Huey David G · Sumas, WABuilt 2008 · S/N T20608830N2829JSunrise Aviation LLC · Las Vegas, NVBuilt 2008 · S/N T20608801N282ABVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282139N282AUNeice Russell G · Shreveport, LABuilt 2006 · S/N T18208540N282ESC282es LLC · Tampa, FLBuilt 1996 · S/N 18280002N282HDDavis Aviation LLC · Wilkesboro, NCBuilt 2005 · S/N 18281631N282JSLego Paul Gregory · Watsonville, CABuilt 2007 · S/N T18208682N282MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8540N282MMMewmew Investment II LLC · Palo Alto, CABuilt 2019 · S/N 172S12247N282MTMissig James M · Great River, NYBuilt 1997 · S/N 18280079N282PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10750N2830PSandpiper Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280593N283LPPecue Michael T · Mount Dora, FLBuilt 1998 · S/N 18280283N283MEN283me LLC · Manassas, VABuilt 2000 · S/N 172S8541N283PEDolphin Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10897N284CSSc Aviation LLC · Manhattan, KSBuilt 2020 · S/N 18283094N284LPSo Cal Leasing LLC · El Cajon, CABuilt 2002 · S/N 172S9284N284MEPatriot Leasing LLC · Franklin, TNBuilt 2000 · S/N 172S8542N284PEBravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10974N285CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N T18209010N285CSDrury'S Journey LLC · Los Altos, CABuilt 2020 · S/N 18283095N285CVBarr Air Patrol LLC · Mesquite, TXBuilt 1997 · S/N 18280059N285DVJohnson Jeffrey L · Fargo, NDBuilt 2000 · S/N T20608171N285EASouth Carolina Forestry Commission · Columbia, SCBuilt 1999 · S/N 18280524N285JLLink Air Service LLC · Minong, WIS/N T20608373N285PEBravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10888
Back to AD 2003-24-13