OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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-20-03-R2')
    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-20-03-R2')
  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.

N223NKWandering Vet LLC · Mccook, NEBuilt 1955 · S/N 26814N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757N223WHPerrin James F · Bancroft, WIBuilt 1964 · S/N 18051355N22401Knotek Larry A · Reno, NVS/N 15068256N22409Tanner David A · Onalaska, TXBuilt 1968 · S/N 15068262N2240EKellogg Jeffrey D · Adams Center, NYBuilt 1978 · S/N 17271200N2240JBreithaupt Tracy L · Alexandria, LAFirst renewal noticeBuilt 1966 · S/N 15065440N2240XTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1965 · S/N 337-0140N22415Viking Wings LLC · Kindred, NDBuilt 1968 · S/N 15068266N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186N2241TWhittock Tyson H · Anchorage, AKS/N 185-1397N22429Johnson Dustin W · Puyallup, WABuilt 1974 · S/N 17264064N2242DField Barry C · Leverett, MABuilt 1952 · S/N 20394N2242GNelson Mark · Fairbanks, AKBuilt 1958 · S/N 51542N22435Pearson Charles C · Covington, LABuilt 1968 · S/N 15068279N22436Pecht Scott A · Reedsville, PABuilt 1968 · S/N 15068280N22439Birginia Aviation LLC · Forest, VAS/N 15068283N2243CBelleville Livestock Market Inc · Belleville, PABuilt 1953 · S/N 30543N2243EFord William H · Downers Grove, ILBuilt 1978 · S/N 17271202N2243XSmith Debra A · Louisville, KYS/N 337-0143N2243YReeves Adrianna M · New Carlisle, INBuilt 1967 · S/N 17700043N22448Eddy Lisa M · Benton, KSBuilt 1968 · S/N 15068291N2244CSkywagon Aero LLC · Wilmington, DES/N 30544N2244TAmerican Elevator · Ruidoso, NMS/N R18200004N2244XPlane Life LLC · Wilmington, DEBuilt 1965 · S/N 337-0144N2244YHaberer Mark M · Elbow Lake, MNBuilt 1967 · S/N 17700044N22452Waddy Bertha L · Villa Ridge, ILBuilt 1968 · S/N 15068292N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2245CChesnut Lonnie R · Palmer, AKS/N 30545N2245GSkyair Express LLC · Overton, NVS/N 51545N2245JRiver City Aviation LLC · Carmichael, CAS/N 15065445N22462Organ Daniel W · Vernonia, ORBuilt 1968 · S/N 15068298N2246DBiagioni Paul M · Anchorage, AKBuilt 1952 · S/N 20398N2246ELauer Richard D · Mount Laurel, NJS/N 17271203N2246JMcmurray Jay C · Niota, TNBuilt 1966 · S/N 15065446N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396N2246YHixon Craig D · Sayre, OKBuilt 1967 · S/N 17700046N22475Ace Aeromotive Inc · Miami, FLBuilt 1968 · S/N 15068306N22477Ray Erin N · Manor, TXFirst renewal noticeBuilt 1968 · S/N 15068307N22479Robinson Paul C · San Francisco, CABuilt 1974 · S/N 17264066N2247JHeathers Houses Foundation Inc · Fort Lauderdale, FLBuilt 1966 · S/N 15065447N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191N22484Tinoco Joseph I · Shoreline, WABuilt 1968 · S/N 15068310N22487Skyguard Instruction LLC · Ann Arbor, MIBuilt 1968 · S/N 15068312N22488Oneal Sean M · Santa Cruz, CABuilt 1968 · S/N 15068313N22489Sky Walker Flight School LLC · Adrian, MIBuilt 1968 · S/N 15068314
Back to AD 87-20-03 R2