OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N5822GRada Michael F · Eagan, MNS/N 15071322N5822JFinch Eric · Cypress, TXBuilt 1975 · S/N 18263556N58235Collins Wayne J · Lubbock, TXBuilt 1966 · S/N 188-0033N5824BPritchard Joshua Corey · Carey, IDBuilt 1956 · S/N 33824N5824GNairways LLC · Dix Hills, NYS/N 15071324N5825AHayes William A · Falls Of Rough, KYS/N 28425N5825GAuxano Aviation LLC · Newark, DES/N 15071325N5826BGiger Janice F · Weston, ORBuilt 1956 · S/N 33826N5826GKingdom Art LLC · Cologne, MNS/N 15071326N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827N5827GHutchinson Linda M · Grass Lake, MIBuilt 1969 · S/N 15071327N5828APerera Carl Anthony · Gilbert, AZBuilt 1956 · S/N 28428N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828N5828GSmith Joshua B · Kenai, AKS/N 15071328N5828RBismark Public Schools · Bismarck, NDBuilt 1971 · S/N 15072234N5829AVine Clayton A · Wolf Point, MTS/N 28429N5829BFair Skies Inc · Dade City, FLBuilt 1956 · S/N 33829N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829N58302Gillett John W · Hillsboro, ORBuilt 1972 · S/N 18501966N5830AChapman Erin A · Edmond, OKBuilt 1956 · S/N 28430N5830BHaberich Alexander J · Avon, COBuilt 1956 · S/N 33830N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830N5830GDunn Michael J · Ozark, ARBuilt 1969 · S/N 15071330N5830JMontague Brett A · Van Buren, OHBuilt 1970 · S/N 18501799N58316Labelle-Hamer Brendan T · Fairbanks, AKBuilt 1977 · S/N 18503284N5832ABurgess Kelly M · Dannebrog, NEBuilt 1956 · S/N 28432N5832BAircraft Structural Repair Inc · Hamilton, MTS/N 33832N5832GFitzgibbon Patrick D · Waterloo, WIS/N 15071332N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5833AJones Curtis DBA · Jacksonville, NCBuilt 1956 · S/N 28433N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5835ABoyd Edward L · Riverton, ILBuilt 1956 · S/N 28435N5835BJepson Duwayne D · Frazee, MNBuilt 1956 · S/N 33835N5836AMallach Kenneth L · Gatesville, TXFirst renewal noticeBuilt 1956 · S/N 28436N5836JMeyerkorth Aviation LLC · Rock Port, MOBuilt 1970 · S/N 18501805N5837ACrawford Mike R · Flowery Branch, GABuilt 1956 · S/N 28437N5839BReffett John S · Eagle River, AKBuilt 1956 · S/N 33839N5841ASeipel Damian Y · Huntington Beach, CABuilt 1956 · S/N 28441N5841BFultz Wilbur R · Fort Benton, MTBuilt 1956 · S/N 33841N5841GCrawford Trevor Nicolas · Potter Valley, CABuilt 1956 · S/N 28499N5842BPietrs Michael · Shoreview, MNBuilt 1956 · S/N 33842N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842N5842TArapaho Air LLC · Walnut Grove, CABuilt 1964 · S/N 185-0742N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604N58442Van Vleet Dennis · Kingman, AZBuilt 1973 · S/N 18262066N58443Szeliga Mark H · Bethel, MEBuilt 1973 · S/N 18262067N5844GLummus David R · West Point, MSBuilt 1969 · S/N 15071344N58454Thiele John E · Harrison, IDBuilt 1973 · S/N 18262074
Back to AD 87-20-03 R2