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.

N5588TMoore Robert L · Sublette, KSBuilt 1964 · S/N 17251488N5589RKern Eric M · Wesley Chapel, FLBuilt 1965 · S/N 17253191N5590BChambless Ronald Hugh · Abernathy, TXBuilt 1956 · S/N 33590N5590GDelci Dino J · Tempe, AZBuilt 1969 · S/N 15071090N5590TGlendening Douglas W · Naples, FLS/N 17251490N5591BRegistered aircraftBuilt 1956 · S/N 33591N5591TNordstrom Terry G · Scottsdale, AZBuilt 1964 · S/N 17251491N5592BJopson James M · Newman Lake, WABuilt 1956 · S/N 33592N5592CGrah David B · Bishop, CABuilt 1950 · S/N 19821N5592GFleming Randy · Concord, NCS/N 15071092N5592RAbbott Cedric M · Buckfield, MEBuilt 1965 · S/N 17253196N5593BQualick Robert N · White Rock, NMBuilt 1956 · S/N 33593N5593GDebartolo Samuel · Swampscott, MABuilt 1969 · S/N 15071093N5593MWeaver Carl W · Halstead, KSS/N 26967N5593RMaddox Tracey A · Adamsville, TNBuilt 1965 · S/N 17253197N5594BPara-Plane Aviation Inc · Thomasboro, ILBuilt 1956 · S/N 33594N5594GDavis Joseph S · Andalusia, ALBuilt 1969 · S/N 15071094N5595BLahn Dave R · Quincy, WABuilt 1956 · S/N 33595N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897N5595GZortman Micky P · Mexico, MOS/N 15071095N5595RTailwind Enterprises LLC · Edwardsville, ILBuilt 1965 · S/N 17253200N5596BFlyventure LLC · Fort Wayne, INBuilt 1956 · S/N 33596N5596CPatterson Morgan B · Yuma, AZBuilt 1950 · S/N 19650N5596RRegistration Pending · Crossville, TNRegistration pendingBuilt 1965 · S/N 17253201N5597BBucher Burton W · Waukegan, ILBuilt 1956 · S/N 33597N5597CAom Aircraft LLC · Wilmington, DEBuilt 1950 · S/N 19651N5597ECtj Flyers LLC · Bowdon, GABuilt 1978 · S/N 17271898N5597GRegistration Pending · Washington, UTRegistration pendingBuilt 1969 · S/N 15071097N5597RStevens Daniel T · Trenton, MOBuilt 1965 · S/N 17253202N5598RCross Brian K · Winters, CABuilt 1965 · S/N 17253204N5599CBenien Dennis A · Napoleon, OHBuilt 1950 · S/N 19653N5599KDayton Walter S · Napa, CAS/N R18200922N559AKBurton John · Nacogdoches, TXS/N 18258213N559DBRundle James R · Sparks, NVBuilt 1969 · S/N 18260178N559KMRegistered aircraftBuilt 1982 · S/N 18268187N559MCBkjm LLC · Blanchard, OKBuilt 1978 · S/N 18503479N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335N55AXWhite Drew C · Granbury, TXBuilt 1964 · S/N 185-0723N55BEPenultimate 210r LLC · Cumming, GAS/N P21000873N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434N55CKDobson Billy M · Tichnor, ARS/N R1722409N55CPCharli Papa LLC · Clovis, NMBuilt 1965 · S/N 18256550N55CSHammond Neil K · Manhattan, KSBuilt 1965 · S/N 337-0222N55DLHill Brock E · Palouse, WABuilt 1955 · S/N 31362N55EUC L Holdings LLC · Washington, DCS/N P21000394N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HJRadlinger Joseph · Hudson, WIBuilt 1977 · S/N 18265736N55KAEvans Dick Trustee · Riverside, CAS/N 18052987N55KHDietle Kurt · Valley Springs, CABuilt 1979 · S/N R18201104N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344
Back to AD 87-20-03 R2