AD 2002-13-07

Registered aircraft · 824

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:2002-13-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-13-07')
  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.

N520TCDodson International Parts Inc · Rantoul, KSS/N 319N521CLWerner Enterprises Inc · Omaha, NEBuilt 2009 · S/N 213N521FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 68N526DJMs Falcon LLC · East Spring Valley, NYBuilt 2003 · S/N 211N527DAJory Aviation LLC · Edina, MNBuilt 2023 · S/N 406N527PJas Air LLC · New Windsor, NYBuilt 2013 · S/N 275N529KGCapstone Management LLC · Manchester, NHBuilt 2014 · S/N 292N529SGM G S Aviation Inc · Miami, FLBuilt 2011 · S/N 259N531JDRonin Tori Leasing LLC · Bloomfield Hills, MIBuilt 2007 · S/N 135N5379FN5379f LLC · Canton, OHBuilt 2002 · S/N 203N539CAResmed Inc · San Diego, CABuilt 2007 · S/N 181N53FJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 53N53LTVpc Aviation LLC · Valencia, CABuilt 2007 · S/N 108N53NJLear 100kz LLC · Burnet, TXBuilt 2002 · S/N 174N541FBank Of Utah Trustee · Salt Lake City, UTS/N 435N541ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 312N542TPLakeridge Holdings LLC · Portland, ORBuilt 2006 · S/N 089N54DRGarcia David D · Midlothian, TXS/N 94N54HGFifth Avenue Aviation LLC · Naples, FLBuilt 2004 · S/N 140N54MHTvpx Msn 390 Business Trust · North Salt Lake, UTBuilt 2022 · S/N 390N54YRPhifer Inc · Tuscaloosa, ALBuilt 2015 · S/N 300N550SHFalcon 55 LLC · West Bradenton, FLBuilt 2010 · S/N 230N550THAmc 50 LLC · Wilmington, DEBuilt 2001 · S/N 100N551ADAci Partners LLC · Ewing Township, NJBuilt 1997 · S/N 10N552GRGrp Aviation LLC · Van Nuys, CABuilt 2009 · S/N 160N553GRRivers Edge Equipment Leasing LLC · Springfield, ILBuilt 1998 · S/N 64N555CKCarroll Aviation LLC · Wilmington, DEBuilt 2003 · S/N 125N555GSInvestjet LLC · Miami, FLBuilt 2001 · S/N 149N555HGShort Hills Aviators LLC · Morristown, NJBuilt 2007 · S/N 102N555MKNgl Aviation Tul LLC · Tulsa, OKBuilt 2005 · S/N 59N5567AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 98N556KMFifty-One Air LLC · Lampasas, TXBuilt 2007 · S/N 121N558RCovenanter Investments II LLC · Nashville, TNBuilt 2025 · S/N 427N560USTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 233N570DWarbler I LLC · Freeland, MIBuilt 2016 · S/N 329N575JJTm Aircraft Leasing LLC · Wilmington, DEBuilt 2006 · S/N 163N575TCTroy Equipment Holdings LLC · Houston, TXBuilt 2014 · S/N 715N577QTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 262N57KTKlein Tools Inc · Lincolnshire, ILBuilt 2002 · S/N 110N581STOakwood Books Inc · Charlottesville, VABuilt 2016 · S/N 300N584VWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 401N588HPRbg Operations II LLC · Wilmington, DEBuilt 2015 · S/N 288N58CGCorning Inc · Corning, NYBuilt 2015 · S/N 289N58MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLBuilt 2010 · S/N 217N590CLInternational Aviation LLC · Wheeling, ILBuilt 2003 · S/N 132N595PDirect Ventures Management LLC · Knoxville, TNBuilt 2018 · S/N 741N598WCWaste Connections US Inc · Houston, TXBuilt 2016 · S/N 305N599GJLham3 LLC · Plainfield, INBuilt 2006 · S/N 83N599PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 154N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187
Back to AD 2002-13-07