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.

N636CPurcell Dave M · Bowling Green, KYBuilt 2002 · S/N 0406N636CTScarpone Aviation LLC · Phoenix, AZBuilt 2008 · S/N 2979N636KBRiviera Glass Flyers Inc - Trustee · Wichita, KSBuilt 2004 · S/N 1000N636STDelavan Emery Lee Jr · Castroville, TXBuilt 2006 · S/N 2153N636TLMasr Plane LLC · Amarillo, TXBuilt 2010 · S/N 3636N637MRDavis Thomas H · Pt Pleasant Beach, NJBuilt 2014 · S/N 4082N638KBIngram Air LLC · Hahira, GABuilt 2008 · S/N 3026N638SRRabidou Gary R Jr · Lancaster, MABuilt 2006 · S/N 2182N639CCirrusly LLC · Cheyenne, WYBuilt 2006 · S/N 1860N639SRShelley Leslie I · Temple, TXBuilt 2007 · S/N 2639N63KADickert Investments - Flying Dicks LLC · Cave Creek, AZBuilt 2009 · S/N 3444N63MESky22 LLC · Auburn, ALBuilt 2021 · S/N 5126N640CDRegistered aircraftBuilt 2005 · S/N 1704N640PRjs Aviation LLC · Perryville, MOBuilt 2004 · S/N 1070N641SR641sr LLC · Greeley, COBuilt 2007 · S/N 2363N641WTN641wt LLC · Helena, MTBuilt 2024 · S/N 9913N642CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1720N642CPDodson International Parts Inc · Rantoul, KSBuilt 2009 · S/N 3366N642SRSafford Robert Owen Jr · Clarksville, TNBuilt 2006 · S/N 2195N642TLBuddy Air LLC · West Bend, WIBuilt 2010 · S/N 3642N643JMSherman Aviation LLC · Haslett, MIBuilt 2003 · S/N 0756N643SRSky Dawgs LLC · Kennesaw, GABuilt 2006 · S/N 2136N643TFFlyway Aviation Partners LLC · Rogers, ARBuilt 2019 · S/N 4796N644CDKapp LLC · Dallas, TXBuilt 2004 · S/N 0940N644GKCirrus Design Corp · Duluth, MNS/N 11893N644SRBas Part Sales LLC · Greeley, COBuilt 2006 · S/N 2070N645BDFly 645bd LLC · Louisville, KYBuilt 2005 · S/N 1529N645CGainous David C · Port Saint Joe, FLS/N 0395N645CDSkylane LLC · East Hampton, NYBuilt 2004 · S/N 0913N645CPRjgvb LLC · Shippensburg, PAS/N 3371N645EMMcdevitt Aircraft LLC · Naperville, ILS/N 1634N645RSSlack Richard · Highland, UTBuilt 2024 · S/N 9856N645SRArcangel Aviation II LLC · Kansas City, MOBuilt 2007 · S/N 2645N6468Charlie Sierra Aviation LLC · Norwalk, IABuilt 2002 · S/N 0419N646ABInternet Strategies LLC · Glenview, ILBuilt 2023 · S/N 9369N646AFFlight1 Technical Training Services LLC · Myrtle Beach, SCBuilt 2026 · S/N 11355N647CDGomez Enrique Jose · Pinecrest, FLBuilt 2005 · S/N 1724N648ACHey Clinic Pa · Raleigh, NCBuilt 2010 · S/N 3648N648CDurant Cecil John · Arlington, TXBuilt 2003 · S/N 0441N648CB648cb LLC · Columbus, OHS/N 0648N649CDSouthcap Brokerage Altanta Inc · Inlet Beach, FLBuilt 2005 · S/N 1709N64MROne Mike Romeo Leasing LLC · Las Vegas, NVBuilt 2003 · S/N 0724N64TGWilliamson Russell Haire Jr · Memphis, TNBuilt 2012 · S/N 3845N650SREndpoints & Evidence LLC · Surf City, NCBuilt 2006 · S/N 2221N651CPN651cp LLC · Sylacauga, ALBuilt 2010 · S/N 3670N651JRSumar Electrical Systems Inc · Warren, OHS/N 3491N651MMEcr Aviation LLC · Elizabeth, NJS/N 1960N651XCWoodland Air LLC · Grand Rapids, MIBuilt 2003 · S/N 0475N652CDCameronair LLC · Ann Arbor, MIBuilt 2006 · S/N 1794N652JMRed Raider Asset Holdings LLC · Austin, TXBuilt 2019 · S/N 4806
Back to AD 2007-24-13