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.

N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316N1974DN822js LLC · Norcross, GABuilt 1973 · S/N E-493N1975ADayspring Aviation LLC · Bend, ORBuilt 1976 · S/N E-860N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N1977UErsland Nile P · Anchorage, AKBuilt 1970 · S/N 18501715N1977XOne Pft LLC · Denton, MTBuilt 1977 · S/N 18503405N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711N1978SWatson Jeffry T · Colorado Springs, COBuilt 1976 · S/N CE-640N1978UKilbourn Aldean G · Fairbanks, AKBuilt 1970 · S/N 18501718N1979Whitley Jason · Southlake, TXBuilt 1979 · S/N E-1568N1979BLink John E · Hereford, TXBuilt 1979 · S/N 79-30925N1979TOmalley Theodore J · Willow, AKBuilt 1978 · S/N 18503686N1979UDreger Dean R · Wilbur, WABuilt 1970 · S/N 18501723N197CVJoseph F Gaar Jr Professional Law Corp · Lafayette, LABuilt 2016 · S/N 32-0001N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084N197DTSzczerba Francis C · Cranberry Township, PABuilt 1997 · S/N 29-0113N197FMGainey Mark P · San Antonio, TXBuilt 1987 · S/N CE-1131N197QUrban Andrew W · Sun Prairie, WIBuilt 1965 · S/N D-7930N197RDean Clay · Cleveland, TXBuilt 1974 · S/N E520N197RDCrockett R · Glenwood Springs, COBuilt 1978 · S/N 18503681N1983UAlpine Air LLC · Cordova, AKBuilt 1970 · S/N 18501731N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423N1985CCollins Bruce J · Caldwell, TXS/N D-7438N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544N1988WAerobat Ventures LLC · Phoenix, AZBuilt 2018 · S/N E-4118N198AZCoyote Aviation LLC · Ballston Spa, NYBuilt 1980 · S/N U20605961N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298N198KRAddison Eddie M · Toccoa, GABuilt 2003 · S/N 020N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063N198VSkrow Works Inc · West Monroe, LABuilt 1969 · S/N 30214N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250N1992JWet Ever LLC · Gainesville, GABuilt 1999 · S/N 30-0042N1994UBoney C Steven · Bethel, AKBuilt 1970 · S/N 18501761N1995GHarris Justin R · Hico, TXFirst renewal noticeBuilt 1974 · S/N 414-0602N1995URegistered aircraftBuilt 1970 · S/N 18501764N1996USmith Aviation LLC · Sitka, AKBuilt 1970 · S/N 18501765N1998VLedbetter Zachary S · Wasilla, AKBuilt 1973 · S/N U20602035N1999JBeech Boys LLC · Peachtree City, GABuilt 1967 · S/N TE-344N1999UKarr Brandon · Everett, WABuilt 1970 · S/N 18501768N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243N199MDSurgair Inc · Absarokee, MTBuilt 2003 · S/N 29-0298N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N199RPId Corporation · Shepherd, MTS/N EA-344N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313N19ABYong Andrew · Newnan, GABuilt 1964 · S/N D-7701N19ATEastside Transporation LLC · Chowchilla, CABuilt 2009 · S/N E-3900N19CAPoulton Bruce A · Fremont, CABuilt 1994 · S/N E-2877N19DEchelon Right LLC · Nicholasville, KYBuilt 1980 · S/N 18504097N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868
Back to AD 86-13-04 R3