OpenAirDocs.org
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.

N6211TPeterson Troy · Karlstad, MNS/N 15060911N6212FParker Helicopter LLC · Watsonville, CABuilt 1979 · S/N 17273167N6212GLionheart Aviation Services LLC · Fairfax, VABuilt 1979 · S/N 17273579N6212RPliego M Guillermo M · Corpus Christi, TXS/N 172RG0117N6212THooking Bull Investments LLC · Tallulah, LAS/N R18201939N6212YHoran Jack F · De Berry, TXS/N 15061390N6213AHerbert Ronald J · Anchorage, AKBuilt 1956 · S/N 33013N6213EBeesley Charles F III · Cole Camp, MOBuilt 1959 · S/N 46313N62142Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 17275218N62144Intermill Glen M Trustee · Eagle Point, ORBuilt 1981 · S/N 17275219N6214ASkydive Cape Cod Inc · Caddo Mills, TXBuilt 1956 · S/N 33014N6214KHamptonville Aviation LLC · Hamptonville, NCBuilt 1975 · S/N 15077590N6214SRex Douglas A · Marion, INBuilt 1967 · S/N 15067014N6214VRegistered aircraftBuilt 1968 · S/N U206-1189N6215AC & B Aerial Transport Inc · Wilmington, DEBuilt 1956 · S/N 33015N6215BArtskills Inc · Bethlehem, PABuilt 1977 · S/N 18266135N6215EReinders Gary J · Orange City, IABuilt 1958 · S/N 46315N6215GSkagit Airport Eaa Chapter 818 · Shoreline, WAS/N 15071715N6215SSmith Clifford W III · Exeter, CABuilt 1967 · S/N 15067015N6216ASnow Terry R · Oak Harbor, WABuilt 1956 · S/N 33016N6216EPratt Joseph O · Wasilla, AKBuilt 1958 · S/N 46316N6216NHitt Kenneth A · Driftwood, TXBuilt 1980 · S/N 18267799N6216RRegistered aircraftBuilt 1979 · S/N 172RG0119N6216STms Holdings LLC · Neenah, WIBuilt 1967 · S/N 15067016N6217ESchiffel Peter W · Pequannock, NJBuilt 1958 · S/N 46317N6217KIoannou Yiannakis C · Wilmington, NCBuilt 1975 · S/N 15077593N6217RCampbell J R Jr · Bell, FLBuilt 1965 · S/N 15061517N6217SKent J'Amy L · Chewelah, WAS/N 15067017N6217TTaylor Nathan E · Spanishburg, WVS/N 15060917N6218EZephyrhills Flying Club Inc · Tampa, FLBuilt 1958 · S/N 46318N6218GGoatley Valerie M · Springfield, KYBuilt 1961 · S/N 17248655N6218RAnnala John H · Dacula, GAS/N 15061518N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299N62195Aire Services LLC · Barrigada, GUS/N 17275226N6219EOaks Randall K · Oxnard, CABuilt 1958 · S/N 46319N6219FAircraft Rental Services LLC · Arlington, TNBuilt 1975 · S/N 18264126N6219KIrwin Michael C · North Fort Myers, FLBuilt 1975 · S/N 15077594N6219NMiles Media LLC · Red Lodge, MTBuilt 1980 · S/N 18267802N6219RRegistered aircraftBuilt 1965 · S/N 15061519N6219UHardy Jeffrey T · Ellsworth, MEBuilt 1969 · S/N 18052019N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069N621APEast Moriches Aerial Ads Ltd · Ridge, NYBuilt 1971 · S/N 15073078N621BAWilliams Travis D · Antlers, OKBuilt 1980 · S/N 15284523N621BKMy170b LLC · Everett, WAS/N 20819N621DCResource Extension LLC · Jupiter, FLBuilt 1980 · S/N 172RG0756N621DHPic Aviation LLC · Fort Valley, GABuilt 1978 · S/N R18200143N621GTFox Edward Philip Jr · New Market, ALS/N M337-0292N621MAAnderson Keith R · Norwood, MABuilt 1964 · S/N 15060905N621MRElliott Michael R · Friendswood, TXBuilt 1972 · S/N 15073969N621PAWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284171
Back to AD 87-20-03 R2