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.

N314KD314 Aviation LLC · Carlisle, PABuilt 2024 · S/N 10165N314PKKelsey Excavating Inc · Davis, ILBuilt 2006 · S/N 1779N315AHHorizon Aviation Holdings LLC · Fort Lauderdale, FLBuilt 2019 · S/N 4789N315CDFranklin Clinton · Edmond, OKBuilt 2004 · S/N 0947N315CKMarket-Partners Inc · Santa Rosa, CABuilt 2009 · S/N 3413N315DBBooker Daniel R · Newaygo, MIBuilt 2005 · S/N 1596N315JRStarkweather James · Southwest Ranches, FLBuilt 2005 · S/N 1604N315JSAmore Industries LLC · Greer, SCBuilt 2015 · S/N 4200N315NLBestrand Aviation LLC · Cincinnati, OHBuilt 2017 · S/N 4586N315RTTidwell Consulting LLC · Phil Campbell, ALBuilt 2016 · S/N 4387N315SRMarciniak Paul D · Lebanon, TNBuilt 2007 · S/N 2315N316ABRegistered aircraftBuilt 2006 · S/N 2079N316BCBc Air LLC · Great Falls, VABuilt 2024 · S/N 10358N316CDRegistration Pending · Fort Worth, TXRegistration pendingS/N 0876N316JSRegistration Pending · Bluffton, SCRegistration pending, canceledBuilt 2019 · S/N 4814N316LRLake Wendell · Madison, WIBuilt 2004 · S/N 0841N316PHMoon Hill Farm LLC · Kirkland, WABuilt 2004 · S/N 0891N316RJAction Helicopters Services Inc · Rockland, DEBuilt 2025 · S/N 10647N316SSSkyhawk Leasing LLC · Indianapolis, INBuilt 2025 · S/N 11091N317AWilcox Jeffery · Fayetteville, TNBuilt 2006 · S/N 2105N317CDBluecore Leadership LLC · Reston, VABuilt 2004 · S/N 0905N317DETyler Petroleum Inc · Tyler, TXS/N 0057N317KM7 Kilo Mike LLC · Tipp City, OHBuilt 2008 · S/N 2942N317LMDixieaviator LLC · Missoula, MTBuilt 2007 · S/N 2317N317RDelaney Jeffrey Stephen · Arlington, TNBuilt 2003 · S/N 0495N318BXLongshore Aviation LLC · Hyannis, MABuilt 2012 · S/N 3833N318CPValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 3239N318EFLima Yankee Aviation LLC · Greenbriar, TNBuilt 2023 · S/N 9267N318FDWilliston Morrison Investment Partners LLC · Newark, DEBuilt 2021 · S/N 5101N318MR318mr LLC · Missoula, MTBuilt 2006 · S/N 2026N318SVColorado Mountain Rv LLC · Fort Collins, COBuilt 2007 · S/N 2397N318WBSkysurfer LLC · Reston, VABuilt 2023 · S/N 9378N318WTThompson Brent D · Bloomington, INBuilt 2003 · S/N 0474N319CPAttaway Penny · Greenville, ILBuilt 2008 · S/N 3269N319GSilver Star Holdings LLC · Aurora, COBuilt 2002 · S/N 0319N319MPAccelerated Development Organization · Hampton, VABuilt 2002 · S/N 0287N319TMCloudsail Aviation LLC · Princeton, NJBuilt 2024 · S/N 9993N319WSStill Air Ventures Inc · Wilmington, DEBuilt 2010 · S/N 3677N31FDCirrus Design Corp · Duluth, MNS/N 11836N31GUBuyin Time LLC · Clearbrook, MNBuilt 2006 · S/N 2274N31MVCypress Air Charter LLC · Estero, FLBuilt 2022 · S/N 8588N31SWBenwild Aviation LLC · Middleburg, VABuilt 2019 · S/N 4825N31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0679N320CDSimpulse Inc · Oregonia, OHBuilt 2004 · S/N 1248N320DFDfig Holdings LLC · Kalispell, MTBuilt 2025 · S/N 11068N320DGSrs 320 LLC · Houston, TXBuilt 2023 · S/N 9402N320RLLast Flight Out LLC · Brentwood, TNBuilt 2006 · S/N 1854N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320TSSinclair Peter · Los Gatos, CABuilt 2003 · S/N 0771N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508
Back to AD 2007-24-13