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.

N5639ZHowman Aero LLC · Cleveland, OHBuilt 1990 · S/N E-2535N563APNdb Holdings LLC · Helena, MTBuilt 2011 · S/N E-3967N563CDEl Paso Aero Inc · El Paso, TXBuilt 2004 · S/N 1182N563DBPavel John F Jr · Seattle, WABuilt 1967 · S/N D-8510N563PGKureishy Zaveen A · Triadelphia, WVBuilt 2001 · S/N 0033N5640KHowe Eric · Fishers, INBuilt 1964 · S/N D-7397N5641STitan Realty Inc · San Diego, CABuilt 1966 · S/N D-8182N56425Peterson Todd · Cameron Park, CABuilt 1990 · S/N CE-1469N5642WDemski Stanley L III Trustee · Woodbridge, CABuilt 1989 · S/N CE-1419N5643CAdvance LLC · Waterville, MES/N TH-1573N5645SVictorynow LLC · Lubbock, TXS/N TE-149N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5648KDale James B · Skaneateles, NYBuilt 1964 · S/N D-7585N5649KRyan Good Aviation LLC · Sioux Falls, SDS/N D-7401N564BPCrhrr LLC · Riverside, CABuilt 2001 · S/N 0135N564DLBrunson Scott · Mercer, PAS/N TE-474N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136N56511Wired Flight LLC · Kent, WABuilt 1974 · S/N 18502525N5651KStubblefield Daniel · Chino Hills, CABuilt 1964 · S/N D-7402N56539Six 27 Properties LLC · Flint, TXBuilt 1990 · S/N E2539N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969N5655NWiley Aviation LLC · Saint Augustine, FLBuilt 1990 · S/N CE-1464N5657KWatson Robin G · Eastsound, WABuilt 1964 · S/N D-7593N56581United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502907N565BPClark Giles R Jr · Magnolia, TXBuilt 1967 · S/N TE-405N565MJse Aviation LLC · Franklin, NHBuilt 1990 · S/N E-2525N565PAero Cruz LLC · Agoura Hills, CABuilt 1999 · S/N E-3280N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347N565SPattarini James Martin · Houston, TXBuilt 2003 · S/N 0576N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065N5661KShockey David Allen · Deland, FLBuilt 1964 · S/N D-7592N5662KGiddings Melvin J Jr · Vacaville, CABuilt 1964 · S/N D-7588N5664KEchols Charlotte · Wichita Falls, TXBuilt 1966 · S/N CE-43N5665JFarwest Aviation LLC · Billings, MTBuilt 1970 · S/N 18800615N5668KMonroe Shannon · Bellevue, WABuilt 1964 · S/N D-7601N5669KYankee Airmen Inc · Torrance, CABuilt 1964 · S/N D-7656N5670JBank Of Utah Trustee · Salt Lake City, UTBuilt 1969 · S/N 18800620N5676KDevlin Jeff M · Seattle, WABuilt 1964 · S/N D-7602N5677XKas Properties LLC · Jennings, LABuilt 1993 · S/N E-2797N567ABPiper Aviation LLC · Lewes, DEBuilt 2001 · S/N 0030N567DEclipse Inc · Sharon Springs, KSBuilt 1980 · S/N P21000665N567DBGardner Law Firm Pllc · Shawnee, OKBuilt 1965 · S/N 21058689N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071N567MShower Brenden C · Raleigh, NCBuilt 1979 · S/N CE-854N567MB1 And 3 Lc · Jenks, OKBuilt 2002 · S/N 40052N567RSSpitler Robin C · Statesboro, GABuilt 1967 · S/N D-8575N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713N567ZZulu Aerospace Services LLC · Prescott, AZS/N CE-158N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218
Back to AD 86-13-04 R3