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.

N60CFArq Aviation LLC · Wilmington, NCBuilt 2024 · S/N 10153N60UHSecret Destinations LLC · Gretna, LABuilt 2011 · S/N 3784N6103YQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0634N6105XKramer James W Jr · Eynon, PABuilt 2003 · S/N 0618N6106CB & S Aviation Enterprises LLC · Atlantic Beach, FLBuilt 2003 · S/N 0601N6107QKk Equipment Leasing LLC · Seguin, TXBuilt 2003 · S/N 0633N610CDChalin Flight Services LLC · Wilmington, DEBuilt 2019 · S/N 4759N611CDPj Aviation LLC · Lake Worth, FLBuilt 2005 · S/N 1599N611CTBrown Jed A · Laredo, TXBuilt 2008 · S/N 2911N611ESGs Flying Club LLC · Bethlehem, PABuilt 2008 · S/N 3053N611KGProckter Aviation LLC · Lagrangeville, NYBuilt 2005 · S/N 1551N611RMRm Management Corp · Johnson City, TNBuilt 2004 · S/N 1133N611RTGrutza Robert J · Maysville, KYBuilt 2007 · S/N 2523N611VRRex Vinod · Sunnyvale, CABuilt 2004 · S/N 0924N611WBDelicious Epiphany LLC · Fort Wayne, INBuilt 2022 · S/N 9006N612CTGl One LLC · Ankeny, IABuilt 2008 · S/N 3062N612EZCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 4734N612JMPerformance Aviation LLC · Zionsville, INBuilt 2010 · S/N 3692N612PBFord Alan · Dallas, TXS/N 3156N612WInhoc Capital Holdings LLC · Dallas, TXBuilt 2024 · S/N 10008N612XCSkiventure Holdings LLC · Wayzata, MNBuilt 2013 · S/N 4023N6133PEastwood LLC · Pikeville, KYBuilt 2003 · S/N 0639N613CMcb Consultants LLC · Camden, DEBuilt 2026 · S/N 11436N613MKFlatlands Aviation LLC · Brooklyn, NYBuilt 2016 · S/N 4400N613MMCome Fly With US LLC · Purcellville, VABuilt 2005 · S/N 1497N614CTailwinds LLC · Warsaw, INBuilt 2002 · S/N 0411N614CY614 Charlie Yankee Lc · Ames, IABuilt 2004 · S/N 1050N614EATop Joint LLC · Huntingburg, INBuilt 2023 · S/N 9591N614PAPafford Holdings LLC · Ridgeland, MSS/N 1981N614RCMacisaac Richard · Northampton, MABuilt 2002 · S/N 0249N614RZRasmusson Timothy · Elma, NYBuilt 2004 · S/N 0897N614SRForest Restoration Inc · Philomath, ORBuilt 2006 · S/N 2166N6154WBramlett LLC · Carrollton, TXBuilt 2003 · S/N 0632N615BBBmu22 LLC · Lancaster, OHBuilt 2005 · S/N 1682N615CMA Cirrus Life LLC · Santa Barbara, CABuilt 2006 · S/N 2010N615EMGinther Associates LLC · Hillsdale, NYBuilt 2010 · S/N 3682N615JPBeyer Munch Enterprises LLC · San Antonio, TXBuilt 2007 · S/N 2401N615LMPerrett Construction Ltd · Valentine, NEBuilt 2002 · S/N 0412N615MBTango Sierra LLC · Kalispell, MTBuilt 2013 · S/N 4029N615PWCardiac LLC · Amarillo, TXBuilt 2004 · S/N 1157N6162CHeller Casey · Williston, NDBuilt 2003 · S/N 0619N6162XCapital Holdings 149 LLC · Kearney, NEBuilt 2005 · S/N 1371N616ASBrozzo Ralph A · Midland, MIBuilt 2005 · S/N 1428N616CWDixie Air LLC · Russell Springs, KYBuilt 2005 · S/N 1620N616JNBatten Aviation LLC · Lancaster, OHBuilt 2011 · S/N 3770N616MB6mb Partners LLC · Burleson, TXBuilt 2009 · S/N 3493N616SPAdmiral Aviation Holdings Lp · Summerville, SCBuilt 2023 · S/N 9753N616YCirrus Design Corp · Duluth, MNS/N 11689N616ZW16 Paws LLC · Navarre, FLBuilt 2022 · S/N 5141N6171ZTennessee Valley Aviation LLC · Fayetteville, TNBuilt 2003 · S/N 0635
Back to AD 2007-24-13