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.

N79THHudson Thomas · Bessemer, ALBuilt 1964 · S/N 21058329N79VK3g'S Aviation LLC · St Simons Island, GABuilt 1979 · S/N 21063322N7AEAndrew Reed Enterprises LLC · Fostoria, MIBuilt 1965 · S/N 320D0033N7ASLittle Karley Y · Baytown, TXBuilt 1967 · S/N CE-169N7AVPerkins Steven · Mount Juliet, TNBuilt 2004 · S/N 1053N7AWWeese David · Yamhill, ORBuilt 1965 · S/N D-7834N7BW7bw LLC · Lewes, DEBuilt 1973 · S/N E-395N7BXHoneywell International Inc · Phoenix, AZBuilt 1975 · S/N TE-1020N7CJPropart Inc · Austin, TXBuilt 1990 · S/N E-2575N7CMAirmart Inc · Lexington, KYBuilt 2016 · S/N E-4091N7CNMentor Flight LLC · Savoy, ILBuilt 1955 · S/N 52-8272N7DAJanak Jeffrey · Corpus Christi, TXBuilt 1967 · S/N 402-0084N7DHBrown Michael D · Bloomington, INBuilt 1970 · S/N TH-118N7DMNix Terry W · Golden, MSBuilt 1972 · S/N TH-214N7EVYellow Star Mgmt LLC · Waco, TXBuilt 1998 · S/N E-3162N7FHGroh David · Mason, MIBuilt 1977 · S/N E-1142N7JKosco Matthew D · Munster, INBuilt 2000 · S/N E-3316N7JNB & K Steel & Supply Inc · Ogden, UTBuilt 2000 · S/N EA-663N7JZR & R Vehicles LLC · Davie, FLBuilt 1977 · S/N 21062116N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583N7MVSmooth Landing LLC · Dallas, TXBuilt 1964 · S/N 289N7MWSeven Aces LLC · Chesterfield, NJBuilt 1982 · S/N TH-1353N7NKHall Gregory Lyman · College Station, TXBuilt 1993 · S/N E-2786N7PD426th Aero Squadron LLC · Cropwell, ALBuilt 2000 · S/N TH-1972N7PKBohn Robert D Jr · Midway, GABuilt 1974 · S/N D-9608N7PRRed Aero LLC · Batesville, INBuilt 1974 · S/N E-622N7QEAir Traders LLC · Fayetteville, ARS/N 0764N7RDSchipper Properties Inc · San Jose, CABuilt 1967 · S/N 21058847N7RMJasper Aviation Inc · Jasper, ALBuilt 1967 · S/N TE-347N7RQTctj Holdings LLC · Yoakum, TXBuilt 1991 · S/N CE1622N7RZZantop Reese C Trustee · Naples, FLBuilt 1990 · S/N E-2562N7SFByrd Cody · Dalhart, TXBuilt 2010 · S/N LAIV098N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593N7VYRegistration Pending · St Louis Park, MNRegistration pendingBuilt 1957 · S/N BG-360N7WAWalker Edward A · Solomons, MDBuilt 1964 · S/N D-7668N7WZN7 Whiskey Zulu LLC · Cincinnati, OHBuilt 2005 · S/N E-3637N7YSMentor Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1957 · S/N BG-389N7YVTgp Aviation Services LLC · Peyton, COBuilt 2002 · S/N 0326N8000LWeeks Stanley III · Taneyville, MOBuilt 1965 · S/N D-8000N8000VCga Holdings LLC · Kalispell, MTBuilt 1967 · S/N 188-0250N8001ZGfi Investments LLC · Gillette, WYBuilt 1965 · S/N U206-0401N8002ZNash Richard · Missoula, MTBuilt 1965 · S/N U206-0402N8003RBig Sky Bonanza Inc · Wilmington, DEBuilt 1990 · S/N E-2558N80066Boring Troy K · Belleville, PABuilt 1976 · S/N 18503087N80069Easley Kevin M · Anchorage, AKS/N 18503088N8006ZMathews Vincent W · Bryan, TXBuilt 1965 · S/N U206-0406N80070Neb City Building Inc · Anchorage, AKBuilt 1976 · S/N 18503089N8007VJcr Ag LLC · Frederick, OKBuilt 1967 · S/N 188-0257
Back to AD 86-13-04 R3