OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N8727KFrosty Acres LLC · Hailey, IDS/N 340A0633N8727ZRobertson Reuben · Johnson City, TNBuilt 1968 · S/N P206-0527N87290Traverse City Helicopters LLC · Traverse City, MIS/N 310R0503N87293Dinaland Aviation · Vernal, UTS/N 310R0505N872CDOmk Freedom LLC · Los Angeles, CAS/N 0364N872TMarroquin-Rivers Diane L · Milford, DEBuilt 1965 · S/N D-7748N872WHTheologos Charles · Waveland, MSBuilt 1993 · S/N TH-1679N87316Wilson David L · Huntington, NYBuilt 1975 · S/N 310R0512N8731QHinlein Erich S · Pelham, MABuilt 1976 · S/N U20603484N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532N8733Nason David F · Kent, WABuilt 1987 · S/N CE1159N87332Odell Ronald W · Peachtree City, GABuilt 1976 · S/N 310R0516N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533N87341N87341 LLC · Milford, MIBuilt 1975 · S/N 310R0520N8734ZHardin Matthew W · Rutherford, CABuilt 1968 · S/N P206-0534N87356Kovacs Endre · Plant City, FLBuilt 1975 · S/N 310R0527N87357Qualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 310R0528N87358Braswell Eugene E III · Louisburg, NCBuilt 1975 · S/N 310R0529N8735ZMcgarity Justin D · Paragould, ARBuilt 1968 · S/N P206-0535N87363Janeair LLC · Acworth, GABuilt 1975 · S/N 310R0530N8736QCourtney Aviation LLC · Columbia, CABuilt 1976 · S/N U20603489N87389Missouri River Holdings LLC · Fairview, MTS/N 310R0541N87393310 Amigos LLC · Stuart, FLS/N 310R0542N87397Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 310R0545N873BCMedia Stew LLC · Carson City, NVS/N CE-1227N873GLShiriki LLC · Pacific Palisades, CABuilt 2014 · S/N TH-2416N873JDBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N TH-2044N873LCarbon 182 LLC · Montgomery, TXBuilt 2016 · S/N E-4097N873WHG & A Viation LLC · Miller, MOBuilt 1993 · S/N TH-1680N87403Twin Oaks Aviation LLC · Oshkosh, WIBuilt 1975 · S/N 310R0547N8740QHampton Harvey E · Simms, MTS/N U20603493N87412Rmb Leasing Inc · Dover, DEBuilt 1975 · S/N 310R0552N87429Leite Glen · King George, VABuilt 1975 · S/N 310R0557N87443Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0562N87454Burton Donald O · Mooresville, NCBuilt 1975 · S/N 310R0568N87461Cya Aviation LLC · Gainesville, FLBuilt 1975 · S/N 310R0573N87464Wells Legacy Consultants LLC · Hickory Creek, TXBuilt 1975 · S/N 310R0576N8747ZMermaid Marine LLC · Auburn, WAS/N 18502906N87481Petersen Donald W · Bullhead City, AZBuilt 1976 · S/N 310R0587N87490Starkey Tommy · Pocatello, IDS/N 310R0591N874CDEmerald Coast Pilots LLC · Panama City, FLS/N 0285N874EWKuykendall Enterprises Llp · Catoosa, OKBuilt 2025 · S/N E-4161N874WHRed Oak Aviation LLC · Sunset, LABuilt 1993 · S/N TH-1681N8750ZArge Aviation LLC · Montana City, MTBuilt 1975 · S/N 18502910N87536Krull Jesse L · Bismarck, NDBuilt 1981 · S/N 340A1254N8753ZBloated Armadillo Adventures Corp · Wilmington, DES/N P206-0553N87541Chadbourne Daniel I Jr · Anchorage, AKS/N 421C0007N8754QD2 Holdings LLC · Salt Lake City, UTBuilt 1976 · S/N U20603507N8754ZBwana Z Transporation LLC · Missoula, MTBuilt 1968 · S/N P206-0554N8755QMartensen Marten · Anchorage, AKBuilt 1976 · S/N U20603508
Back to AD 86-13-04 R3