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.

N790XPrecision Design Inc · Weatherford, OKS/N 421A0087N7910KTyler William R · Plantation, FLBuilt 1964 · S/N D-7405N7911AOboyle Joseph E · Danville, VABuilt 1964 · S/N D-7490N7911MGillette David L · Mount Pleasant, TXBuilt 1966 · S/N D-8225N7911RBelinski Jason J · Woodbridge, VAS/N TE-622N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013N7913RBeadle Steve E · El Paso, TXBuilt 1969 · S/N CJ-19N7914RFrith Smith Michael J · Bishop, CABuilt 1969 · S/N D-8943N7915MBlue Sky Aviation LLC · Northport, ALS/N CE-73N7915RWoods Todd Ryan · Perry, OKBuilt 1969 · S/N D-8941N7916RHealy David Paul · Arlington, TXBuilt 1969 · S/N E-140N7917KStratospheric Flyers Group Inc · Louisville, KYBuilt 1964 · S/N D-7416N7917NWrangell Mountain Air Inc · Palmer, AKBuilt 1977 · S/N U20603720N7917RPh Air LLC · Turners Falls, MAFirst renewal noticeBuilt 1969 · S/N D-8940N791AABonanza Paradise LLC · Queen Creek, AZBuilt 1979 · S/N E-1609N791KDKrupa Rafal · Hampstead, NCBuilt 2004 · S/N 1143N791LHFancy Dog Aero LLC · East Wakefield, NHBuilt 2005 · S/N 1739N791Q791q LLC · Rock Springs, WYBuilt 1969 · S/N TE-724N7920MWirt John P · Lake Havasu City, AZBuilt 1980 · S/N E-1714N7921KFrieders Bryan · Thompsons Station, TNBuilt 1964 · S/N D-7713N7921MMiller Dennis J · Bartlett, TNBuilt 1966 · S/N D-8251N7922KChand Jaison A · Astoria, ORBuilt 1964 · S/N D-7456N7922MDestination Aero LLC · Lubbock, TXBuilt 1966 · S/N D-8235N7925MOatman Scott · Colorado Springs, COBuilt 1966 · S/N TE-183N7925QWolf River Aviation LLC · Memphis, TNS/N 401B0025N7925RHoward Philip D · Glen Rose, TXBuilt 1969 · S/N D-8949N79260Sale Reported · Xxx, OKSale reported, pending cancellationBuilt 1974 · S/N 18801968TN7926KOconnell Raymond · Brawley, CABuilt 1964 · S/N D-7421N7927RN7927r LLC · Columbia Falls, MTBuilt 1969 · S/N CJ-20N792DMDkl Inc · Ardmore, OKBuilt 1966 · S/N D-8354N792JHElgee Aviation LLC · Fairfield, NJBuilt 2001 · S/N TH-1988N792QMurphy Ronald O · Greensboro, NCFirst renewal noticeBuilt 1969 · S/N TE-754N7932MPower James P · Box Elder, SDBuilt 1966 · S/N D-8241N7932RIowa Aircraft Inc · Burlington, IABuilt 1969 · S/N D-8954N79336Yaggie Allen · Wahpeton, NDBuilt 2005 · S/N 29-0379N7933KCross Marc W · Corpus Christi, TXBuilt 1964 · S/N D-7424N7933RBeech Runner LLC · Wilmington, DEBuilt 1969 · S/N D-8955N7934RLa Playa LLC · Wilmington, DEBuilt 1969 · S/N E-142N7935RWhitney Frederick C · Hampton, NJBuilt 1969 · S/N D-8960N7936ABb Air Guys LLC · Scott City, KSBuilt 1978 · S/N E-1421N7936KTurbo Air Charter LLC · Boise, IDBuilt 1964 · S/N D-7428N7936RCloud Surfing LLC · Missoula, MTBuilt 1969 · S/N D-8962N7938KShurbet Mark S · Floydada, TXBuilt 1964 · S/N D-7431N793AKAcme Skywagon LLC · Idabel, OKFirst renewal noticeBuilt 1983 · S/N 18504409N793CDRbj Tn Holdings LLC · Cleveland, TNS/N 1099N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300N793RGMeadowlake Airpark LLC · Lenoir City, TNBuilt 2011 · S/N TH-2309N7941RRegistered aircraftBuilt 1969 · S/N D-8958N7943ROlivia Flying Service Inc · Olivia, MNBuilt 1969 · S/N D-8959
Back to AD 86-13-04 R3