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.

N587DGLsm Aviation LLC · Rome, GABuilt 2011 · S/N 3745N588CTLynn Johnny Wayne · Indian Trail, NCBuilt 2008 · S/N 3207N588SRSojo Air LLC · Abilene, TXBuilt 2007 · S/N 2351N589CTNorton Vickie R · Huntington Beach, CABuilt 2008 · S/N 3203N589RCSkyflite LLC · Hillsboro, ORBuilt 2004 · S/N 0871N589SRBe Happy LLC · Nashua, NHBuilt 2006 · S/N 2273N58ACAlto Cirrus LLC · Coral Gables, FLBuilt 2021 · S/N 5040N5907Summit Aviation Group LLC · Monument, COBuilt 2007 · S/N 2388N590CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0957N591CDac-2020 Inc · Skaneateles, NYBuilt 2002 · S/N 0439N591SCSrc22 LLC · Costa Mesa, CABuilt 2017 · S/N 4511N591WATv Trucks LLC · Eufaula, ALBuilt 2006 · S/N 2110N592TGCirrus Design Corp · Duluth, MNS/N 11738N593GREji Services LLC · Cairo, GABuilt 2014 · S/N 4149N593MCChaffin Mark Bernard · Massillon, OHBuilt 2019 · S/N 4864N593MRCirrus Design Corp · Duluth, MNS/N 11766N593MWWalsh Michael E · Cabot, PABuilt 2021 · S/N 5111N5953Air Traders LLC · Fayetteville, ARBuilt 2003 · S/N 0641N595ASCowan Andrew T · Lucas, TXBuilt 2004 · S/N 1105N595CDRhodes Matthew P · Indianapolis, INBuilt 2006 · S/N 1761N595JMSkedaddle Air Corp · Lincoln, MABuilt 2003 · S/N 0706N595MWJta Aviation LLC · Lafayette, LABuilt 2016 · S/N 4359N595SRK C Cirrus LLC · Harrisburg, PABuilt 2007 · S/N 2449N595TVGephart Dan R · West Lafayette, INBuilt 2003 · S/N 0485N595WPWhiskey Papa LLC · Baton Rouge, LAS/N 1993N596ACM&L Properties Of Alexandria LLC · Alexandria, LABuilt 2015 · S/N 4245N596CDBlue Developments LLC · Wilmington, DEBuilt 2005 · S/N 1710N596CPFog Crow LLC · Austin, TXBuilt 2008 · S/N 3357N596SRJ & J Flyers LLC · Jaffrey, NHBuilt 2007 · S/N 2795N596WSCarevest Aviation LLC · Gloucester, MABuilt 2006 · S/N 2056N597CDGarnreiter Michael Trustee · Silverado, CABuilt 2005 · S/N 1532N597SRLowry Flying Service Inc · Grinnell, IABuilt 2006 · S/N 2023N598CDKabaet Aviation Charter LLC · Tarrytown, NYBuilt 2005 · S/N 1653N598SRLowcountry Airborne LLC · St Helena Is, SCBuilt 2006 · S/N 2045N599BCMilensky Chester D · Oviedo, FLBuilt 2014 · S/N 4037N599MGN599mg LLC · Boulder, COBuilt 2007 · S/N 2762N599MRPuder Craig Louis · Kansas City, MOBuilt 2010 · S/N 3655N599PMCirrus Maximus LLC · Pasadena, CABuilt 2004 · S/N 1246N59FESolomon Mark Trustee · Wilmington, DEBuilt 2011 · S/N 3810N59JMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11543N59NHCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10909N59PBPink Bubbles Air LLC · Marblehead, MABuilt 2024 · S/N 10076N59PXWaypoint Aviation Group LLC · Lenoir City, TNBuilt 2007 · S/N 2576N59SBLearson LLC · Tarpon Springs, FLBuilt 2002 · S/N 0196N5DSCirrus Flying Professionals LLC · Hollywood, FLBuilt 2016 · S/N 4321N5KMB & B Aviation LLC · Vineyard, UTBuilt 2003 · S/N 0458N5MKTysam Aero LLC · Graford, TXBuilt 2002 · S/N 0329N5PVBlack Hills Aviation LLC · Saint Cloud, MNBuilt 2010 · S/N 3469N5XNHuddart Martin · Farmington, CTBuilt 2006 · S/N 1975N60034Jpb Holdings Inc · Kalispell, MTBuilt 2003 · S/N 0596
Back to AD 2007-24-13