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.

N185YLee Bryan D · Rexburg, IDFirst renewal noticeS/N 18502224N185YHMcdaniel Robert M · Tonasket, WAS/N 18503551N185YMBarber Michael E · Prescott Valley, AZBuilt 1977 · S/N 18503441N185YVCul-Aircorp Inc · Wellington, FLBuilt 1978 · S/N 18503546N185YYDagostino Thomas J · Wasilla, AKS/N 18503195N185ZWab Air LLC · Butte, MTBuilt 1968 · S/N 1851363N185ZMDragon Wagon LLC · Clackamas, ORBuilt 1981 · S/N 18504324N185ZZLeading Edge LLC · Scottsdale, AZBuilt 1966 · S/N 185-1029N1860AAry Co Ac & Heat LLC · Decatur, TXBuilt 1981 · S/N E-1933N1860WWhittaker Gary · Southport, NCBuilt 1973 · S/N D-9500N1861FKent Group Inc · Hazelhurst, WIBuilt 1981 · S/N E-1940N1861MLightspeed Enterprises LLC · Virginia Beach, VABuilt 1981 · S/N E-1936N1863FAndersen Dana K · Scappoose, ORS/N 21058763N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N1866CScialabba Samuel S · Emerald Isle, NCBuilt 1966 · S/N CE-60N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769N186AZIz Air LLC · Miami, FLBuilt 1976 · S/N 18503192N186DMann Thomas A · Ford, WABuilt 1961 · S/N 185-0127N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748N186VAplikowski Aviation LLC · Lino Lakes, MNBuilt 1969 · S/N 185-1511N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239N1870FWilliams Aviation LLC · Indianola, IAS/N 21058770N1870WMahoney Michael A · Daphne, ALBuilt 1973 · S/N E-435N1871FGorham Neil M · Memphis, TNBuilt 1966 · S/N 21058771N1872LFreeman Gary M · Richmond Hill, GABuilt 1976 · S/N CE-648N1873LJanzen Mark · Chico, CABuilt 1976 · S/N D-9892N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N1874LRegistration Pending · Dover, DERegistration pendingBuilt 1976 · S/N CE-649N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1875FMcfadin T E · San Antonio, TXFirst renewal noticeBuilt 1966 · S/N 21058775N1875LRib-Cjr Aero LLC · Los Altos Hills, CABuilt 1976 · S/N E-852N1875WN1875w LLC · Nashville, TNBuilt 1973 · S/N E-437N18760Twinfin LLC · Port Orange, FLBuilt 1977 · S/N D-10070N18763Registration Pending · San Jose, CARegistration pendingBuilt 1977 · S/N E-1158N1876WHeadsets Incorporated · Amarillo, TXBuilt 1973 · S/N CE-443N1877FHoots Kent B · Macon, GABuilt 1966 · S/N 21058777N1877LShrauner Reid E · Elkhart, KSBuilt 1976 · S/N E-857N1879FKris Noone Air LLC · Wilmington, DES/N 21058779N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N187CSNorris Marvin D · Georgetown, TXBuilt 1999 · S/N E-3232N187JSzm LLC · Laconia, NHBuilt 2010 · S/N E-3925N187MMSelf Aviation LLC · Hayden, IDBuilt 1965 · S/N 21058707N1880E L I Land Design LLC · Montgomery, TXBuilt 2001 · S/N 0110N1880LSouth Regional Aviation Enterprise · Boynton Beach, FLBuilt 1976 · S/N D-9894
Back to AD 86-13-04 R3