OpenAirDocs.org
AD 86-15-07

Registered aircraft · 790

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-15-07')
    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-15-07')
  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.

N100UDVogel Kelly C · Ventura, CAS/N 15070071N103SGJared William C · Valparaiso, INBuilt 1958 · S/N 17004N1102YSass James Louis Jr · Abilene, TXBuilt 1962 · S/N 15059502N1109YKoller Keith S · Grosse Ile, MIBuilt 1962 · S/N 15059509N1111YAeronautical Technical Service Inc · Collierville, TNBuilt 1962 · S/N 15059511N1113YPrecision Design Inc · Weatherford, OKS/N 15059513N1114YThompson Randy L · Anderson, CABuilt 1962 · S/N 15059514N1121YShaw Michael B · Ridgeland, WIBuilt 1962 · S/N 15059521N1127YWong David · Torance, CABuilt 1962 · S/N 15059527N1128YPerez Donna · Chico, CABuilt 1962 · S/N 15059528N112LDMartin Joseph S · Carrollton, KYS/N 15076178N112LNBruce James W · Searcy, ARBuilt 1972 · S/N 15073504N1133YGreen Mountain Semiconductor Inc · Burlington, VTS/N 15059533N1135YSwanson Isaac · Wasilla, AKS/N 15059535N1140YPritchard Casey M · Bells, TXBuilt 1962 · S/N 15059540N1144YThomas Douten D · Roxbury, MES/N 15059544N1150YHoffman Anthony J · Rathdrum, IDBuilt 1962 · S/N 15059550N1151YCraigmyle William R · Cooperstown, NYBuilt 1962 · S/N 15059551N1157YMoles Dale A · Mooresburg, TNBuilt 1962 · S/N 15059557N1158YAas LLC · Ovid, MIBuilt 1962 · S/N 15059558N1159YAultman Micah · Rocky Face, GABuilt 1962 · S/N 15059559N1162YBryan Danny J · Hobbs, NMBuilt 1962 · S/N 15059562N1163YWyatt Airventures LLC · Ogallala, NEBuilt 1962 · S/N 15059563N1166YPositive Painting Inc · Lakeland, FLBuilt 1962 · S/N 15059566N1169YSkuza Patrick · Soldotna, AKBuilt 1962 · S/N 15059569N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570N1176YMay Jack R · Tallahassee, FLBuilt 1962 · S/N 15059576N1183YCowan Ronnie C · Glasgow, KYBuilt 1962 · S/N 15059583N1185YWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059585N118DHUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1960 · S/N 17937N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596N1200L1st American Aviation Inc · North Miami, FLBuilt 1959 · S/N 17785N1200YMillner Jack A · Toledo, OHBuilt 1962 · S/N 15059600N1203YWyatt G Whitlow · Wshngtn Ct Hs, OHBuilt 1962 · S/N 15059603N1207YDickman Matthew J · Cold Spring, KYBuilt 1962 · S/N 15059607N1208YSnyder Jason D DBA · Oakland, MDBuilt 1962 · S/N 15059608N1211YEdens William D · Mesa, AZBuilt 1962 · S/N 15059611N1212YKennedy Kevin · Vassar, KSBuilt 1962 · S/N 15059612N1213YRistau Ronald R · Lu Verne, IABuilt 1962 · S/N 15059613N1215YGill Robert S · Anchorage, AKS/N 15059615N1222YPasseno Craig A · Cheboygan, MIBuilt 1962 · S/N 15059622N1224YLowenkron Laurence H · Pleasanton, CABuilt 1962 · S/N 15059624N1226YVolo Consulting LLC · Menomonee Falls, WIBuilt 1962 · S/N 15059626N1227YGyure Ronald J · Ft Worth, TXBuilt 1962 · S/N 15059627N1229YFinney James R · Howe, TXBuilt 1962 · S/N 15059629N1233YPoland Marvin W · Tawas City, MIBuilt 1962 · S/N 15059633N1237YLootens David P · Wofford Heights, CABuilt 1962 · S/N 15059637N1238YGasman Aero LLC · Kalispell, MTBuilt 1962 · S/N 15059638N1240YChanter Connor N · Grayslake, ILBuilt 1962 · S/N 15059640N1246YMacy G Kevin · Brownsville, CABuilt 1962 · S/N 15059646
Back to AD 86-15-07