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.

N733CHAcc Integrated Services Inc · Milwaukee, WIBuilt 1987 · S/N SH-3733N733PBw69 Air LLC · Fort Walton Beach, FLBuilt 2001 · S/N 4697052N734CBGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1508N736WDCassil Robert B Trustee · San Francisco, CABuilt 2005 · S/N 20800392N73PGFirst Financial Bankshares Inc · Abilene, TXBuilt 2000 · S/N LJ-1607N73RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 110413N73RFRandigo LLC · Wilmington, DEBuilt 1991 · S/N 208B0289N73WCWest Coast Aircraft Sales LLC · Santa Ana, CABuilt 1996 · S/N FL-135N740FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0484N740LALissie Flying Service Inc · Lissie, TXBuilt 2018 · S/N 802A-0780N741FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0486N741WCLynchburg Shipyard Inc · Highlands, TXBuilt 2011 · S/N FL-741N744FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0492N744MAOctane Addiction Aviation Inc · Augusta, GABuilt 2005 · S/N 46020073N745EALaurel Road Properties LLC · Morehead City, NCBuilt 2001 · S/N BB-1745N745FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0495N745LAKlein Flying Service Inc · Lawrenceville, ILBuilt 2018 · S/N 802A-0745N746FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0498N746LAAnderson Farming Co · East Bernard, TXBuilt 2020 · S/N 802A-0828N747FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0238N747FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0501N748FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0241N748FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0503N749FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0242N74GCDiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 559N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559N74KSR & R Pallet Of Garden City · Garden City, KSBuilt 2000 · S/N FL-299N74RFAir Flair Inc · Maurice, IABuilt 1983 · S/N 425-0153N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10N7500SHill Ag-Air LLC · Bancroft, IDS/N 829BN75090Gasper Air Spray Inc · Crookston, MNBuilt 1992 · S/N 831BN7509VRichard Flying Service Inc · Rayne, LABuilt 1991 · S/N 828BN7509YAnderson'S Flying Service Inc · Yuba City, CABuilt 1992 · S/N 830BN750ABNpa Aviation LLC · Lafayette, LABuilt 1991 · S/N 4N750DZBranded X LLC · Springfield, ORBuilt 2004 · S/N 108N750FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0511N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224N750KPAircraft Structures International Corp · Enid, OKBuilt 1997 · S/N 208B0628N750LAWestwind Air LLC · Lake Village, ARBuilt 2022 · S/N 802A-0995N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640N750SDSkydive Coolidge Inc · Tempe, AZBuilt 2004 · S/N 111N750SSPacair LLC · Brookline, NHBuilt 2005 · S/N 115N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215N750XLArne Aviation LLC · Suffolk, VABuilt 2004 · S/N 109N750ZSouthern Airways Pacific LLC · Addison, TXBuilt 2004 · S/N 208B1054N751FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0245N751FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0514N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887N752FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0247N752FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0517
Back to AD 2016-05-13