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.

N752MMMc Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 4697192N753CAMoon Mountain Montana LLC · Missoula, MTBuilt 2000 · S/N 163N753FAFarm Air Corp · Hoxie, ARBuilt 2013 · S/N 802A-0531N753FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0520N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526N754LAC & L Holzwarth Inc · Virden, ILBuilt 2018 · S/N 802A-0770N755DMMdst Aircraft Leasing LLC · Ripon, WIBuilt 1994 · S/N 101N755EMSea Star Inc · Wetumpka, ALBuilt 2005 · S/N 661N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316N758LALowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 802A-1103N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75N75MSDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LA204N75PGDasch Air LLC · Alamo, CABuilt 1995 · S/N LJ-1390N75ZDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-61N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462N761CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1994 · S/N 760410N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262N767TPNuage Holdings LLC · Sioux Falls, SDBuilt 2001 · S/N 4697036N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263N768SXRentco LLC · Deer Park, TXFirst renewal noticeBuilt 1991 · S/N 760372N769FXFederal Express Corp · Memphis, TNBuilt 2024 · S/N 408-0030N769JSSpurlock Benjamin · Eugene, ORBuilt 2001 · S/N 187N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355N76DNFastboy Equipment LLC · Beasley, TXS/N 760351N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498N76KAKenmore Air Harbor LLC · Kenmore, WABuilt 1958 · S/N 300N76MGCook Brothers Farms LLC · Princeton, KYBuilt 2001 · S/N 4697056N76PM2012 Leasing Inc · Saint Paul, MNBuilt 1998 · S/N FL-200N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15N770DCRam Aviation LLC · Alexandria, LABuilt 2000 · S/N 183N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265N770FLTailwinds Aviation LLC · Wilmington, DEBuilt 2003 · S/N 501N770VFGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1641N771MGEaglemed LLC · Wichita, KSBuilt 1998 · S/N BB-1636N772AAPro-Air LLC · Alexandria, LABuilt 2004 · S/N 502B-0691N772HPWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N FL-262N772JBJsb Aviation LLC · Wichita Falls, TXBuilt 2001 · S/N LJ-1652
Back to AD 2016-05-13