AD 87-20-03 R2

Registered aircraft · 54,015

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.

N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610TMulkey Randall L · Wellston, OKBuilt 1960 · S/N 57410N9610XSutton George E · Fullerton, CABuilt 1961 · S/N 21057910N9611HTarheel Aviators LLC · Cary, NCBuilt 1981 · S/N 18267972N9611XWinston Air LLC · Haleyville, ALS/N 21057911N9612G4-F Flyers LLC · Haysville, KSBuilt 1974 · S/N 18263408N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901N9613BLiebsch Mark W · Reno, NVBuilt 1957 · S/N 32910N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264N9613TMilleman Barry M · Monticello, INBuilt 1960 · S/N 57413N9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeS/N U20606575N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962TN9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699N9614TLucas Lester L · Napa, CABuilt 1960 · S/N 57414N9614XMountain Air Flying LLC · Brigham City, UTBuilt 1962 · S/N 21057914N96167Westrum Durl Troy · Norwalk, IAS/N 55203N9616ELove James H · Springville, ALBuilt 1984 · S/N 18268429N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701N9616XJim Barrett Photography Inc · Honolulu, HIBuilt 1961 · S/N 21057916N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702N9617ZWright William F Trustee · Anchorage, AKS/N U20606578N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034N9618GH&M Ltd · Warren, IDS/N 18263409N9618HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1977 · S/N 18503454N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924N9619EHofer Terril D · Maple Grove, MNBuilt 1984 · S/N 18268430N961ERCoyote Air LLC · Hermiston, ORBuilt 1979 · S/N 18266923N961LCSanpete Aviation LLC · Nephi, UTS/N 17250480N961UTRepllp LLC · Marietta, GABuilt 1977 · S/N R1722337N961WSWalt Schwartz Aviation LLC · Louisville, KYBuilt 1985 · S/N 18268462N9620EJones Benjamin J · Little Rock, ARBuilt 1984 · S/N 18268431N9620GMehling Robert C · Hardin, MTS/N 18801564N9620QObar Danny · Middleton, IDBuilt 1979 · S/N 18503780N96218Link Jessica Elizabeth · Castalia, OHBuilt 1967 · S/N R172-0214N9621BLee Gerald R · Glennallen, AKBuilt 1957 · S/N 32918N9621TJ D Kraemer Enterprises LLC · Fargo, NDS/N 57421N9621VHathor Aviation LLC · Johnstown, COBuilt 1974 · S/N 17264401N96227Civil Air Patrol Inc · Montgomery, ALBuilt 1983 · S/N 17276045N9622BSmith Glenn R · Palmer, AKBuilt 1957 · S/N 32919N9622HSanders Flight Training Center LLC · Jasper, ALBuilt 1975 · S/N 17266272N9622QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265707N9623GBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802596TN9623RUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606906
Back to AD 87-20-03 R2