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.

N307CPCirrus R50 LLC · Shreveport, LABuilt 2008 · S/N 3228N308CDM&R Transport LLC · Dover, DEBuilt 2004 · S/N 1026N308JJjc Air LLC · Normandy Beach, NJBuilt 2024 · S/N 10359N308LSpirit Aviation LLC · Dunedin, FLS/N 2065N309CACloud Niner LLC · Levittown, NYBuilt 2026 · S/N 11198N309CDTriangle Aviation LLC · Cary, NCBuilt 2004 · S/N 1104N309CPCirrus 497pg LLC · Scottsdale, AZBuilt 2008 · S/N 3232N309JFRozo Matthew · Chatsworth, CABuilt 2002 · S/N 0266N309LSPure Pursuit LLC · Arnold, MDBuilt 2022 · S/N 8659N309PTNelems Manufacturing LLC · Beaufort, SCBuilt 2007 · S/N 2434N309SCCalcote Derrick · Arlington, TNBuilt 2006 · S/N 2207N309SRWise Aviation LLC · Atlanta, GABuilt 2007 · S/N 2309N310ELFly Ivy LLC · Brighton, MABuilt 2024 · S/N 9795N310FLD & T Outlaw Properties LLC · Dallas, TXBuilt 2009 · S/N 3534N310JFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2485N310PPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2414N310SATailwind LLC · Cameron, NCBuilt 2019 · S/N 4812N310SMRegistration Pending · Pocatello, IDRegistration pendingS/N 2046N310TNFarfalla Aviation LLC · Santa Rosa, CABuilt 2006 · S/N 2146N310VPN310vp LLC · Galena, OHBuilt 2001 · S/N 0054N3112KBeilman Charles C · Wallingford, CTBuilt 2021 · S/N 5123N3114W865 Aviation LLC · Knoxville, TNBuilt 2021 · S/N 5117N311AVCane Associates Aviation Consultants LLC · Mount Pleasant, SCBuilt 2007 · S/N 2395N311KNViking Aircraft Leasing LLC · Bethel, MNBuilt 2009 · S/N 3440N311TDWw House Inc · Lumberton, TXBuilt 2010 · S/N 3623N312ADAltier Daniel T · Bloomfield Twp, MIBuilt 2005 · S/N 1615N312AEN312ae LLC · Seffner, FLBuilt 2019 · S/N 4783N312APAtish LLC · Hermosa Beach, CABuilt 2025 · S/N 10726N312CPSsi Mechanical LLC · San Antonio, FLBuilt 2008 · S/N 3120N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262N312FPEger Aviation LLC · Pittsburgh, PABuilt 2014 · S/N 4069N312GTKiser Consulting LLC · Atlanta, GABuilt 2022 · S/N 8920N312JBBadmia LLC · Polk City, IAFirst renewal noticeBuilt 2002 · S/N 0373N312MSGulf Of America Aviation LLC · Brookshire, TXBuilt 2023 · S/N 9185N312NGNovember Golf LLC · Shamong, NJBuilt 2015 · S/N 4274N312PXRauschenberger Ventures LLC · Chicago, ILBuilt 2021 · S/N 5014N312REBlue Jay Family Office LLC · Wilmington, DEBuilt 2025 · S/N 11073N312SRStorm Consulting Enterprises LLC · Tyler, TXBuilt 2007 · S/N 2427N313AKCirrus Design Corp · Duluth, MNS/N 11760N313DG3dg Aviation LLC · Louisville, KYBuilt 2005 · S/N 1592N313LCShort Carl R · Issaquah, WABuilt 2008 · S/N 3046N313MHHarder-Diesslin Development Group LLC · Salida, COBuilt 2010 · S/N 3619N313NRDawn Patrol LLC · Portsmouth, NHBuilt 2024 · S/N 10209N313SRTrust Your Fronts LLC · Miami, OKBuilt 2006 · S/N 1978N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237N313VBVernor Air LLC · Harbor Springs, MIBuilt 2016 · S/N 4361N31416Pterosaur Holdings LLC · Scarsdale, NYBuilt 2018 · S/N 4665N314AAlien Air LLC · Missoula, MTBuilt 2006 · S/N 2061N314CPWilbury LLC · Las Vegas, NVBuilt 2008 · S/N 3234N314DSFlyers Unlimited LLC · Tucson, AZBuilt 2005 · S/N 1705
Back to AD 2007-24-13