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.

N553CDMhz Management LLC · Wilmington, DEBuilt 2005 · S/N 1638N553LBLive Big Air LLC · Athens, GABuilt 2015 · S/N 4242N554MCWilliams Michael · Fort Wayne, INBuilt 2006 · S/N 2057N554UTC172 LLC · Rogers, ARBuilt 2022 · S/N 9014N555AVUpslope Aviation LLC · Boulder, COBuilt 2004 · S/N 0990N555CBEnyedi Alexander Joseph · Plattsburgh, NYBuilt 2011 · S/N 3729N555JPMina Mach Partners LLC · Sioux Falls, SDBuilt 2004 · S/N 0970N555KPSkyline Aviation LLC · Sheridan, WYBuilt 2025 · S/N 11096N555MNThomas David R · Apex, NCBuilt 2003 · S/N 0664N555SBAvia Blue LLC · Emerald Hills, CABuilt 2019 · S/N 4765N555TLTta Holdings LLC · Dublin, GABuilt 2020 · S/N 4970N555VGCordingley Robert · Lafayette, COBuilt 2010 · S/N 3701N555ZGJeminn LLC · Scottsdale, AZBuilt 2004 · S/N 1116N5567JVision Aeronautics LLC · Dequincy, LABuilt 2016 · S/N 4424N556CDSec Ventures LLC · St Charles, ILBuilt 2004 · S/N 1033N556CESt Patrick Reserves LLC · St Louis, MOBuilt 2010 · S/N 3653N556GGCapital Group Logistics LLC · Tallahassee, FLBuilt 2024 · S/N 10139N556LInternational Air Services Inc Trustee · Carson City, NVS/N 0132N556PLSerenity Skies LLC · West Chester, PABuilt 2023 · S/N 9388N556SROhaver Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2856N557CACci Air LLC · Dell Rapids, SDBuilt 2005 · S/N 1594N557CCRedhawk Aviation LLC · Mccomb, MSBuilt 2023 · S/N 9557N558ATSkywalker Aviation LLC · Jacksonville, FLBuilt 2020 · S/N 4915N558CDSr Global Partners LLC · Laguna Beach, CABuilt 2005 · S/N 1414N558PGConverting Solutions Inc · Maiden, NCBuilt 2008 · S/N 3024N558SRAllenergy Aircraft LLC · Trego, WIBuilt 2006 · S/N 2193N559ACRebel Air LLC · Oxford, MSBuilt 2006 · S/N 1927N559MMScience Brew LLC · Kenosha, WIBuilt 2002 · S/N 0349N559SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 2875N55CTFly 55 LLC · Winter Springs, FLBuilt 2023 · S/N 9193N55GYArrokoth LLC · Virginia Beach, VABuilt 2018 · S/N 4684N55KSPerlan LLC · Melbourne, FLBuilt 2003 · S/N 0550N55RJAlamogordo Rental Company LLC · Alamogordo, NMBuilt 2008 · S/N 3202N55WTCirrus Design Corp · Duluth, MNS/N 11685N55WVN728bj Aviation LLC · Barker, TXBuilt 2020 · S/N 4964N560CDKlohn Volker · Houston, TXBuilt 2005 · S/N 1644N560SR40 And Rising Aviation LLC · Memphis, TNBuilt 2007 · S/N 2615N561AUIflysims Aviation Inc · Las Vegas, NVBuilt 2026 · S/N 11289N561CDGainesville Aircraft Sales Inc · Gainesville, FLS/N 1640N561CP3809 Kilo LLC · Wilmington, DEBuilt 2008 · S/N 3331N561SSws Air LLC · Palm Beach Gardens, FLBuilt 2020 · S/N 4917N562CDFeldman Thomas · Renton, WABuilt 2004 · S/N 1198N562FDCapital Aviation LLC · South Easton, MABuilt 2025 · S/N 10562N562PGQualitair LLC Trustee · MichelstadtS/N 0562N562SDWarren-Williams LLC · Philadelphia, PABuilt 2024 · S/N 10383N563CDEl Paso Aero Inc · El Paso, TXBuilt 2004 · S/N 1182N563CP5teevee LLC · La Grande, ORBuilt 2008 · S/N 3333N563MMMegel Air LLC · Cleveland, GAS/N 1938N563PGKureishy Zaveen A · Triadelphia, WVBuilt 2001 · S/N 0033N563RFHjc Aircraft LLC · Pleasant Valley, IABuilt 2023 · S/N 9563
Back to AD 2007-24-13