AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  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.

N5064CEaton Roger C · Vernon, NYBuilt 1974 · S/N 27-7405376N5064ZGregory Trace D · Springfield, MOBuilt 1961 · S/N 22-8692N5065PVeal Ted W · Homer, AKS/N 24-71N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72N506JMAims Community College · Greeley, COBuilt 2018 · S/N 4496432N5070ZMoser Gary A · Van Wert, OHBuilt 1961 · S/N 22-8698N5071YFletchers Aviation LLC · Mason, NHS/N 27-2085N5072ZMunning Doris E Trustee · Sellersburg, INBuilt 1961 · S/N 22-8701N5074PShingledecker Robert K II · Ozark, ARBuilt 1958 · S/N 24-80N5075ZConstantine Stephen B · Anchorage, AKS/N 22-8706N5076ZBottoms Michael L · Danbury, NCS/N 22-8707N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84N5078ZPierce Justin P · Conifer, COS/N 22-8709N5079YDiaz Apolo · Kansas City, MOBuilt 1962 · S/N 27-2097N5079ZJohnson Sappa Farms LLC · Stamford, NEBuilt 1961 · S/N 22-8710N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051N5080ZBrazil Joshua B · Omaha, NEBuilt 1961 · S/N 22-8711N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099N5081ZTech Mobile LLC · New Windsor, MDBuilt 1961 · S/N 22-8712N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100N5082ZHuddleston Anthony A · Knoxville, TNBuilt 1961 · S/N 22-8713N5083ZMorell Patrick J · Byron Center, MIBuilt 1961 · S/N 22-8714N5086ZRichards Curtis A · Troy, MOBuilt 1961 · S/N 22-8718N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5088ZDavis Scott A · Bingham, NEBuilt 1961 · S/N 22-8722N5089YLewis Aaron J · Salado, TXS/N 27-2109N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102N5093ZSelby Gerald A · Sand Springs, OKBuilt 1961 · S/N 22-8727N5094ZDugan Garry P · Manvel, NDBuilt 1961 · S/N 22-8728N5097YBlackburn Anthony C · Mcdonough, GABuilt 1962 · S/N 27-2122N5098ZHanlon Ronald J · Seattle, WABuilt 1961 · S/N 22-8734N5099PSelinger Richard L · Murrieta, CABuilt 1958 · S/N 24-109N5099ZKaufold E Richard · Ridge, NYBuilt 1961 · S/N 22-8735N509GCN509gc LLC · Branford, CTS/N 27-7854086N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50GFHarrington Brian · Fountain Inn, SCBuilt 1950 · S/N 20-382N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827N50TPSoar Utah Inc · Heber City, UTS/N 25-2341N5100PHuntcliff Air Services LLC · Atlanta, GABuilt 1958 · S/N 24-105N5100ZLawrence Richard J · Wooster, OHBuilt 1961 · S/N 22-8736N5102YK F Aviation Inc · San Juan, PRBuilt 1962 · S/N 27-2127N5103Z92nd West Aviation Inc · Lonoke, ARS/N 22-8739N5104ZGary L Morton · Palmer, AKBuilt 1961 · S/N 22-8740N5105ZKrumm Melvin L · Allegan, MIBuilt 1961 · S/N 22-8741N5106ZDorsey James P · Bainbridge Island, WABuilt 1961 · S/N 22-8746N5107PStranton Air LLC · Harvard, ILS/N 24-117
Back to AD 85-02-05 R1