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.

N723SEFrost Cavin Bert · Odessa, TXBuilt 2022 · S/N 18283188N723SPElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8657N723TCWisodak Air LLC · Eau Claire, WIBuilt 2024 · S/N T18209156N724BF5904 Msl LLC · Tahoe City, CABuilt 2018 · S/N 172S12192N724CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609570N724EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13026N724EWVan Bortel Aircraft Inc · Arlington, TXBuilt 2016 · S/N 18282430N724LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13206N724PGL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280613N724SPCandace A Larned Enterprises Inc · Long Beach, CABuilt 2000 · S/N 172S8658N724TMiller Neil · Plymouth, MNBuilt 1998 · S/N 18280250N7252SDorris Joseph · Lewisburg, KYBuilt 1999 · S/N 18280562N7254HVevani Aircraft LLC · Miami Gardens, FLBuilt 1999 · S/N 20608036N72559Welch Paul · Oldsmar, FLBuilt 1999 · S/N 18280654N7256DAir Supremacy LLC · Bend, ORBuilt 1999 · S/N T20608068N7256GAvstar Inc · Seattle, WABuilt 1999 · S/N 18280560N7256HChaparral Aviation LLC · Edmond, OKBuilt 1999 · S/N 18280556N7256QAustin Ferrel Stephen · West Monroe, LABuilt 1999 · S/N 18280552N7256WRoswall James B · Bristol, TNBuilt 1999 · S/N 18280507N7256YGupta Vivek · Shelton, CTBuilt 1999 · S/N 18280485N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783N72582Surdex Corp · Chesterfield, MOFirst renewal noticeBuilt 1999 · S/N T20608114N7258RMoynihan Daniel P · Hernando Beach, FLS/N 17280981N7258ZGraber Jesse B · Northfield, MNBuilt 1999 · S/N T20608113N725BJBas Part Sales LLC · Greeley, COS/N 20608023N725LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13209N725LVAia Echo LLC · Henderson, NVBuilt 2021 · S/N 172S12748N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009N72608Gv Air Inc · Medford, ORBuilt 2001 · S/N T20608268N7260AChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280861N7260HN2617f LLC · Frankfort, KYBuilt 2000 · S/N 18280896N7260KAmbitious Aviation LLC · Newport News, VABuilt 2000 · S/N 18280895N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957N72612Washington State Dept Of Transp · Tumwater, WAS/N 18280988N72614Liberty Leasing IV LLC · Melbourne, FLBuilt 2000 · S/N 20608117N7261HMurray John Fulton III · Fort Worth, TXS/N 20608143N7261MCox Jeff C · Newark, OHBuilt 2000 · S/N 18280901N7261ZChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9080N72623Law Office Of Vincent G Rieger Pc · Kalispell, MTS/N T20608162N72626Isr Platforms LLC · Mclean, VAS/N T20608275N7262ACf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2000 · S/N 20608138N7262MRegistered aircraftBuilt 2000 · S/N 18280900N7262XFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 17280993N72634Rnd Technologies LLC · Lancaster, CABuilt 1999 · S/N T20608108N72638Dysart Jack L · Steamboat Springs, COBuilt 1999 · S/N T20608127N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N72647Awa Tupua LLC · Brambleton, VABuilt 1999 · S/N 18280623N7264DGravity & Grace LLC · Mill Valley, CABuilt 1999 · S/N 20608062
Back to AD 2003-24-13