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.

N38EPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2068N38FDCirrus Design Corp · Duluth, MNS/N 11838N38GWAircraft Partner N38gw Dst · BerlinBuilt 2004 · S/N 1015N38LZJk Hangar LLC · Green Bay, WIBuilt 2007 · S/N 2782N38MWWise Michael L · Lagrangeville, NYBuilt 2026 · S/N 11294N38WPWjjb Aviation LLC · Fountain Hills, AZBuilt 2018 · S/N 4728N391CPMkns 319cp LLC · Kalispell, MTBuilt 2008 · S/N 3072N3928BKellner Eric · Upland, CABuilt 2004 · S/N 0917N393DSRut N Strut Aviation LLC · Shelbyville, KYBuilt 2023 · S/N 9499N393GMFly Illini LLC · Indianapolis, INBuilt 2017 · S/N 4474N393JM3b Family LLC · Dover, DEBuilt 2015 · S/N 4287N394CPN394cp LLC · Pinehurst, NCBuilt 2008 · S/N 3079N394JMHigh Steaks Aviation LLC · Ragley, LABuilt 2019 · S/N 4839N394MKTtc Travel LLC · Terre Haute, INBuilt 2015 · S/N 4299N394PM394pm LLC · Ashland, VAS/N 4871N394SJFlinn Patrick R · Reeds Spring, MOBuilt 2005 · S/N 1296N394WTMorgan Edmund Neal · San Diego, CABuilt 2002 · S/N 0165N395CDSimpson Russell · Nantucket, MABuilt 2005 · S/N 1263N395CPVallencourt Jonathan Daniel · Green Cove Springs, FLBuilt 2008 · S/N 3149N395LMMj&J LLC · Dodge City, KSBuilt 2005 · S/N 1395N398MWJtde Aircraft Holdings LLC · Lebanon, OHBuilt 2013 · S/N 4010N399DDFly Flying Buffalo LLC · Dawson, GABuilt 2020 · S/N 4927N39AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 4883N39EETamburo Michael J · Adkins, TXBuilt 2011 · S/N 3775N39KCCapital Holdings 245 LLC · Newark, DEBuilt 2024 · S/N 10373N39WVLojac Air LLC · Yukon, OKBuilt 2008 · S/N 3196N3CFFlying Success LLC · Apex, NCBuilt 2025 · S/N 10580N3LWKyllar LLC · Madison, WIBuilt 2002 · S/N 0347N3YHMarsaudon David · Friday Harbor, WABuilt 2002 · S/N 0239N3ZGIsbell Tony A · Rainbow City, ALS/N 1572N400ARArh Aviation LLC · Gainesville, FLBuilt 2010 · S/N 3684N400JVAero Beach Club LLC · North Palm Beach, FLBuilt 2020 · S/N 4958N400TNSea&Air LLC · Beaufort, SCBuilt 2008 · S/N 2957N400VTValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4018N401BRBethel View Holdings LLC · Danbury, CTBuilt 2025 · S/N 10683N401MHKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2015 · S/N 4265N401TMBlue Skies Over The Creek LLC · Port Orange, FLBuilt 2026 · S/N 11389N401TTSolomon Colors Inc · Springfield, ILBuilt 2008 · S/N 2920N402CKEpok LLC · Wrightsville Beach, NCBuilt 2009 · S/N 3404N402JDMqa Aviation LLC · Newark, DES/N 3101N4031Panda Bear Aviation LLC · Dripping Springs, TXBuilt 2021 · S/N 5025N403CDSma Air LLC · Lindstrom, MNBuilt 2005 · S/N 1406N403CTCat Aviation LLC · Big Sky, MTBuilt 2004 · S/N 0973N403PTProvo Cirrus LLC · Provo, UTBuilt 2007 · S/N 2404N404BTMosaid Aviation LLC · Copperopolis, CABuilt 2024 · S/N 10258N404SGColon Aviation LLC · Greenville, SCBuilt 2021 · S/N 5036N405CDLbi Aviation Corp · Manahawkin, NJBuilt 2004 · S/N 0944N405SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2426N406CConstantine Jeffrey C · Charlotte, NCBuilt 2002 · S/N 0371N406SRPaulus Kurt W Trustee · Delaware, OHBuilt 2006 · S/N 2298
Back to AD 2007-24-13