AD 2007-24-13

Registered aircraft · 4,026

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:2007-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:2007-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.

N516CR516 Ontario Capital Holdings LLC · Hartland, WIBuilt 2005 · S/N 1309N516EVAerofly Procurement LLC · Owasso, OKBuilt 2005 · S/N 1445N516SRLdw Enterprises LLC · Loretto, TNS/N 2062N5175FBroomstick Aviation LLC · Fairfield, IABuilt 2004 · S/N 0818N5175LAsb Industries LLC · Driggs, IDBuilt 2005 · S/N 1542N517CDPeker Lev M · Sylmar, CABuilt 2004 · S/N 1126N517CPInformation Management Systems Inc · Madison, MSBuilt 2008 · S/N 3323N517LMSoaring Paws Aviation LLC · Dickinson, NDBuilt 2011 · S/N 3715N517PZPapa Zulu LLC · Bend, ORBuilt 2004 · S/N 0931N517SWStarship Aviation LLC · Northville, MIBuilt 2003 · S/N 0666N518AWN All Cirrusness LLC · Lake Charles, LABuilt 2014 · S/N 4129N518BADalton Wholesale Floors Of Gordon County Ga Inc · Adairsville, GABuilt 2015 · S/N 4183N518BPDr James Loging Md LLC · Prosperity, SCBuilt 2007 · S/N 2683N518CDCornerstone Auto Parts LLC · Pratt, KSBuilt 2004 · S/N 1229N518CPDdr Enterprises LLC · Kodak, TNBuilt 2008 · S/N 3324N518FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10518N518LMResnik Robert · Scottsdale, AZBuilt 2006 · S/N 2183N518MDGreens Aviation LLC · Lebanon, OHBuilt 2004 · S/N 1183N518VAN518va LLC · Latham, NYBuilt 2026 · S/N 11169N519BRSilver Train Management LLC · Raleigh, NCBuilt 2013 · S/N 3948N519CBMidwest Liquidation LLC · Grand Meadow, MNBuilt 2011 · S/N 3819N519DENiner Delta Echo Inc · Milton, DEBuilt 2006 · S/N 1964N519DHDavis Steven Jeffry Trustee · Poway, CABuilt 2002 · S/N 0233N519SRSale Reported · Seneca, SCSale reportedBuilt 2006 · S/N 2072N519WVRegistered aircraftBuilt 2008 · S/N 2998N51CWAviation Enterprises LLC · Bath, MEBuilt 2020 · S/N 4969N51LAKrauss Elliot A · Princeton, NJBuilt 2005 · S/N 1756N51XJKalm Skies LLC · Mobile, ALS/N 4611N520BCMitchell Bruce P · Medford, ORBuilt 2004 · S/N 0996N520CLRobo Holdings LLC · Tampa, FLBuilt 2024 · S/N 10228N520WKOld Landing Aviation LLC · Great Falls, VABuilt 2011 · S/N 3797N521BTBennett Brady R · Pinehurst, NCBuilt 2003 · S/N 0752N521CDSale Reported · KasselSale reportedBuilt 2007 · S/N 2441N521HWCirrus Design Corp · Duluth, MNS/N 11781N521LCRegistered aircraftN-number assigned (import), not yet registeredS/N 2007N521LMTavallaee Mehrdad M · Ashland, OHBuilt 2006 · S/N 2243N521TSJustice William F · Calabasas, CABuilt 2005 · S/N 1753N521ZHoffner Flying Inc · Yankton, SDBuilt 2002 · S/N 0176N521ZMThompson Russell Clayton · Hartland, MIBuilt 2007 · S/N 2583N5226RBuncamper Theodore · St MaartenBuilt 2006 · S/N 1767N522ACrowe Aviation LLC · Vestavia, ALBuilt 2021 · S/N 5139N522ARMedic Choppers LLC · Springdale, ARBuilt 2005 · S/N 1534N522CDFbm LLC · La Porte, INBuilt 2002 · S/N 0193N522CPFly Cirrus LLC · Murrieta, CABuilt 2008 · S/N 3201N522DDHw Aviation LLC · Largo, FLBuilt 2005 · S/N 1322N522DXFd Aircraft LLC · Summit, NJBuilt 2021 · S/N 5064N522FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10522N522KGJdi Electrical Solutions Inc · Temecula, CABuilt 2004 · S/N 1170N522MGParker James V · Cashiers, NCFirst renewal noticeBuilt 2003 · S/N 0540N522PUFlying Club LLC · New York, NYBuilt 2005 · S/N 1561
Back to AD 2007-24-13