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.

N1WFRegistered aircraftBuilt 1968 · S/N D-8880N1WXRegistered aircraftBuilt 2022 · S/N E-4148N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580N1YCMay Thomas W · Texarkana, TXBuilt 1976 · S/N 310R0621N1YDBerg Bradley · Tulare, CABuilt 1968 · S/N 21059105N1YRPerley Kevin G Trustee · Sioux City, IABuilt 1975 · S/N D-9797N1ZPConcord Flying Club Inc · Lafayette, CAFirst renewal noticeBuilt 1971 · S/N E-262N2000M2000m LLC · Savannah, GAS/N 1475N2001BBangert Computer Systems Inc · Shawnee, KSBuilt 1966 · S/N D-8216N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022N2002WWilliams Howard Dale II · Oklahoma City, OKBuilt 1965 · S/N D-7988N2004WPeter Schiff Aero Inc · Cookeville, TNBuilt 1965 · S/N D-7966N2008WSiamese Cat LLC · Issaquah, WABuilt 1965 · S/N D-7977N20098Registered aircraftBuilt 1999 · S/N 30-0029N200ARHelijet Holdings LLC · Wellington, FLBuilt 2004 · S/N 1122N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881N200BWGas Aviation LLC · Decatur, TNBuilt 1965 · S/N D-7954N200DFlipper 1 LLC · Fort Lauderdale, FLBuilt 1967 · S/N 379N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223N200DSRathi Blythe P · Hayward, CABuilt 1974 · S/N 74-30699N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200GDBowen Watson K · Abilene, TXBuilt 1988 · S/N CE-1264N200JFAustin Steven G · Tigard, ORBuilt 1990 · S/N CE-1516N200LBBresciani Martin · Guaynabo, PRBuilt 2002 · S/N 0209N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200QBluth Marshall S · Great Neck, NYBuilt 1971 · S/N CE-339N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073N200RTRiley Nolan C · Lubbock, TXS/N TK-101N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601N200SPN200sp LLC · Erie, COBuilt 1967 · S/N TE-487N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921N200UGRaw Logistics LLC · Bethel, NCBuilt 1978 · S/N E-1225N200VPDrp Aviation LLC · Southlake, TXBuilt 2000 · S/N 29-0231N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478N200WWRoark LLC · Bend, ORBuilt 1985 · S/N 46-8508035N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979N2012S9791m LLC · Tacoma, WAS/N 21060980N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971N2015CMorgan Arrow LLC · Greeley, COBuilt 1978 · S/N E-1311N2015T2015t LLC · Omaha, NEBuilt 1978 · S/N CE-795N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209N2016NOsfly LLC · Wilmington, DEBuilt 1978 · S/N E-1313N2016Y2016y LLC · Aurora, COBuilt 1978 · S/N D-10157N2017PBruninga Harold J · Jacksonville, ILBuilt 1978 · S/N D-10156N2017WDucharme Paul Quin · Lafayette, LABuilt 1965 · S/N TE-12
Back to AD 86-13-04 R3