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.

N27WVN27wv LLC · Shortsville, NYBuilt 2004 · S/N 1031N2801LAv8sgf LLC · Rogersville, MOBuilt 2017 · S/N 4475N280CDWelling Lynn E · El Cajon, CABuilt 2005 · S/N 1411N280CPAi Aviators LLC · Vancouver, WABuilt 2008 · S/N 3222N280LVagiunic David · Ridgewood, NYBuilt 2002 · S/N 0154N280SREdge Forward LLC · Thermopolis, WYBuilt 2007 · S/N 2800N281CPJust Plane Insane LLC · Missouri City, TXBuilt 2008 · S/N 3181N281DSBoughton Kyle · Mckinleyville, CABuilt 2007 · S/N 2534N281MFFisher Robert · Durham, NCBuilt 2025 · S/N 10441N281SRLawyers Real Estate Services LLC · Hondo, NMBuilt 2007 · S/N 2810N282Sh1p Holdings LLC · Wichita, KSBuilt 2023 · S/N 9446N2824MDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 1144N282CBWhisky Tango LLC · Hendersonville, TNBuilt 2011 · S/N 3782N282CDAurora Partners LLC · Oregon City, ORBuilt 2004 · S/N 1136N282DJViva LLC · Dover, DEBuilt 2021 · S/N 5066N282DMSkyshoe II LLC · Beverly, MABuilt 2021 · S/N 5035N282EEFogprop N282ee LLC · Bolinas, CABuilt 2005 · S/N 1619N282THAero Sky Inc · Terrace Park, OHBuilt 2019 · S/N 4748N2834YAvance Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 4254N283DDMosier Don · Stanford, KYBuilt 2006 · S/N 1765N283SRArtemis Aviation LLC · Mondovi, WIBuilt 2007 · S/N 2682N283WTBlue Nexus LLC · Lewes, DEBuilt 2013 · S/N 3938N284CDOld Hickory Flyers · Franklin, TNBuilt 2005 · S/N 1294N284CTCirrus Design Corp · Duluth, MNS/N 11787N284LMB-Airborne LLC · Woodbine, MDBuilt 2005 · S/N 1284N285KAGtb Aviation LLC · Seattle, WABuilt 2013 · S/N 4000N285WT285wt LLC · Wilmington, DEBuilt 2019 · S/N 4847N286AKDog Island Air Inc · Wilmington, DEBuilt 2002 · S/N 0303N286BBBell Family Cirrus LLC · Louisville, KYBuilt 2022 · S/N 8919N286FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9930N287CPAlves Philip · Sandy, UTBuilt 2008 · S/N 3225N287DSCustis Cirrus Aviation LLC · Birmingham, ALS/N 2156N287THTh Aviation LLC · Savannah, GABuilt 2019 · S/N 4807N288MJRocky Ford Leasing LLC · Tallahassee, FLBuilt 2020 · S/N 4906N289EMorrison Matthew J · Waco, TXBuilt 2022 · S/N 9035N289SBHemcka Aviation LLC · Bradenton, FLBuilt 2004 · S/N 1102N28BKMooster Aviation LLC · Niceville, FLBuilt 2023 · S/N 9199N28BXBoyle Brendan C · Apex, NCBuilt 2025 · S/N 10904N28FNValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10834N28NWFixed Gear Sportsman LLC · Seattle, WABuilt 2017 · S/N 4540N28TKLos Cielos Flyers LLC · San Antonio, TXBuilt 2002 · S/N 0263N290JCirco Industries 2 LLC · Belle Chasse, LABuilt 2006 · S/N 1920N290SRAvodah Management LLC · Kalispell, MTBuilt 2006 · S/N 2276N290WABlue Yonder LLC · Paris, TNBuilt 2017 · S/N 4494N2914YBol Aero LLC · Beverly Hills, CABuilt 2004 · S/N 0859N292CDContrails Aviation LLC · Minneapolis, MNBuilt 2004 · S/N 1130N292DRDouble R Aviation LLC · Dallas, TXBuilt 2024 · S/N 10027N292SRFogle & Sons Electric LLC · Columbia, SCBuilt 2007 · S/N 2852N293LMDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 2015 · S/N 4227N293SRSykes Robert G · Hopkins, MNBuilt 2004 · S/N 0923
Back to AD 2007-24-13