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.

N2659BAnderson Brian E · York, PABuilt 2002 · S/N 0237N265JPN265jp LLC · Mill Valley, CABuilt 2004 · S/N 0888N265MBFlying Brick LLC · Monroe, NCBuilt 2024 · S/N 10163N266KPN266kp LLC · Cincinnati, OHBuilt 2023 · S/N 9386N266SRRf Aviation LLC · Eaton, COBuilt 2007 · S/N 2626N267CPVanesian Bryan Dean · Apple Valley, CABuilt 2008 · S/N 3047N267PKRegistration Pending · Summerville, GARegistration pendingBuilt 2014 · S/N 4156N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436N268SRCirrus Design Corp · Duluth, MNBuilt 2007 · S/N 2334N269JMPatterson Larry Jay · San Angelo, TXBuilt 2008 · S/N 3231N26BZNorthcutt Chevrolet Buick LLC · Enid, OKBuilt 2014 · S/N 4033N26DPColibri Ventures LLC · Dorado, PRBuilt 2021 · S/N 5138N26MWMike Whiskey LLC · Atlanta, GABuilt 2026 · S/N 11187N26VSBoss Aviation LLC · Douglas, AZBuilt 2009 · S/N 3585N26WRiddle Jay Allen · Gainesville, FLBuilt 2020 · S/N 4905N26WMSportcruiser LLC · Wilmington, DEBuilt 2021 · S/N 5002N2704SC&M Asset Management LLC · Owasso, OKBuilt 2005 · S/N 1265N270ARDuffy Kevin · Manchester Center, VTBuilt 2024 · S/N 10138N270MWM9 Aviation Ventures LLC · Philadelphia, PABuilt 2003 · S/N 0735N270WL270wl Aviation LLC · Owensboro, KYBuilt 2023 · S/N 9567N2714CLipcon James P · Stow, MABuilt 2005 · S/N 1393N271NPJust Plane Stuff Inc · Jackson, MSBuilt 2024 · S/N 10043N271SRGriffin James R · Pinedale, WYBuilt 2007 · S/N 2714N272CDSegers Ernst E · Pensacola, FLBuilt 2010 · S/N 3541N272DDelta Delta Aviation LLC · Pickerington, OHBuilt 2021 · S/N 5095N272RHLewis Coleman · Dallas, TXBuilt 2008 · S/N 3054N273DVD&K LLC · Sioux Falls, SDBuilt 2013 · S/N 4024N273ESTailwinds Aviation LLC · Windham, NHBuilt 2005 · S/N 1609N273NFTrk Management LLC · Punta Gorda, FLBuilt 2016 · S/N 4407N273RVMev Aviation LLC · Fort Lauderdale, FLBuilt 2021 · S/N 5001N274EFFour Forces Aviation LLC · Princeton, NJBuilt 2024 · S/N 10198N274SRTn Sr22 LLC · Farragut, TNBuilt 2007 · S/N 2732N275ABR2box LLC · Dover, DEBuilt 2021 · S/N 5112N2763Valiair Lc Trustee · Casper, WYBuilt 2007 · S/N 2859N276CDGandia Justin Kidd · Chicago, ILBuilt 2005 · S/N 1385N276CPRothlisberger Ben · Farmington, MOBuilt 2008 · S/N 3243N276GEMaricorp U S LLC · Shell Knob, MOBuilt 2014 · S/N 4150N277JDMeadows Construction Corp · Fort Smith, ARBuilt 2008 · S/N 3256N277RRossignoli Holdings LLC · Atlanta, GABuilt 2025 · S/N 11100N278CDCirrus Aviators LLC · Elm Grove, WIBuilt 2002 · S/N 0337N278GZNichols Industrial Construction Co Inc · Birmingham, ALBuilt 2023 · S/N 9535N278JAAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 5037N278SREllsworth Farm LLC · Kingsbury, NYBuilt 2007 · S/N 2419N278WDSnk LLC · Reisterstown, MDBuilt 2011 · S/N 3825N279CPBarnard Henry H III · Albany, GABuilt 2008 · S/N 3221N279MTGmcm Aviation LLC · Central, SCBuilt 2007 · S/N 2470N27EMStair Colin · Brookfield, WIBuilt 2006 · S/N 1798N27FDCirrus Design Corp · Duluth, MNS/N 11839N27LGStilda One LLC · Fort Loramie, OHBuilt 2008 · S/N 3052N27PFNorthstar Global Flight LLC · Bronxville, NYBuilt 2024 · S/N 9982
Back to AD 2007-24-13