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.

N41MBRivers Equipment LLC · Nashville, TNBuilt 1998 · S/N 32N420CCCooke & Cooke Air LLC · Nashville, TNBuilt 1996 · S/N 40N420PDKms Air LLC · West Bend, WIBuilt 2001 · S/N 84N421SCStryker Corp · Portage, MIBuilt 2016 · S/N 331N422FJHca Squared LLC · Nashville, TNBuilt 2025 · S/N 429N424UAeronavis LLC · Wilmington, DEBuilt 2002 · S/N 105N425RJFant Aircraft Enterprises LLC · Houston, TXBuilt 2014 · S/N 285N427MJ427mj LLC · Hazel Crest, ILBuilt 2013 · S/N 717N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154N428FJDassault Falcon Jet Corp · Little Ferry, NJBuilt 2025 · S/N 428N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20N42NFCest La Vie LLC · Piedmont, OKBuilt 1997 · S/N 12N42STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 39N431JABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 602N435JFJf Aircraft LLC · Detroit, MIBuilt 1997 · S/N 47N436CJet Coordination LLC · Saint Paul, MNBuilt 2018 · S/N 343N437JDAgrilease LLC · West Des Moines, IABuilt 2008 · S/N 166N43RTRegistered aircraftBuilt 2023 · S/N 409N440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 85N449SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 171N44DNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 122N44JCJm Cox Resources Lp · Midland, TXBuilt 2018 · S/N 349N44VPGable S Corp · West Linn, ORBuilt 2002 · S/N 115N453SBSierra Bravo Graco Inc · Emigrant, MTBuilt 1999 · S/N 97N454DPSkyview LLC · Wilmington, DES/N 130N454GBMarvin Leasing LLC · New Hope, MNBuilt 2013 · S/N 266N45EGApex Air LLC · Greenwood, INBuilt 1996 · S/N 27N45PKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 344N45RTRegistered aircraftBuilt 2021 · S/N 385N460SJDarby Holdings II LLC · Baltimore, MDBuilt 2008 · S/N 168N463AKFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 162N465RDMagnum 465rd LLC · Las Vegas, NVBuilt 2024 · S/N 420N466JCBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 324N468AMAmc 50 LLC · Chicago, ILS/N 074N469SSDeez-Nuts LLC · Goodlettsville, TNBuilt 1998 · S/N 27N46ERegistered aircraftBuilt 2013 · S/N 261N46FRegistered aircraftBuilt 2011 · S/N 238N46HADjt Equipment LLC · Cocoa Beach, FLBuilt 1999 · S/N 91N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206N46RBaci LLC · Portland, ORBuilt 2014 · S/N 284N470MKBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 146N472KChoice Hotels International Services Corp · Rockville, MDBuilt 2008 · S/N 603N47EGWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2018 · S/N 312N47VWG 137 LLC · Wilmington, DEBuilt 2008 · S/N 148N480ECRegistered aircraftBuilt 2019 · S/N 362N481FLIfl Group Inc · Waterford, MIBuilt 1966 · S/N 27N482ECConstellation Energy Generation LLC · New Castle, DEBuilt 2020 · S/N 371N483CMAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2026 · S/N 434N483ECRegistered aircraftBuilt 2020 · S/N 374N4840WGolden Ben Air LLC · Nashville, TNBuilt 2006 · S/N 228
Back to AD 2002-13-07