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.

N245WPEberhard Air LLC · Venice, CABuilt 2019 · S/N 4840N2466GIreland Jeffrey L · Shobonier, ILBuilt 2004 · S/N 1244N2468SStolen Hours LLC · Sanford, NCBuilt 2004 · S/N 1090N246BJJas Aviation LLC · East Hartford, CTBuilt 2005 · S/N 1438N246CMHarmon David · Abilene, TXBuilt 2013 · S/N 3929N246DBOps Check LLC · Niceville, FLS/N 2704N246DXAndiamo Ten LLC · Cleveland, TNS/N 3105N246EMRjmr Capital Holdings LLC · Tyler, TXBuilt 2020 · S/N 4913N246GMSky Scrapers LLC · Derry, NHBuilt 2002 · S/N 0260N246MTKolquist Consulting LLC · Hermantown, MNBuilt 2003 · S/N 0760N246PLRff Holdings LLC · Paris, MOBuilt 2023 · S/N 9219N246PTShultz L Edward · Brentwood, TNBuilt 2017 · S/N 4505N246TJLally Glen Joseph · Pleasanton, CAS/N 0382N246TWMr Dent Inc · Manheim, PAS/N 0725N247CPTl Sierra Properties LLC · Mammoth Lakes, CABuilt 2008 · S/N 3166N247GMSijan LLC · Marriottsville, MDBuilt 2022 · S/N 8753N247LVRlv Aviation LLC · Valdosta, GABuilt 2025 · S/N 10854N247SRPsalmbird Aviation LLC · Ormond Beach, FLBuilt 2007 · S/N 2457N247TSCrosswind Aviation LLC · Enid, OKBuilt 2015 · S/N 4280N248ASLlama Cirrus LLC · Concord, MABuilt 2017 · S/N 4537N248CGStahura Conveyor Products Inc · Lewisville, NCBuilt 2001 · S/N 0092N248DGWhinery Kevin D · La Habra, CABuilt 2005 · S/N 1359N248DMMontana 248dm LLC · Kalispell, MTBuilt 2002 · S/N 0374N248GFollett Enterprises LLC · Vlg Of Lakewd, ILBuilt 2005 · S/N 1261N248LKTwelve Forty-Eight Aviation LLC · Camden, DEBuilt 2025 · S/N 10819N248PZPapa Zulu LLC · Belmont, MABuilt 2025 · S/N 10569N248SHWaldron Aviation LLC · Fort Lauderdale, FLBuilt 2002 · S/N 0146N249CKCarolina Landing LLC · Cambridge, MDBuilt 2003 · S/N 0766N249WSSmith Charles L III · Petaluma, CABuilt 2004 · S/N 0975N24ATBobwhite Aviation LLC · Atlanta, GABuilt 2019 · S/N 4768N24CAWoodford Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9318N24CRTop Flying LLC · Dover, DEBuilt 2008 · S/N 2923N24EERomana Mathieu G · Miami Springs, FLBuilt 2008 · S/N 3276N24EGParent Claude · Austin, TXBuilt 2020 · S/N 4877N24ENEkman Co LLC · Chapin, SCBuilt 2019 · S/N 4769N24LFPro Star Aircraft Sales LLC · Londonderry, NHBuilt 2023 · S/N 9549N24MWMn Aviation LLC · Dayton, OHBuilt 2011 · S/N 3758N24RFAlatenn Construction & Properties LLC · Winchester, TNBuilt 2004 · S/N 1168N250CKCirrus Sr22 3421 Inc Owner Trustee · Wilmington, DEBuilt 2009 · S/N 3421N250GKCirrus Design Corp · Duluth, MNS/N 11735N250JHJh Diaries LLC · Dublin, OHBuilt 2013 · S/N 3993N250SXHigh Clouds 22 LLC · Montgomery, TXS/N 3632N251CPBurshtan David H · Huntington Beach, CABuilt 2008 · S/N 3176N2525KAvenue Enterprises Transportation LLC · Longboat Key, FLS/N 0890N2525VLow Ceiling Aviation LLC · Cincinnati, OHBuilt 2006 · S/N 2055N252FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10061N252PDeck Air LLC · Kalamazoo, MIBuilt 2004 · S/N 1002N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448N253ESchnack Aviation LLC · Twin Falls, IDBuilt 2008 · S/N 3106N253FDMile High Aviation LLC · Farmingdale, NJBuilt 2024 · S/N 9845
Back to AD 2007-24-13