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.

N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61N636KTRustair Inc · Anchorage, AKS/N 451N636QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2005 · S/N 636N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792N637LAMaxwell Flying Service Inc · Benoit, MSBuilt 2001 · S/N 502B-0637N637PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 627N637PHCapital Holdings 137 LLC · Tavernier, FLBuilt 2005 · S/N 637N639LAJ & R Flying Service LLC · Alicia, ARBuilt 2016 · S/N 802A-0639N63AWAmerican Ag Aviation Inc · Five Points, CABuilt 1998 · S/N 802A-0063N63TPHot Air LLC · Cambridge, MABuilt 1997 · S/N 128N63VAFairey Ltd · Grand Junction, COBuilt 1955 · S/N 850N640Teufel Holly Farms Inc · Portland, ORBuilt 1944 · S/N 1201N640DFWhy Not LLC · Montezuma, KSBuilt 1992 · S/N LJ-1312N640MYManatee Jet Club LLC · Bradenton, FLBuilt 2005 · S/N 640N641LALake Air Service LLC · Jennings, LABuilt 2001 · S/N 602-0641N641SMRiverside Air LLC · Shelby, MSBuilt 2023 · S/N 802A-1064N642Snow Goose Aviation LLC · Anchorage, AKBuilt 1968 · S/N 1204N642KAPatriot Ag Air LLC · Huntington, INBuilt 2012 · S/N 602-1212N642PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 642N643EAAir Adventures Corp · Charleston, SCBuilt 2001 · S/N LJ-1643N643PCRegistered aircraftBuilt 2005 · S/N 643N644SDSierra Delta LLC · Lititz, PABuilt 2005 · S/N 644N645PCValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 645N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683N649PBoutique Air Inc · Dallas, TXBuilt 2005 · S/N 649N64FFSanford Health · Sioux Falls, SDBuilt 2000 · S/N FL-308N650BGP & M Aero LLC · Belle Chasse, LABuilt 2005 · S/N 654N650DMMaroon Creek LLC · Aspen, COBuilt 1993 · S/N 85N650MCN650mc LLC · Bountiful, UTBuilt 2005 · S/N 650N650TRRichard Flying Service Inc · Rayne, LABuilt 2007 · S/N 602-1151N651PBJm Aviation LLC · Ocala, FLBuilt 2005 · S/N 651N652JWWalters Aviation LLC · Hilliard, OHBuilt 2021 · S/N 4698188N653DPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N FA-193N654FMN654fm LLC · Kalispell, MTBuilt 1980 · S/N BB-654N655MWMarvin Lumber And Cedar Company · Warroad, MNBuilt 1999 · S/N UE-377N655SCStandridge Color Corp · Social Circle, GABuilt 1999 · S/N FL-239N658LAPontiac Flying LLC · Pontiac, ILBuilt 2003 · S/N 502B-0658N658PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 658N65AFAngel Fire Express II LLC · Southlake, TXBuilt 2004 · S/N 565N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79N65MTM&M Transit LLC · Winter Park, FLS/N LA-38N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538N65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-87N65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-113N660EMBenoit Aerial Spraying Inc · Bourbonnais, ILBuilt 2021 · S/N T660-166N660KPWorsham Farms Flying Service Inc · Camilla, GAS/N T660-122DCN660MCMcguires Flying Service LLC · Obion, TNBuilt 2024 · S/N T660-185DCN660RARichter Aviation Inc · Maxwell, CABuilt 2021 · S/N T660-159N660TRTri-Rotor Spray & Chemical · Ulysses, KSBuilt 2000 · S/N T660-106N661EKGi Aviation LLC · Denver, COS/N 61
Back to AD 2016-05-13