AD 2016-05-13

Registered aircraft · 3,126

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:2016-05-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:2016-05-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.

N929KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 461N92CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0185N92JJPa1 208b-1074 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1074N92KMJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T41-175DCN92RKSnk Real Property Holdings LLC · Meta, MOBuilt 1996 · S/N LJ-1458N9304FSkydive Baltimore LLC · Lincoln, DEBuilt 1985 · S/N 20800008N930CFHynes Kevin P · Wichita Falls, TXBuilt 2016 · S/N 1157N930DSAc Aircraft Holdings LLC · Dallas, TXBuilt 1999 · S/N FL-252N930FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0030N930HMForgenie Alan Peter · Willsboro, NYBuilt 2005 · S/N 4697236N930MQGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1463N9310FPa1 208b-0490 LLC · Fort Lauderdale, FLBuilt 1995 · S/N 208B0490N9314FMission Aviation Fellowship · Nampa, IDBuilt 1985 · S/N 20800010N931FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0031N931GGPc Aviation LLC · Albany, GABuilt 1999 · S/N LJ-1572N932CRedding Aero Enterprises Inc · Redding, CABuilt 1987 · S/N 208B0032N9331BMartinaire Aviation LLC · Addison, TXBuilt 1987 · S/N 208B0055N933RTZito Aviation LLC · La Salle, COS/N BB-955N934FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0034N935AMAirmed International LLC · Birmingham, ALBuilt 1994 · S/N LJ-1356N935BDDiamond Aviation LLC · Dublin, GABuilt 1996 · S/N FL-155N935FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0035N936FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0036N937CKSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1118N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037N938BSBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 2000 · S/N FL-287N938JWMhs Airplane LLC · Augusta, GABuilt 2000 · S/N 46-97023N938SBCavu 350 LLC · Stuart, FLBuilt 1998 · S/N FL-211N939FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0180N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63N93CQNavacorp III LLC · Danbury, CTBuilt 1992 · S/N FL-89N93STZ Air LLC · Lynbrook, NYBuilt 2023 · S/N 4698272N940FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0040N941ATBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1942 · S/N 12907 (42-93040)N941LARice Flying LLC · Poplar Bluff, MOBuilt 2022 · S/N 802-0941N9421FJst Management LLC · Zephyrhills, FLS/N 20800049N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731N943FEFederal Express Corporation · Memphis, TNS/N 208B0043N943XCCircle C Aviation II LLC · Okeechobee, FLBuilt 1991 · S/N FL-60N944CWby Enterprises II LLC · Jackson, TNBuilt 2001 · S/N BB-1749N944XCMojave Jet LLC · Nolensville, TNS/N FL-281N9452BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0123N9454BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0072N9456THeritage Aviation Management Ltd · Conroe, TXS/N FM-6N9469BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0079N946FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0048N946JJBetten Equipment Leasing Inc · Grand Haven, MIBuilt 1995 · S/N 115N9471BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0081N947AMDavis Aviation Inc · Brandon, MSBuilt 1990 · S/N LJ-1238N947FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0050
Back to AD 2016-05-13