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.

N7517XHalley Dan R · Avery, TXBuilt 1960 · S/N 17248017N7518MGearin Chad · Portland, ORBuilt 1959 · S/N 55818N7518TWilliams Doyle D · Browning, MOS/N 47118N7519TScud Air 19t LLC · Morgan, UTBuilt 1959 · S/N 47119N7519XSouthern Moulding Acquisition LLC · Marietta, GABuilt 1960 · S/N 17248019N751BKGeneral Aviation LLC · Henderson, NVBuilt 1978 · S/N 17270335N751CFSebec Aviation Services LLC · Abbot, MES/N 18052581N751DRNew Daniel A · Deming, WABuilt 1958 · S/N 51541N751DSHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15062266N751DWGaskins Frank E · Ashland, VABuilt 1981 · S/N 172RG1002N751LSSimpson Simpson Inc · Castana, IABuilt 1954 · S/N 26462N751MCGrubb Kenneth W · Spring, TXBuilt 1963 · S/N 18051236N751SDenson Mark T · Brenham, TXBuilt 1964 · S/N 18051424N7520KGraber Raymond B II · Carson City, NVBuilt 1976 · S/N 18052659N7520MWhitehurst Funeral Chapels Inc · Los Banos, CABuilt 1959 · S/N 55820N7520THartley Chester E · Holts Summit, MOBuilt 1959 · S/N 47120N7520XSunwave Land LLC · Big Spring, TXBuilt 1960 · S/N 17248020N7521K5b 7b Aero LLC · Sandpoint, IDBuilt 1976 · S/N 18052660N7521TPerry Kenneth C Jr · Tucson, AZBuilt 1959 · S/N 47121N7521VLeslie Warren J · Sequim, WABuilt 1976 · S/N 177RG0818N7521XWainwright Donald W · Live Oak, FLS/N 17248021N7522KDewitt David B · Santa Rosa, CABuilt 1976 · S/N 18052661N7522MJohanson Mark E · Ivins, UTS/N 55822N7522TMoffitt Michael M · Wolcottville, INBuilt 1959 · S/N 47122N7522XZitterkopf Gary N · Casper, WYBuilt 1960 · S/N 17248022N7523GTriple J Aviation LLC · Mcconnelsville, OHBuilt 1970 · S/N 17259223N7523MW R Aviation Inc · Stigler, OKBuilt 1959 · S/N 55823N7523VTwc Aviation Services LLC · Merritt Island, FLBuilt 1975 · S/N 177RG0820N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224N7524MRange Shaun M · Brighton, MIS/N 55824N7524TBohn Flying LLC · Tijeras, NMBuilt 1959 · S/N 47124N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226N7526MHerning Benjamin N · Chugiak, AKS/N 55826N7526TJennen David · Erhard, MNBuilt 1960 · S/N 47126N7526XWeickum Lee A · Monroe, ORBuilt 1960 · S/N 17248026N7527KMark D Jones · Kremmling, COBuilt 1976 · S/N 18052662N7527MGarfoot William K · Verona, WIS/N 55827N7527TButcher Isis F · Marietta, OKBuilt 1959 · S/N 47127N7527XRankin Scott W · Kansas City, MOBuilt 1960 · S/N 17248027N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228N7528XJewell Burton Connor Jacob · Pensacola, FLBuilt 1960 · S/N 17248028N7529GRibeiro Marcos F · Okeechobee, FLS/N 15074687N7529KBarak David T · Mountain Home, IDBuilt 1976 · S/N 18052663N7529NNoam Eli M · New York, NYS/N 18263232N7529U20 Awesome LLC · Albuquerque, NMBuilt 1962 · S/N 17248795N7529XBrown Anthony W · Sacramento, KYS/N 17248029N752DMS&M Holdings LLC · Oak Ridge, LABuilt 1962 · S/N 18254005N752MFEpperly David J · New Richmond, WIBuilt 1974 · S/N 15075977N7530KMcmanigle Jeffrey M · Osakis, MNBuilt 1976 · S/N 18052664N7530TBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 47130
Back to AD 87-20-03 R2