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.

N653WWBerry Aviation Inc · San Marcos, TXBuilt 2005 · S/N T20608521N65411Simmons Guy M · Paso Robles, CABuilt 2004 · S/N 172S9714N65413John Mccaskill Enterprises LLC · Tifton, GAS/N 18281444N65431Caliber Capital Holdings LLC · Homosassa, FLBuilt 2004 · S/N T18208302N65445International Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N T18208322N65447Maxxum Financial Group Inc · Destrehan, LABuilt 2004 · S/N 172S9712N65452Jf Aviation LLC · Minot, NDBuilt 2004 · S/N T20608491N6545365453 LLC · Blaine, MNBuilt 2004 · S/N 172S9717N65459Vitatoe Industries Inc · Chillicothe, OHBuilt 2004 · S/N T20608492N65471Overland Aviation LLC · Williston, NDBuilt 2004 · S/N 172S9718N65472Registered aircraftBuilt 2004 · S/N 18281451N65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeBuilt 2004 · S/N T20608493N65499Pacific Quality Controls Inc · Wrightwood, CABuilt 2004 · S/N 172S9720N654CSCharlies Angel LLC · New Castle, DEBuilt 2002 · S/N 172S9166N654NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11470N654PAPurdue Aviation LLC · West Lafayette, INBuilt 2018 · S/N 172S12141N654PWParham Phillip · Ringgold, GABuilt 2025 · S/N T18209193N654SPJm Air Holdings LLC · Stevensburg, VABuilt 1998 · S/N 172S8060N654TCBrocchini Christopher R Trustee · Sacramento, CAS/N T18208028N654ZZarmada LLC · Issaquah, WABuilt 2006 · S/N T18208627N65501Right Rudder Arizona LLC · Litchfield Park, AZBuilt 2004 · S/N 172S9721N65504Bg Ip LLC · Saratoga, CAS/N 18281452N65507Cora & Associates LLC · Norcross, GABuilt 2004 · S/N 18281454N65512Wiebe Van Michael · Filer, IDBuilt 2004 · S/N 18281457N65514Vogt Gregory A · Broken Arrow, OKBuilt 2004 · S/N 18281458N65515Peterson Darren · Janesville, WIBuilt 2004 · S/N T18208325N65537Aces High Aviation LLC · Long Beach, CABuilt 2004 · S/N 172S9726N65557Classic Aircraft LLC · South Bend, INBuilt 2004 · S/N 18281456N65567Skylane Sky LLC · North Palm Beach, FLBuilt 2004 · S/N 18281465N65575Flight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 172S9728N6558EZata Group LLC · North Little Rock, ARBuilt 2004 · S/N 18281466N655CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281655N655EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12453N655NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11471N655PDJls Aviation LLC · Sarasota, FLBuilt 2000 · S/N 172S8655N65602Ballew James H · Las Vegas, NVBuilt 2004 · S/N 18281487N65616B&M Aircraft LLC · Mission, TXS/N T20608468N65618Glass Christopher Matthew · Mc Ewen, TNS/N T20608531N65637N65637 LLC · Manassas, VAS/N 172S9739N65638Mid Continent Aircraft Corp · Hayti, MOBuilt 2004 · S/N 18281467N65641Lexington Flying Club Inc · Lexington, KYBuilt 2005 · S/N 17281233N65647Jmc Aviation LLC · Santa Rosa, CABuilt 2005 · S/N 172S9778N65664Southwest Flying Club Inc · The Woodlands, TXBuilt 2004 · S/N 18281489N65672Jensen Thomas · Nixa, MOS/N 18281474N656CBUniversity Of Central Missouri · Warrensburg, MOBuilt 2022 · S/N 172S12800N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656N656EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12454N656FCFlorida Department Of Agriculture & Consumer Svcs · Tallahassee, FLBuilt 2017 · S/N 18283008N656MAWings Over Texas Holdings LLC · Denton, TXS/N 17280924N656SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8061
Back to AD 2003-24-13