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.

N6CDAviator One LLC · Holly Springs, NCBuilt 2001 · S/N 0037N6MPTilt Up Air LLC · Middleboro, MABuilt 2017 · S/N 4497N7007VTurk James H · Mesa, AZBuilt 2001 · S/N 0082N700FCSandlapper Aviation Of De Inc · Bennington, VTS/N 1986N700HGAerosphere LLC · Cedar City, UTBuilt 2005 · S/N 1506N700PGoree John A · Iowa City, IABuilt 2004 · S/N 0791N701BTVgfs Aviation LLC · Naples, FLBuilt 2020 · S/N 4959N701CDQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 0006N701MBBoot Keith Jason · Des Moines, IABuilt 2012 · S/N 3859N701PMJedi Flight Training LLC · Boerne, TXBuilt 2001 · S/N 0007N701SGMach Aviation LLC · Ocklawaha, FLBuilt 2004 · S/N 0963N702DSYaviation LLC · Burns, TNBuilt 2004 · S/N 0989N702FCFlight Inc · Concord, NCBuilt 2001 · S/N 0018N702GYCirrusly LLC · Las Vegas, NVBuilt 2024 · S/N 10095N703DRMilligan Holdings LLC · Medford, ORBuilt 2015 · S/N 4166N703RGEfficiency LLC · Helena, MTBuilt 2020 · S/N 4952N703TECirrus Design Corp · Knoxville, TNBuilt 2019 · S/N 4740N704DRCactus Aviation LLC · Phoenix, AZBuilt 2011 · S/N 3786N704GMLocke Stephen G · Charlotte, NCBuilt 2023 · S/N 9594N704NEArian Air LLC · Cambridge, MABuilt 2004 · S/N 1016N704RBravo Fox Squared LLC · Lincoln, NEBuilt 2006 · S/N 2147N705CMtm Investments LLC · Goshen, INBuilt 2002 · S/N 0418N705CCPappa Mike Holdings LLC · Rayville, LABuilt 2016 · S/N 4350N705CDLearjetjohn Flying Club LLC · Moulton, ALS/N 0005N705SAVisser Stephen Barney · Lakewood, COBuilt 2007 · S/N 2668N707AZColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2022 · S/N 8614N707GGLiberty Flight LLC · Goshen, NYBuilt 2006 · S/N 2251N707SWNep Air LLC · Vineland, NJBuilt 2025 · S/N 10889N707TDWhite Plains Enterprise LLC · Kalispell, MTBuilt 2005 · S/N 1363N707THFly Boys LLC · Lincoln, NEBuilt 2003 · S/N 0707N708CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3076N708CTWilliam Polk Medical LLC · Nashville, TNBuilt 2009 · S/N 3466N708ESWisconsin Aviation Inc · Watertown, WIBuilt 2006 · S/N 1856N708RWBanks Wes J · Oakdale, CABuilt 2003 · S/N 0514N709ARIantosca Real Estate Inc · Jamaica Plain, MABuilt 2021 · S/N 5026N709CDTurton Enterprises Co · Wilmington, DEBuilt 2001 · S/N 0029N709FAFlyward LLC · Cockeysville, MDBuilt 2010 · S/N 3643N709KMTuffy LLC · Jacksonville, ORBuilt 2009 · S/N 3456N70BHWls 1000 LLC · Tulsa, OKBuilt 2023 · S/N 9638N70DECirrus Sr22 4452 Inc Trustee · Wilmington, DEBuilt 2017 · S/N 4452N70MWN70mw LLC · Saint Joseph, MOBuilt 2004 · S/N 1188N710CDHeidtke Trent · Fountain Hills, AZBuilt 2001 · S/N 0013N710CUNodak Aero LLC · Grand Forks, NDBuilt 2017 · S/N 4440N710KTBradshaw Jeffrey T · Clearwater, FLBuilt 2005 · S/N 1347N710LMValiair Lc Trustee · Casper, WYBuilt 2023 · S/N 9511N710NDLeaning Tree Equipment Mgmt LLC · Jacksonville Beach, FLFirst renewal noticeBuilt 2008 · S/N 3337N710PCCirrusly Aviation LLC · Natchez, MSBuilt 2003 · S/N 0754N710PGOss Auto LLC · Mcallen, TXBuilt 2024 · S/N 9903N711CGOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2004 · S/N 1135N711FFM S Aviation LLC · Charlotte, NCBuilt 2019 · S/N 4809
Back to AD 2007-24-13