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.

N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650DSFlight Crew Professionals LLC · Houston, TXBuilt 2001 · S/N 29-0276N650PVSokolowski Paul W · Bedford, PABuilt 1967 · S/N TE-427N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N650SCCrawford Setrige · Alameda, CABuilt 2005 · S/N L2K-216N650YRWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N E-1932N65105Hall Herb · Leawood, KSBuilt 2004 · S/N 42059N6510V1903 Aviation LLC · Saint Augustine, FLS/N 42029N6510YSaginaw LLC · Missoula, MTBuilt 2004 · S/N 42057N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N6511YToys LLC · Cumberland, RIBuilt 2003 · S/N 40073N65123Martin Michael · Galesburg, ILS/N 40077N6512FFunk Norman J · Norfolk, NEBuilt 2003 · S/N 40078N6512RCeresa Glen · Watsonville, CABuilt 2003 · S/N 42014N6512ZNuvo Concepts Corp · El Paso, TXBuilt 2003 · S/N 42017N65131Bas Part Sales LLC · Greeley, COBuilt 2003 · S/N 42027N6513GMarno Aviation LLC · El Paso, TXBuilt 2003 · S/N 42025N6514BN2828 LLC · Highland, WIBuilt 2001 · S/N 40026N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541N6517VDesert Flyers LLC · Calexico, CABuilt 1973 · S/N 12037N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542N6519NWinged Chariot LLC · Cincinnati, OHBuilt 1982 · S/N EA-319N651DBJgm Icarus LLC · Centennial, COBuilt 1976 · S/N 340A0089N651JStuffings Jeffrey F · Longmont, COBuilt 2009 · S/N 311N65206Brinkhoff Gary H · Hygiene, COBuilt 1964 · S/N P206-0024N6525Sacramento Computer Power Inc · Sacramento, CABuilt 1977 · S/N E-1173N6526MDapp Eric M · Corvallis, ORBuilt 1977 · S/N 21061973N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186N6529RN6529r LLC · Merritt Island, FLBuilt 1982 · S/N EA-322N6529YBbd Lynch Family Lp · Houston, TXS/N 21064421N652DBRocky Mountain Air LLC · Lafayette, COBuilt 1987 · S/N CE-1144N6530YDelgado Gonzalez Hector · San Diego, CABuilt 1981 · S/N 21064422N65318Prairie Sales Inc · Eden Prairie, MNBuilt 1983 · S/N E-2060N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791N6532NN6532n LLC · Sioux Falls, SDBuilt 1978 · S/N 21063088N6534NDoxsee Joshua · Beverly, MABuilt 1978 · S/N 21063090N6536HThree Rivers Lake Creek LLC · Kapolei, HIS/N 18503332N6536NPalmetto Wings LLC · Marietta, GAS/N E-2049N65376Sardella Craig J · Gold River, CABuilt 1983 · S/N EA-366N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094N653DGWatson Dallas C · Guthrie, OKBuilt 2003 · S/N 0522N653JRMosquito Air LLC · Lewes, DEBuilt 1979 · S/N 340A0726N65420D5167 LLC · Kalispell, MTS/N E-2091N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913N6542NHill Jonathan G · Dover, NHBuilt 1978 · S/N 21063098N6542UMcdade John P · Fraser, COBuilt 1985 · S/N 21064957N6544VHuber Robert T · West Chester, PABuilt 1983 · S/N E-2063N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102
Back to AD 86-13-04 R3