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.

N7944KTaylor Aviation Of Seminole Ok LLC · Seminole, OKBuilt 1964 · S/N D-7449N7945KCarlson Phillip D · Napa, CABuilt 1964 · S/N D-7436N7946KLindgren Erik M · Riverside, CABuilt 1964 · S/N D-7434N7946MGriesinger William R Trustee · Colorado Springs, COBuilt 1966 · S/N D-8255N7946RIron Will Trucking LLC · Lancaster, KYBuilt 1969 · S/N TE-704N7949KKeithley Terrance · Las Vegas, NVBuilt 1965 · S/N D-7938N794CBBeckwith Robert E · Torrance, CABuilt 1978 · S/N CE-794N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N7951MBrown David E · Bell Buckle, TNBuilt 1966 · S/N CE-82N7951RWilley Rick E · Hendersonville, TNBuilt 1969 · S/N E-145N7952MCherry Winds Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-192N7952RVictory Lane Aviation LLC · Concord, NCBuilt 1969 · S/N TE-706N7954KHamill Britt · Louisville, MSBuilt 1964 · S/N D-7458N7954QFrankenstein Aviation LLC · Hollywood, FLS/N 310R0119N7956MDream Flyers LLC · Wilmington, DEBuilt 1968 · S/N D-8823N7957RCunniff Michael L · Belle Mead, NJS/N D-8989N7958DNewcomb Clint M · Benton, ARS/N TH-1019N7958PHall Wendell W · Cheraw, SCBuilt 1976 · S/N CE-655N7958RFarrow Richard · Godfrey, ILBuilt 1968 · S/N TE-692N7959MMed Care Inc · Grand Island, NES/N TE-189N795ABSilver Mar LLC · Key Biscayne, FLBuilt 1998 · S/N TH-1880N795AMBoone Aviation Services LLC · Winston Salem, NCBuilt 2004 · S/N 0997N795SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N CE-1599N7960RMainline Aviation LLC · Paeonian Springs, VAS/N CE-270N7962MPadikins Inc · Wilmington, DEBuilt 1966 · S/N CE-80N7965KBlake Manus · Rock Springs, WYBuilt 1964 · S/N D-7469N7966MEagle Aviators LLC · Franklin, VABuilt 1966 · S/N D-8258N7967MMercer Aero Service Inc · Aurora, COBuilt 1966 · S/N D-8260N7969MN7969m LLC · Double Oak, TXBuilt 1966 · S/N D-8283N7969QBadenhope John R · Greeneville, TNS/N 401B0109N796CDSouthernskies Aircraft N796cd LLC · Cape Coral, FLBuilt 1979 · S/N 310R1579N7972KTeer John · Austin, TXBuilt 1964 · S/N D-7471N7973KDreams A Loft LLC · Santa Barbara, CABuilt 1964 · S/N D-7470N7973M7973m LLC · Broomfield, COBuilt 1966 · S/N TE-208N7974DChaffin Grant M · Blythe, CAS/N D-5226N7974KDavis Jeremy · Longview, TXS/N D-7468N7975RHicks Jeffrey D · Ponca City, OKBuilt 1969 · S/N D-8991N7976MHudson Kent O · Anchorage, AKBuilt 1966 · S/N D-8268N7977MLoskill Edwin R · Lubbock, TXBuilt 1966 · S/N D-8269N7978MRegistered aircraftBuilt 1966 · S/N CE-84N7979MFrancis William · Lake Oswego, ORS/N D-8270N797BTCollins Jeffery Scott · Fort Myers, FLBuilt 2002 · S/N 0340N797HGBearaire LLC · Fairport, NYBuilt 1984 · S/N 46-8408064N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N797RHCya Ltd · Crystal Lake, ILBuilt 1965 · S/N D-8022N797SMLowry Michael R · Los Altos Hills, CABuilt 2003 · S/N 0616N797TN797t Aviation LLC · Stanfield, NCBuilt 2003 · S/N 42031N7983KCormier Christopher J · Anna, TXBuilt 1964 · S/N D-7584N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202N7984KBeech V-Tail LLC · Aurora, COBuilt 1964 · S/N D-7483
Back to AD 86-13-04 R3