OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N5554XDellechiaie Anthony J · Mahwah, NJBuilt 1990 · S/N CE-1457N5555GSinton Frank J · Durango, COBuilt 1975 · S/N 21061039N5555SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000417N555AVUpslope Aviation LLC · Boulder, COBuilt 2004 · S/N 0990N555BCHammett Michael James · Hattiesburg, MSBuilt 1966 · S/N D-8341N555CDBoyd Robert T · Quakertown, PAFirst renewal noticeBuilt 1975 · S/N 18502656N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555DBSira Arashpal Singh · Lakewood, CABuilt 1978 · S/N CE-803N555HCWikle Leon · Rapid City, SDBuilt 1979 · S/N E-1586N555JDMike Bravo LLC · Chicago, ILBuilt 1979 · S/N 310R1629N555JPMina Mach Partners LLC · Sioux Falls, SDBuilt 2004 · S/N 0970N555KMVerrill Christopher R · Williamstown, NJBuilt 1966 · S/N D-8361N555LFMadden Todd A · Houston, TXBuilt 1979 · S/N D-10270N555LMGrey Sky LLC · Bossier City, LABuilt 1999 · S/N 30-0009N555LTHogan Daniel · Salina, KSBuilt 1975 · S/N E-737N555MGHampshire Blue Skies LLC · Bedford, NHBuilt 1987 · S/N E-2391N555MNThomas David R · Apex, NCBuilt 2003 · S/N 0664N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886N555NGPattillo Jon S · Spotsylvania, VABuilt 1949 · S/N NAV-4-1829N555PManson Howard William · Pinckney, MIBuilt 1966 · S/N TE-164N555PDSw Plains Aviation LLC · Ford, KSBuilt 1980 · S/N EA-61N555PLQualitair LLC · MichelstadtBuilt 1988 · S/N 4608121N555PZLada Aviation LLC · Alpine, UTBuilt 1975 · S/N D-9782N555RAMooseknuckle Aviation LLC · Haslet, TXBuilt 1975 · S/N TE-1066N555RCCaron Robert M · Fort Pierce, FLBuilt 1976 · S/N 21061303N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621N555RYA-1 Windshield Inc · Rexburg, IDBuilt 1977 · S/N 21062146N555SKJld Resources Management LLC · Helena, MTBuilt 1982 · S/N 21064728N555SPJohnston Thomas · Austin, TXBuilt 1969 · S/N TE-676N555TGDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1034N555TJRegistered aircraftBuilt 2000 · S/N 29-0217N555TSBas Part Sales LLC · Greeley, COS/N D-7974N555TXBoujo Yoni · Valley Village, CABuilt 1976 · S/N D-9890N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515N555VRm A36 LLC · Jacksonville, FLBuilt 1978 · S/N E-1221N555WTHigh Speed Low Drag Aviation LLC · Hamilton, MTS/N CE-1536N555ZGJeminn LLC · Scottsdale, AZBuilt 2004 · S/N 1116N5561UAllen Calvin L · Mico, TXBuilt 1990 · S/N CE-1436N5562ZGordon Reed T · Troup, TXBuilt 1990 · S/N CE1467N5565DDirect Flight Inc · Vineyard Haven, MABuilt 1989 · S/N TH-1552N5565XHenry Michael Todd Trustee · Manhattan Beach, CABuilt 1990 · S/N CE-1485N55674Frog Air LLC · Amarillo, TXBuilt 1990 · S/N E-2542N5569NReverie Aviation LLC · Burbank, CABuilt 1990 · S/N E-2529N556ATAdventure Partners LLC · Mercer Island, WABuilt 1964 · S/N 206-0190N556CDSec Ventures LLC · St Charles, ILBuilt 2004 · S/N 1033N556LInternational Air Services Inc Trustee · Carson City, NVS/N 0132N5571CHarrison Steven D · Rolla, MOBuilt 1989 · S/N CE-1347N5571DReuland Robert C · West Windsor, VTBuilt 1989 · S/N CE-1405
Back to AD 86-13-04 R3