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.

N575MCStuteville Consulting LLC · Durant, OKBuilt 2007 · S/N 2764N575SABarnts Sales Company LLC · Diller, NEBuilt 2006 · S/N 2003N575TXHu Jianing · Santa Clara, CABuilt 2010 · S/N 3520N575WTDanemann Mark · Taos, NMBuilt 2005 · S/N 1533N576CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1665N576CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3342N576DGEdge David Lee · Lumberton, NCBuilt 2005 · S/N 1617N577DGW&E Aviation LLC · Peoria, AZBuilt 2020 · S/N 4887N577DHHawkeye Aviation LLC · Mason, OHBuilt 2016 · S/N 4339N577PGCirrus Design Corp · Duluth, MNBuilt 2008 · S/N 2978N577SRSteubesand Karl · Rhinebeck, NYBuilt 2007 · S/N 2845N578AGAlpha Gulf Holdings LLC · Wesley Chapel, FLBuilt 2007 · S/N 2822N578CDCarothers Donald Luis · Bakersfield, CABuilt 2005 · S/N 1643N578CPOsman Keenan · Seffner, FLBuilt 2008 · S/N 3350N578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0966N579MWCqf Holdings LLC · Fairhope, ALBuilt 2019 · S/N 4785N579SRShepherd Kris R · Blue Ash, OHBuilt 2007 · S/N 2376N57DB57db Aviation LLC · Fort Myers, FLBuilt 2021 · S/N 5108N57DECape Aviation LLC · Lewes, DEBuilt 2024 · S/N 10129N57FECavu Air LLC · Lees Summit, MOBuilt 2005 · S/N 1521N57PGShirman Leon · Redwood City, CABuilt 2007 · S/N 2674N57RJD&J Training Planes LLC · Logan, UTBuilt 2016 · S/N 4382N57RXVolar Ix LLC · Edmond, OKBuilt 2026 · S/N 11295N57RZSierra Tango Ventures LLC · Monte Sereno, CABuilt 2009 · S/N 3439N57SAFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2024 · S/N 10093N57TUKagley Larry D · Greenwood, SCBuilt 2002 · S/N 0377N580SRNose Up Speed Aviation LLC · Durango, COBuilt 2007 · S/N 2580N581CDLig Air Services LLC · New York, NYBuilt 2022 · S/N 8972N581SDDakota Cross Winds LLC · Bismarck, NDBuilt 2008 · S/N 3171N581THCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11605N583CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1809N584BSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 2330N584CDBrothers David M Trustee · Cainsville, MOBuilt 2005 · S/N 1652N584CFGreenspace Of Virginia LLC · Forest, VABuilt 2022 · S/N 8584N584CPThorpe LLC · Jupiter, FLS/N 3353N584SRThunder Richard · San Diego, CABuilt 2007 · S/N 2378N5854AColorado High Plains Aviation Ltd · Englewood, COBuilt 2002 · S/N 0171N585ABHh Aircraft LLC · Englewood, COBuilt 2009 · S/N 3499N585CDE And J Holdings 25 LLC · El Dorado, ARBuilt 2005 · S/N 1661N585CFBuzzing Above II LLC · Tampa, FLBuilt 2022 · S/N 8585N585ECMc Aviation II LLC · West Palm Beach, FLBuilt 2019 · S/N 4816N585GBCirrus Design Corp · Knoxville, TNBuilt 2013 · S/N 3959N585GT2029 Realty Corp · Farmingdale, NYBuilt 2017 · S/N 4491N585SRNublos Group LLC · Birmingham, ALBuilt 2007 · S/N 2347N5863N5863 LLC · Kalispell, MTBuilt 2019 · S/N 4764N586CAOrlando Holding Company LLC · Port Jervis, NYBuilt 2026 · S/N 11081N586CFJbw Aviation LLC · Benton, KYBuilt 2022 · S/N 8596N586SRFat Alberts Inc · Poteau, OKBuilt 2007 · S/N 2348N587ATBcaa Aviation LLC · Westfield, INBuilt 2009 · S/N 3459N587CPBear Automation Inc · Fayetteville, ARBuilt 2008 · S/N 3354
Back to AD 2007-24-13