OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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:87-18-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1')
  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.

N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156N4000WN4000w LLC · Prescott, AZBuilt 1974 · S/N TE-1004N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N400DMAlborn Mary L · Eagle River, AKS/N E-748N400GLAaces Flight Operations LLC · Ellisville, MOBuilt 1987 · S/N CE-1201N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115N4015AOvad David Mark · Reisterstown, MDBuilt 1970 · S/N CE-297N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N402EASneed Leasing LLC · Nashville, TNBuilt 2001 · S/N E-3402N402PWalker Mickey R · Sun City, AZBuilt 1992 · S/N CE-1671N403PAFergany Amr Farouk · Sebastian, FLBuilt 1980 · S/N TH-1182N403SACalk Mark C · Troy, ALBuilt 2001 · S/N E-3407N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104N404LFHicks Michael P Jr · Wallis, TXBuilt 1974 · S/N E-588N404PKlump Aviation LLC · Hutto, TXBuilt 1993 · S/N E-2792N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705N4061SHammerstrand John A · La Mesa, CAS/N E-619N4065SAlpha 3 LLC · Newcastle, OKBuilt 1975 · S/N TE-1025N406PASale Reported · Rantoul, KSSale reported, canceledBuilt 1982 · S/N TH-1338N4074SOverbeck John T · Excelsior, MNFirst renewal noticeBuilt 1975 · S/N CE-554N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109N4077SRiedesel Lynn R · Brookings, SDBuilt 1975 · S/N E-638N4079ABrockhoff Jonathan Allen · Sanford, NCBuilt 1999 · S/N E-3279N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4083A4083a LLC · Wilmington, DES/N D-9110N4084CKrech Gordon L · Rolla, NDBuilt 1979 · S/N D-10184N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194
Back to AD 87-18-06 R1