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.

N68BKKrauch William K Co-Trustee · Santa Ynez, CABuilt 2005 · S/N T18208398N68CEEbright Inc · Stateline, NVBuilt 2004 · S/N T20608438N68DSSichak Stephen Jr · Wanaque, NJBuilt 1997 · S/N 18280033N68FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12934N68KWKim Waters Inc · Gainesville, GABuilt 2023 · S/N 18283217N691JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13595N691SPGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1999 · S/N 172S8100N691TCSpartan National Holdings LLC · Missoula, MTBuilt 1999 · S/N 172S8225N6929JMhz5620 LLC · Fitchburg, WIBuilt 1998 · S/N 18280158N692CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11541N692SPSmith Holdings Inc · Wilmington, DEBuilt 1999 · S/N 172S8102N693SACaddo Aircraft LLC · Lewes, DEBuilt 2000 · S/N 172S8514N694BWOtter Creek Aviation LLC · Columbus, GABuilt 2004 · S/N T18208262N694CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11547N694RJAtlas 182rj LLC · Port Townsend, WABuilt 2005 · S/N T18208473N694SAMile High Ventures Inc · Palm Harbor, FLBuilt 2000 · S/N 18280803N694SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12587N694SMSurveying And Mapping LLC · Austin, TXBuilt 2004 · S/N 20608223N694SPFox Leasing Group LLC · Hollywood, FLBuilt 1999 · S/N 172S8104N694TCBruton Aerial Spraying Inc · Garden City, TXS/N 20608069N695CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12156N695SPJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8623N696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722N696SAThree Green Aviators LLC · Midland, TXBuilt 2000 · S/N 18280845N697CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11562N697EFElam Nathan A · Hereford, TXBuilt 2012 · S/N T20609043N698JABon Bon Aviation LLC · Daly City, CABuilt 2008 · S/N 172S10698N698MCRegistered aircraftBuilt 1998 · S/N 18280336N698SPFoothill Aircraaft Sales & Service Inc · Upland, CABuilt 2000 · S/N 172S8639N699AWTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609855N699CBBig Skylands Aviation LLC · Succasunna, NJBuilt 2001 · S/N 18281033N699CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283103N699LPFrg III Inc DBA · Lincoln Park, NJBuilt 1999 · S/N 172S8275N69CPBuena Vista Hunting LLC · Eagle Pass, TXBuilt 2005 · S/N T20608564N69JYInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N T20608627N6HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281070N6HTColorado By Air LLC · Salida, COBuilt 2003 · S/N T20608387N6TSRd Leasing LLC · Salem, ORS/N T20609557N700HWHotel Whiskey LLC · Sylvania, OHBuilt 1999 · S/N T20608034N700PMRar LLC · Louisville, KYBuilt 1998 · S/N 172S8034N701FASkylane Flyers LLC · Fort Mill, SCBuilt 2002 · S/N 18281107N701LULiberty University · Lynchburg, VABuilt 2012 · S/N 172S11163N701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeBuilt 1999 · S/N 172S8192N702CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281702N702GRAir America Flight Center LLC · Daytona Beach, FLBuilt 1998 · S/N 17280558N702LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11386N703BFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13488N703BKKenzy 2023 LLC · Castle Rock, COBuilt 2023 · S/N 172S12991N703CMSeneca Structural Engineering Inc · Irvine, CABuilt 2010 · S/N T20608965N703CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281703
Back to AD 2003-24-13