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.

N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 18281438N862AUAuburn University · Auburn Univerity, ALBuilt 2020 · S/N 172S12470N862CPN862cp LLC · Stuart, FLBuilt 1998 · S/N 17280566N862PZBuntzman Gabriel F · Bowling Green, KYBuilt 2000 · S/N 18280762N862STFoxtrot Lima Enterprises LLC · Elbridge, NYBuilt 2005 · S/N T20608542N863AUBas Part Sales LLC · Greeley, COBuilt 2020 · S/N 172S12471N863DRFive Up Aviation LLC · Ambler, PABuilt 2016 · S/N T20609258N863JANorth American Flight Services Inc · Ballston Spa, NYS/N T20608863N863PAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2002 · S/N 172S9062N863SPLegacy Aviation LLC · Tea, SDBuilt 1999 · S/N 172S8122N863TCTjk Aviation LLC · New Canaan, CTBuilt 2012 · S/N T20609055N864AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12472N864CKTabatabai Seyed Ali · Houston, TXBuilt 2005 · S/N 172S9864N864CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281854N864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 1999 · S/N 172S8123N865CKAero American Flight LLC · Houston, TXBuilt 2014 · S/N 172S11466N865CPAmr Holdings LLC · Kalispell, MTBuilt 1998 · S/N 17280602N865CWSouthern Aviation · Anchorage, AKFirst renewal noticeBuilt 2005 · S/N 18281537N865DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12569N865GWMountain West Select Inc · Ammon, IDS/N T18208065N865JPVista Valley Aviation LLC · Ririe, IDBuilt 2012 · S/N T18209065N865PAPlatinum Angel LLC · Melbourne, FLBuilt 2006 · S/N 172S10176N865TCQuinault Aviation LLC · Priest River, IDS/N 18282276N865WMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2013 · S/N 20608352N866CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12634N866DMOrange County Sheriffs Office · Orlando, FLBuilt 2006 · S/N T20608666N866TTSgw Aviation LLC · Hastings, MIBuilt 2018 · S/N 18283042N867CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11589N867EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12675N867HGTextron Aviation Inc · Wichita, KSS/N T20609867N867LAHillsboro Aero Academy LLC · Hillsboro, ORS/N 172S8941N867MMMenzel Electric Inc · Mingo Junction, OHBuilt 2004 · S/N T18208274N868SPWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 172S8128N868TBSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9311N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641N869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12679N869FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10346N86BJWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280238N86PVPvr Construction LLC · Wilmington, DEBuilt 2025 · S/N T18209177N86RPPetree Aviation LLC · Shreveport, LABuilt 1999 · S/N 18280651N86SKPork Chop Aviation LLC · Columbus, OHBuilt 2016 · S/N T20609257N86WEBlue Air 1 LLC · Homestead, FLBuilt 2005 · S/N 20608243N870CPAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280666N870EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13514N870PLake Elysian Sky Holdings LLC · Janesville, MNS/N 18281135N870PDWings Over West Michigan Inc · Wyoming, MIBuilt 2000 · S/N 18280863N870SPEstern Kentucky University · Richmond, KYBuilt 1999 · S/N 172S8130N871CPRedstone Arsenal Flying Activity · Redstone, ALBuilt 1999 · S/N 17280687N871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13517
Back to AD 2003-24-13