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.

N2561UNeinast Jeffrey J · Olton, TXBuilt 1963 · S/N 17250161N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061N2562DWalker Garrett J · Anchorage, AKBuilt 1952 · S/N 20714N2562LWilkey Paul W · Sullivan, INBuilt 1967 · S/N 17255762N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262N2563JKrebs Charles · Suwannee, FLFirst renewal noticeBuilt 1964 · S/N 15061063N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330N2563VSchneider Gregory M · Bridger, MTS/N 18068N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264N2564UBurris Bruce · Deer Park, WAS/N 17250164N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617N2564YBrewer George H · Muskegon, MIBuilt 1962 · S/N 17249864N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564N2565CFolgner Robert E · Dana Point, CARegistration revokedBuilt 1954 · S/N 26209N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865N2565JRohl Bradley S · Thompson, OHBuilt 1965 · S/N 15061065N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265N2566CJohnson James K · Sandy Valley, NVBuilt 1954 · S/N 26207N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266N2566YAns Aircraft LLC · Midland, TXS/N 17249866N2567DHaasl Glen D · Chugiak, AKBuilt 1952 · S/N 20719N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267N2567URegistration Pending · Fort Worth, TXRegistration pendingBuilt 1963 · S/N 17250167N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868N2568ULuce Mark E · Tucson, AZBuilt 1963 · S/N 17250168N2568VFarringer Steven R · Columbia City, INBuilt 1948 · S/N 18073N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068N2569JMapes Peter B · Oscoda, MIS/N 15061069N2569KHarris Curtis M · Anchorage, AKS/N 18052991N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869N2569UHalladay Roy · Erie, COBuilt 1963 · S/N 17250169N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958N256NYAlexander David H · Warrensburg, NYBuilt 1956 · S/N 29049N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336N2570JKnutson Family Ltd Partnership 2 · Chetek, WIBuilt 1964 · S/N 15061070N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770N2570QGolden Thomas J · Bishop, GAS/N 18257770N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270N2570ZLucci Robert J · Long Lake, NYBuilt 1963 · S/N 185-0570N2571CLane Steven A · Rockwood, MEBuilt 1952 · S/N 26215N2571DLiebsch Greg A · Gilbert, AZBuilt 1952 · S/N 20723
Back to AD 87-20-03 R2