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.

N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416N612HClear Sound Hearing LLC · Sedalia, MOBuilt 1972 · S/N TE-860N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927N612KPSmith Aviation Inc · Stamps, ARBuilt 1998 · S/N TH-1857N612MAAndraos Aviation Solutions LLC · Northville, MIBuilt 1979 · S/N TH-975N612PZLovrencevic Mark · Hanford, CABuilt 1983 · S/N E-2108N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612TNAustin Bill DBA · Sparta, TNBuilt 1981 · S/N TH-1272N612TTCashin Timothy J · Santa Monica, CABuilt 1967 · S/N CE-152N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N61301Southern Seaplane Inc · Belle Chasse, LABuilt 1980 · S/N 18504144N6130CMay And Carter Oil Co · Jackson, GABuilt 1979 · S/N 21063808N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030N6130VKwalek Robert E · Shelton, CTBuilt 1965 · S/N D-7797N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031N6131RAir LLC · Salem, ORS/N T210-0031N6131XGv Air Inc · Medford, ORS/N 310R1296N61323N61323 LLC · Portland, ORBuilt 1980 · S/N 18504147N6133GRosebud Aviation · Gregory, SDBuilt 1973 · S/N 18801176N6133PEastwood LLC · Pikeville, KYBuilt 2003 · S/N 0639N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737N6134ZCji LLC · Winston Salem, NCBuilt 1981 · S/N E-1952N6135CMiller William J · Ferriday, LABuilt 1981 · S/N E-1954N6135EAce Aviation LLC · Mankato, MNBuilt 1980 · S/N 18504003N6135VSteinle Michael · Lake Village, INBuilt 1965 · S/N D-7787N61368Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1980 · S/N 18504159N6136VCcf Ventures Inc · Bangor, MEBuilt 1965 · S/N D-7788N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037N6137VCarpmail Michael · Yakima, WABuilt 1965 · S/N D-7789N6137XMoyer Aviation Inc · Ulysses, KSBuilt 1978 · S/N 310R1297N61387Stash Ventures LLC · Virginia Beach, VABuilt 1980 · S/N 18504168N61388Seidler Matthew J · Anchorage, AKBuilt 1980 · S/N 18504169N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N613BLMmas Aviation LLC · New York, NYBuilt 2016 · S/N TH-2455N613DRLyons Aviation LLC · Raleigh, NCBuilt 2001 · S/N 30-0062N613MFForcey Marcia · Westville, INBuilt 2015 · S/N E-4071N613MMCome Fly With US LLC · Purcellville, VABuilt 2005 · S/N 1497N613MWChip Aviation LLC · Sarasota, FLBuilt 1976 · S/N E-805N613YHKuspuk School District · Aniak, AKBuilt 1980 · S/N 20700633N61405Rovey George A · Cove, ORBuilt 1980 · S/N 18504174N61423State Of Utah · Salt Lake City, UTBuilt 1980 · S/N 18504180N6142CKite Harris Property Group LLC · Zionsville, INS/N 310R1300N61438Peot James J · Woodinville, WABuilt 1980 · S/N 18504189N61441Cook Sterling S · Wasilla, AKBuilt 1980 · S/N 18504191N6146MBluewater Na LLC · San Diego, CABuilt 1981 · S/N E-1959N61471N484rf LLC · Jackman, MES/N 18504202N61473U S Department Of Interior · Boise, IDBuilt 1981 · S/N 18504204
Back to AD 86-13-04 R3