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.

N719LMPurcell Daniel G · Spotsylvania, VAS/N 0590N719SGMaisel Chad L · Plano, TXS/N D-8714N71AZHolsinger Law LLC · Denver, COBuilt 2003 · S/N ES-050N71BFPlane Fun Inc Tr Trustee · Snellville, GAS/N 29-0412N71BLLachapelle Brian L · North Palm Beach, FLBuilt 1968 · S/N E-5N71DKAirship Zulu Productions LLC · Wilmington, DEBuilt 2019 · S/N E-4137N71DWAttard Steven L · Ottawa Lake, MIBuilt 1975 · S/N 310R-0174N71ESBig Tex LLC · Reedsburg, WIS/N U206-1402N71GGTrans-Exec Air Service Inc · Van Nuys, CABuilt 1971 · S/N TE-835N71GRRahmeyer Gary W · Lake Ozark, MOBuilt 1976 · S/N TH784N71HZYoung David K · Anna, TXBuilt 1964 · S/N D-7714N71KWAcuff Joseph · Mooresville, NCBuilt 1977 · S/N E-1144N71LMHirshik Larry E · Center Harbor, NHBuilt 1989 · S/N CE-1424N71MEB200 Holdings LLC · Gilbert, AZBuilt 1969 · S/N 401B0007N71MKWyeth Patrick · Chino Valley, AZBuilt 1980 · S/N P21000590N71MVVolatile Aero Ventures LLC · Boulder City, NVFirst renewal noticeBuilt 1974 · S/N U20602365N71PHPlh Air LLC · Post Falls, IDBuilt 1975 · S/N U20602651N71RTaliaferro Aviation LLC · Ardmore, OKS/N 18503942N71RWRitchie Aviation LLC · Perry, GABuilt 2016 · S/N E-4100N71TFawcett Andrew R · Los Altos Hills, CABuilt 2004 · S/N 001N71TWThink West Investments LLC · Middletown, DEBuilt 2005 · S/N 1455N71VKV1 Real Estate LLC · Pittsburg, TXS/N TE-387N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460N7200HHefelfinger James F · Port Orange, FLBuilt 1984 · S/N EA-426N7200NBorgerson Mark J · Montevideo, MNBuilt 1968 · S/N E-12N7201NWilliams Evan H · Sebastopol, CABuilt 1968 · S/N D-8815N72027Candy Corn LLC · Missoula, MTBuilt 1968 · S/N U206-1259N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456N7202NBowers Enterprises LLC · Peachtree City, GABuilt 1968 · S/N D-8710N7203NGrey Hairs LLC · Lake Saint Louis, MOBuilt 1968 · S/N D-8716N72045Pembroke Flyers LLC · Pembroke, NHBuilt 1984 · S/N CE-1042N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457N72050Petty Line Const Co Inc · Clanton, ALBuilt 1969 · S/N U206-1266N72053South Aircraft Leasing Inc · Wilmington, DEBuilt 1974 · S/N 402B-0587N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458N7206BSt Andrews Systems LLC · Navarre, FLBuilt 1984 · S/N CE-1043N7206DCrazy Plane LLC · Saint Augustine, FLBuilt 1984 · S/N EA-435N7207LSparkman Aviation · Odessa, TXBuilt 1984 · S/N EA-438N7208RBelford Mark C · Sammamish, WABuilt 1974 · S/N D-9699N72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943TN72094Gibertoni James E · Fairbanks, AKBuilt 1969 · S/N U206-1281N720CDDewitt 2 LLC · Evansville, INBuilt 2001 · S/N 0010N720DWCatalina Sierra Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N CJ-30N720ECEast Coast Aviation LLC · Falmouth, MEBuilt 2004 · S/N 1218N720FHParadigm Aviation LLC · Anchorage, AKBuilt 1982 · S/N 18504375N720GEHoucke Pascal · Newtown, PABuilt 1975 · S/N 21060671N720LRegistered aircraftBuilt 1968 · S/N 320F-0042N720LTCowan Mark · Afton, WYBuilt 2004 · S/N 1059N720PMurillo Carlos F · Pembroke Pines, FLS/N 0617N720TMinter Michael D Jr · Rock Port, MOBuilt 1975 · S/N D-9813
Back to AD 86-13-04 R3