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.

N724CMParker Air LLC · Mobile, ALBuilt 2005 · S/N 1557N724DEAero Air LLC · Hillsboro, ORBuilt 2004 · S/N 1140N724SRFlyme2 LLC · Leesburg, VABuilt 2006 · S/N 2167N725AAMoon Flying LLC · Centreville, VABuilt 2025 · S/N 10669N725CDRussell Wade M Jr · Sandy Springs, GABuilt 2001 · S/N 0071N725CPHolmberg Bryan J · Parkland, FLBuilt 2008 · S/N 3352N725EBHickory Falls LLC · Naperville, ILBuilt 2016 · S/N 4333N725LKDuluth Aviators LLC · Duluth, MNBuilt 2003 · S/N 0668N725WTJ&E Adventures LLC · Conroe, TXBuilt 2024 · S/N 10099N726CCStk Flight LLC · New Palestine, INBuilt 2006 · S/N 1848N726KRE&E LLC · Johnston, IABuilt 2018 · S/N 4592N726PBN411b LLC · Griffin, GABuilt 2017 · S/N 4551N726PDBuchanan Thomas Steven · Hilton Head Island, SCBuilt 2022 · S/N 8529N726PMAlpine View LLC · Williston, NDBuilt 2004 · S/N 0981N726ZMission Park Air LLC · Marion, IABuilt 2016 · S/N 4357N727CDN727cd LLC · Clearwater, FLBuilt 2001 · S/N 0021N727HGShirin Aviation LLC · Los Angeles, CABuilt 2017 · S/N 4489N727JKSky 21 LLC · Lexington, NCBuilt 2020 · S/N 4926N727PWSteven Bennett Trustee · Boise, IDBuilt 2004 · S/N 1196N727SPinnacle Aviation Services LLC · Key Largo, FLS/N 1316N727SLRegistered aircraftBuilt 2006 · S/N 1773N727SRMid-Way Regional 2023 LLC · Columbia Falls, MTBuilt 2007 · S/N 2613N728BJBarefoot Boats LLC · Greensboro, GABuilt 2016 · S/N 4320N728SRSouthside Tire Co Inc · Antigo, WIBuilt 2007 · S/N 2546N729AJEdwards 729aj LLC · Dublin, OHBuilt 2015 · S/N 4208N729CDOmega Skyways LLC · North Bethesda, MDBuilt 2001 · S/N 0025N729JRJbj Air Services LLC · Virginia Beach, VABuilt 2007 · S/N 2344N729JSJackson Christopher F · Vancouver, WABuilt 2004 · S/N 0819N729SASierra Alpha Leasing LLC · Naples, FLFirst renewal noticeBuilt 2020 · S/N 4890N72BKUpper Airways LLC · Kalispell, MTBuilt 2002 · S/N 0172N72DVStirling Motors LLC · Kalispell, MTBuilt 2006 · S/N 2144N72ETCirrwest Ltd · Grand Junction, COBuilt 2007 · S/N 2522N72GGHall Joel · Nashville, TNBuilt 2007 · S/N 2328N72JESkyward LLC · Fort Smith, ARBuilt 2005 · S/N 1654N72LLKusy LLC · New Rochelle, NYBuilt 2018 · S/N 4633N72MJValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10652N730CN730c LLC · Merrimack, NHS/N 0410N730CDCirrus Associates LLC · Colorado Springs, COS/N 0053N7311KChunga Air LLC · Orange Park, FLBuilt 2014 · S/N 4125N731APEastway Properties LLC · Moxee, WABuilt 2009 · S/N 3566N731ATMark L Carman · Aiken, SCBuilt 2005 · S/N 1728N731CDOwen Brian F · Tulsa, OKBuilt 2001 · S/N 0129N731JHGcl Juliet Hotel LLC · Winter Springs, FLBuilt 2021 · S/N 5027N731PPPoli Poli Inc · Sausalito, CABuilt 2012 · S/N 3829N731VCCuster Joseph A Jr · League City, TXBuilt 2023 · S/N 9529N731WF29 Aviation LLC · Granite Falls, MNBuilt 2016 · S/N 4421N732ABJohn L Dolan Consulting LLC · Vienna, VABuilt 2018 · S/N 4615N732CDK9 Aviation LLC · Tyler, TXBuilt 2005 · S/N 1685N732SGSorrydog Aviation LLC · Bushnell, FLBuilt 2023 · S/N 9294N733CDHerron Kevin · Checotah, OKFirst renewal noticeBuilt 2001 · S/N 0134
Back to AD 2007-24-13