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.

N527DKEci Staffing Solutions Inc · Stamford, CTBuilt 2023 · S/N T20609722N527DPNavair LLC · Mount Vernon, OHBuilt 2021 · S/N T20609627N527DSSkyhawk Leasing LLC · Greenfield, INBuilt 2004 · S/N 172S9588N527NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10818N527ZMTextron Aviation Inc · Wichita, KSS/N 172S13662N5280DHdw Florida Helicopters Inc · Pompano Beach, FLBuilt 2002 · S/N 172S9212N5280RSpringbrook Leasing LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9216N5283CRanchaero LLC · Houston, TXS/N T20608959N5284SFly America Inc · Stanford, CABuilt 2010 · S/N 172S11026N52858Channel Islands Aviation Inc · Camarillo, CABuilt 2002 · S/N 172S9186N5286CUnited Flying Club Inc · Belmont, CABuilt 2002 · S/N 172S9219N5288TG & S Air Adventures LLC · Jersey City, NJBuilt 2002 · S/N 172S9222N5289HClarke Simon P · Seattle, WABuilt 2009 · S/N T18208936N528CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283032N528ERMary Air LLC · White Rock, NMBuilt 2001 · S/N 172S8926N528HWyoming Management LLC · Sheridan, WYBuilt 2020 · S/N T20609608N528KCBukhart Don · Blakely Island, WABuilt 2002 · S/N 18281109N528LDCar Two Charlie LLC · Lewes, DEBuilt 2021 · S/N 18283130N528LEZeus Aviation LLC · Carlisle, OHBuilt 2008 · S/N 18282046N528LSYoung Robert A · Mount Desert, MEBuilt 2007 · S/N T18208798N528MJAircraft Owners & Pilots Association · Frederick, MDBuilt 2001 · S/N 18280991N528NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10825N528PVMelin Mark Alan · Newport, NCBuilt 2007 · S/N 18282035N528SCMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9210N528SVFox Leasing Group LLC · Hollywood, FLBuilt 2004 · S/N 172S9754N528WBAdvantage U S A A Inc · Spring Branch, TXBuilt 2008 · S/N T20608807N5290ESpacely Space Sprockets LLC · Aurora, ORBuilt 2002 · S/N 172S9226N5290HLevy James L · Clifton Park, NYBuilt 2002 · S/N 172S9230N5290VSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11025N5291ALewis Aeronautical LLC · San Antonio, TXBuilt 2009 · S/N 172S11021N5291WMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9234N5293PRogue Aero LLC · Grants Pass, ORBuilt 2010 · S/N T20608962N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186N5296DZack Gary J · Sunderland, VTS/N 172S9239N5296ZSouthern Sky LLC · Henderson, NVBuilt 2002 · S/N 172S9241N5297EAtd Pilot Training LLC · Kansas City, MOBuilt 2002 · S/N 172S9242N5297GChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9243N5298NJ3m Airops LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9244N5298SSix Ten Ventures LLC · Grand Prairie, TXBuilt 2002 · S/N 172S9246N529ERPs N529er LLC · Green Bay, WIBuilt 2002 · S/N 172S9111N529NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10981N529PTLt Express LLC · Carson City, NVBuilt 2002 · S/N T18208119N529SDReal Property Strategies LLC · Los Gatos, CABuilt 2007 · S/N T20608710N52ACBloxham Tod · Tacoma, WABuilt 2011 · S/N T20609017N52HAAssociated Packaging Inc · Gallatin, TNS/N 18282226N52LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13198N52TMJorgensen Aviation Inc · Richfield, UTBuilt 2019 · S/N 18283080N53020Iasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281136N5302XFnb Flying Club LLC · Gallatin, TNS/N 18281175N53039Laurel Highlands Aeronautical Academy · Latrobe, PAS/N 172S9259
Back to AD 2003-24-13