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.

N890FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0219N891AAAugusta Aviation Inc · Augusta, GAFirst renewal noticeBuilt 1989 · S/N LJ-1221N891FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0221N891JCAllen Chorman & Son Inc · Milton, DEBuilt 1999 · S/N T34-269N891LMn Aircraft LLC · Carolina, PRBuilt 2002 · S/N 208B0938N892BABrekke Aviation Inc · Edmore, NDBuilt 2024 · S/N 802A-1181N892FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0222N894FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0224N895BMEvergreen Flying Service Inc · Dover, DEBuilt 2008 · S/N 802A-0301N895FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0015N895LAC & L Holzwarth Inc · Virden, ILBuilt 2021 · S/N 802A-0895N895SFNorth East Ventures C LLC · Danielson, CTBuilt 1988 · S/N 208B0095N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668N896WPWestern Pilot Service Inc · League City, TXBuilt 2013 · S/N 802-0504N897FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0227N898AJNext Gen Air LLC · Colorado Springs, COBuilt 2005 · S/N 662N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255N898FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2021 · S/N 802A-0898N898SRZumwalt Aviation LLC · Sheldon, ILBuilt 2020 · S/N 802A-0865N899BAReliance Air LLC · Conway, ARBuilt 1993 · S/N LJ-1344N899FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0235N89BMMilhon Air Inc · Martinsville, INBuilt 2009 · S/N 802-0323N8FHIron Sky Capital LLC · Lubbock, TXBuilt 1997 · S/N LJ-1477N8GFVivace International Corp · San Antonio, TXBuilt 1991 · S/N 1011N8KULange Jonathan E · Seattle, WABuilt 2004 · S/N 304N8UMSkytravel Inc · Houston, TXBuilt 2001 · S/N 4697067N8YWAv Serv LLC · Dover, DEBuilt 1996 · S/N 113N9002KAerial Timber Applicators Inc · Cooperstown, NDBuilt 1999 · S/N 802-0078N9006QCrider Flying Service · Swifton, ARBuilt 1992 · S/N 502A-0190N900CTRoughneck Supply LLC · Muskogee, OKBuilt 1995 · S/N LJ-1398N900HSBizair LLC · Wilmington, DEBuilt 1996 · S/N 136N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048N900WAWright Air Service Inc · Fairbanks, AKBuilt 1998 · S/N 208B0659N900ZZ110me Inc · Lake Providence, LABuilt 1983 · S/N EA-398N901AKA C Sunni LLC · Santa Monica, CABuilt 2000 · S/N 616N901BSParaclete Aviation LLC · Raeford, NCBuilt 1968 · S/N 160N901DMCordonnier Andrew · San Diego, CABuilt 2001 · S/N 4697051N901STSky Team Aviation Inc · Wilmington, DEBuilt 1999 · S/N 208B0752N90210Robertson Crop Dusting Service Inc · South Haven, MIBuilt 1992 · S/N 402-0889N902AKDillon Aero Inc · Phoenix, AZBuilt 1988 · S/N 560N902DBBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N LJ1202N902FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0002N902MCBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 802-1107N90319Stevenson Flying Service Ll · Selden, KSBuilt 1999 · S/N 502B-0578N9032TBarts Flying Service Inc · Storm Lake, IABuilt 2000 · S/N 402A-1130N9033NJohn Georg Aerial LLC · La Crosse, KSBuilt 1999 · S/N 402A-1097N9037NOutwest Aviation LLC · Hamilton, MTBuilt 1999 · S/N 802A-0083N903FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0003N903JBigups Aviation 010 LLC · Valley Village, CABuilt 2000 · S/N FL-302N903MDMaryland Department Of Agriculture · Annapolis, MDBuilt 1968 · S/N LM-98
Back to AD 2016-05-13