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.

N711KDDelta Kilo Mike LLC · Rayville, LABuilt 2022 · S/N 5148N711KRMi Leasing LLC · Knoxville, TNBuilt 2015 · S/N 4173N711KWCrosswind Aviation Ltd · Wilmington, DEBuilt 2024 · S/N 10196N711QTTax Law Offices Of David W Klasing Pc · Irvine, CABuilt 2014 · S/N 4095N711XXJci Leasing LLC · Moultrie, GABuilt 2023 · S/N 9242N712ATWegner Cole Aviation LLC · Lincoln, NEBuilt 2017 · S/N 4518N712CDLamadera Enterprises LLC · Lufkin, TXBuilt 2001 · S/N 0027N712MBZero 24 Interests LLC · Houston, TXBuilt 2025 · S/N 10711N712RALone Mountain Aircraft LLC · Vandalia, OHBuilt 2006 · S/N 1933N712RMCrown H Cirrus LLC · Casscoe, ARBuilt 2020 · S/N 4946N712RXWhiskey Kilo LLC · Monroe, LABuilt 2020 · S/N 4902N712SCKilo-Seven Aviation LLC · Annapolis, MDBuilt 2025 · S/N 10574N71357Horn Associates 2 LLC · Brookline, MABuilt 2026 · S/N 11349N713CDCamoin Robert J II · Suffield, CTBuilt 2005 · S/N 1642N713GGLomi Aviation LLC · Houston, TXS/N 3090N713RDGrow Rich LLC · Wilmington, DEBuilt 2004 · S/N 0904N713SBAnderson Adam Lee · Loomis, CABuilt 2005 · S/N 1297N713SRMike & Matts Plane LLC · Brooklyn, NYBuilt 2007 · S/N 2480N715CDRegistered aircraftSale reportedBuilt 2001 · S/N 0016N715CRCrv Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4948N715EMCloud 9 Aviators LLC · Lake Zurich, ILBuilt 2025 · S/N 10917N715JGBz Air LLC · Lebanon, NJBuilt 2026 · S/N 11312N715JNHerman David Trustee · Chesapeake, VABuilt 2013 · S/N 3958N715JPSk Air LLC · Federalsburg, MDBuilt 2017 · S/N 4549N715LPN715lp LLC · Sarasota, FLBuilt 2016 · S/N 4411N715MHHill Michelle · Yreka, CAS/N 4140N715RLNofziger Medical Consulting LLC · Stryker, OHBuilt 2004 · S/N 1141N715SRSch Aviation Inc Trustee · NorfolkBuilt 2006 · S/N 2284N715WTAscend Amigos LLC · Alpine, WYBuilt 2006 · S/N 1974N715YAKansas Aviation LLC · Lawrence, KSBuilt 2019 · S/N 4853N715YJQuintet Capital LLC · Marysville, OHBuilt 2026 · S/N 11345N716BLMcl Aviation LLC · Pinehurst, NCBuilt 2005 · S/N 1314N716BSOz Fund Investments LLC · Charleston, WVBuilt 2019 · S/N 4869N716CDSky-Vu Flyers Inc · Fishers, INBuilt 2001 · S/N 0039N716DRT A S K Aviation LLC · Panama City Beach, FLBuilt 2002 · S/N 0272N716JDMyers Drew E · Norton, MABuilt 2005 · S/N 1598N716KPSpirit Travel Air LLC · Saint Charles, MOBuilt 2004 · S/N 1075N716PVOptimum G7 Aviation LLC · Sterling, VABuilt 2024 · S/N 10236N7171XUnion Hill Aviation Inc · Wilmington, DEBuilt 2004 · S/N 0838N717AHGrace By Air LLC · Hogansville, GABuilt 2012 · S/N 3894N717APLone Mountain Aircraft LLC · Vandalia, OHBuilt 2008 · S/N 3289N717BGRye Aviation Services LLC · Palm City, FLBuilt 2017 · S/N 4548N717DFSb Aviation Corp · New York, NYBuilt 2010 · S/N 3605N717EGHeritage Leasing Inc · Albertville, ALS/N 0704N717JB737 Cessna Inc · Naples, FLS/N 2128N717PGMc Consultants LLC · Isle Of Palms, SCBuilt 2005 · S/N 1711N717SUMouki Aviation LLC · South Lake Tahoe, CABuilt 2004 · S/N 0969N717VMTir Holdings LLC · Safety Harbor, FLBuilt 2007 · S/N 2364N717WHCelebrity Aviation LLC · Tupelo, MSBuilt 2004 · S/N 1201N717ZStephanie Air LLC · Chester Springs, PABuilt 2023 · S/N 9520
Back to AD 2007-24-13