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.

N77JSSol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1621N77KAHostetler Adam D · Dayton, VABuilt 1969 · S/N TE-720N77KGPickett Ronald K · Orange Park, FLBuilt 1974 · S/N CE-486N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703N77LBEleuthera II LLC · Mesa, AZBuilt 1974 · S/N TH-536N77LMElephants & Airplanes LLC · Wakeforest, NCBuilt 1969 · S/N D-8950N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287N77MDDerby Michael R · Falls Church, VABuilt 1970 · S/N E-234N77MS5foot Face Flight Inc Trustee · Wilmington, DEBuilt 1983 · S/N E-2116N77NWRizor Justin · Phoenix, AZS/N TK-141N77PGJjo Aero LLC · Keller, TXBuilt 1991 · S/N E-2680N77PHRiddick Aviation LLC · Columbia, MOBuilt 2000 · S/N 29-0234N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120N77QJBelzberg Gary Md · Sneads Ferry, NCBuilt 1967 · S/N D-8610N77QQBurkhardt Wayne W · Deming, NMBuilt 1979 · S/N D10251N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846N77RGN77rg LLC · Amarillo, TXBuilt 1976 · S/N 310R0636N77RTBouchier Thomas B · Post, TXBuilt 1978 · S/N TJ-135N77SMHuberty Gregory N · Billings, MTBuilt 1975 · S/N TE-1023N77SVSharp Tally T · Sunset, TXS/N 77-30851N77TASword Gary · Greenville, TXBuilt 1981 · S/N 18504296N77UP423 LLC · Mankato, MNBuilt 1969 · S/N CE-284N77VBMorgenroth Aviation LLC · Victoria, TXBuilt 1974 · S/N D-9629N77VKPontiac Flying LLC · Pontiac, ILBuilt 1970 · S/N E-221N77WSRegistered aircraftBuilt 1969 · S/N P206-0628N77YEHaagenson Trevor O Trustee · Carnelian Bay, CABuilt 1975 · S/N TE-1074N7802FHuntting Preston I · Camp Verde, AZBuilt 1973 · S/N 18502210N7802RPiroli John M · Nokomis, FLBuilt 1968 · S/N D-8886N7803RRick Franklin Corp · Lebanon, ORBuilt 1968 · S/N TE-637N7806SAeroquest LLC · Plano, TXBuilt 1978 · S/N U20604168N7807RRife Rick R · Scottsdale, AZBuilt 1968 · S/N D-8889N780ALas Margaritas Aviation LLC · Qulin, MOBuilt 1978 · S/N U20604463N780CDGreene James W · League City, TXBuilt 2004 · S/N 1202N780ESFlying Pineapple LLC · Naples, FLS/N U20604272N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N780SHPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 310R1367N780YPack Larry L · Grand Blanc, MIBuilt 1978 · S/N TH-935N7813RGonzales Donald W DBA · Mercer Island, WABuilt 1969 · S/N D-8912N7817RTrew Glen · Nashville, TNBuilt 1968 · S/N TE-666N78185Sankey Paul F · Colusa, CAS/N 18503544N7818RRkn Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E129N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235N781DBCooper Roy · Lamesa, TXS/N P21000293N781LDKeane James P · West Islip, NYBuilt 1978 · S/N D-10132N781WCOak And Pine Ranch LLC · Kalispell, MTBuilt 1987 · S/N CE-1156N782Dillon T34 782 LLC · Scottsdale, AZBuilt 1954 · S/N CG58EN7820RGabriel Donald E · Tucson, AZBuilt 1968 · S/N D-8866N7822MAero Rocket LLC · Las Vegas, NVBuilt 2005 · S/N 1722N7828RHoward Donald V · Goldthwaite, TXFirst renewal noticeBuilt 1968 · S/N D-8903
Back to AD 86-13-04 R3