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.

N734CDJds Aviation LLC · San Mateo, CABuilt 2005 · S/N 1686N736CPSpivak Maxim Trustee · San Jose, CABuilt 2009 · S/N 3347N736SRGlobal Horizon Investments LLC · Flower Mound, TXBuilt 2007 · S/N 2563N736WFWarner Chad · Gualala, CABuilt 2016 · S/N 4334N73ARStay In Your Plane LLC · Austin, TXBuilt 2021 · S/N 5114N73BPRealty Trust LLC · Southbridge, MABuilt 2015 · S/N 4172N73CCBoomer4 Aviation LLC · Cincinnati, OHBuilt 2017 · S/N 4554N73JQZam Air LLC · Wilmington, DEBuilt 2006 · S/N 2039N73WESchroeder Andrew R · Hoover, ALS/N 4196N73WFSky Park Drive LLC · Custer, SDBuilt 2006 · S/N 1816N73WKCapital Holdings 251 LLC · Newark, DEBuilt 2025 · S/N 10864N73WTBa Cane Aviation LLC · Weston, FLBuilt 2005 · S/N 1387N740CD429 Aviation LLC · Dallas, TXBuilt 2007 · S/N 2336N740NGDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 2032N741SCKaczorowski Michael T · Reisterstown, MDBuilt 2002 · S/N 0213N742CCCirrus Design Corp · Duluth, MNS/N 11840N742DDPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 1108N742JHWatson David P · Pottsboro, TXBuilt 2006 · S/N 1963N742LCN742lc LLC · Maryville, TNBuilt 2015 · S/N 4281N742LGGln Executive Aviation LLC · Powell, OHBuilt 2020 · S/N 4974N742SCMissouri First Aviation Inc · Lebanon, MOBuilt 2008 · S/N 3137N743CDHerrington James C Jr · Mullins, SCBuilt 2002 · S/N 0140N743GMDym Flights LLC · Pembroke Pines, FLBuilt 2022 · S/N 8961N743NXVolare III LLC · Harlingen, TXBuilt 2016 · S/N 4369N744CDCirrus Drivers Zoom LLC · Folsom, CABuilt 2001 · S/N 0024N744MSSierra Foothill Properties LLC · Auburn, CABuilt 2002 · S/N 0204N744SMDodson International Parts Inc · Rantoul, KSBuilt 2017 · S/N 4581N744TCGottesman David · Petaluma, CABuilt 2010 · S/N 3640N745ARLlv Aviation LLC · Naples, FLBuilt 2006 · S/N 2131N745CDTrujillo Dax K · Show Low, AZS/N 0040N745NBT & H Ahrens LLC · Nevada City, CABuilt 2006 · S/N 1891N746ABCitation Point Leasing LLC · Naples, FLS/N 4737N746CBr Aviation LLC · Bellevue, WABuilt 2002 · S/N 0413N746CDSky West Aviation Inc Trustee · Albuquerque, NMS/N 0074N746JAInternational Air Services Inc Trustee · Carson City, NVBuilt 2016 · S/N 4375N746SRGossett John · Bellbrook, OHBuilt 2006 · S/N 2235N7478Hubbard Matthew L · Phoenix, AZBuilt 2002 · S/N 0420N747ASRooks Peter L · Andover, MABuilt 2022 · S/N 8998N747CTN747ct LLC · Mayfield, KYBuilt 2017 · S/N 4485N747LJEichleay Peter · Yarmouth, MES/N 0535N747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 0496N747MBMaitland Egerton M Jr Dr · Lexington, SCBuilt 2008 · S/N 2913N747PJOsprey Capital LLC · Winston Salem, NCBuilt 2005 · S/N 1483N747PLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2289N747SDAvitrans Inc · Cypress, CABuilt 2006 · S/N 2245N747SJBuell Steven M · Fisherville, KYBuilt 2001 · S/N 0091N747SWJet Air Inc · Iowa City, IAS/N 1370N747TGValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N 0718N747TTDogbolter Aviation LLC · Milwaukee, WIBuilt 2003 · S/N 0481N748CDPinkgg LLC · Marathon, FLBuilt 2001 · S/N 0086
Back to AD 2007-24-13