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.

N1807CMorriss Elvin A · Springdale, ARBuilt 1952 · S/N 25951N1807RVeldman Richard D · Laporte, INBuilt 1978 · S/N R18200566N18081Eyes Above LLC · Hampton Falls, NHBuilt 1972 · S/N 15073780N18088Durin Steven C · Steward, ILS/N 15073784N1808MPenner Paul R · Bel Air, MDS/N 25952N1808XM&M Land Company LLC · Marietta, OHBuilt 1964 · S/N 18255908N1808YHardy Russell L · Rimrock, AZBuilt 1962 · S/N 17249408N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008N1809MSkymaster-173 LLC · New Bern, NCBuilt 1971 · S/N 33701409N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009N180AHigginbottom Nathan · Cave City, ARBuilt 1954 · S/N 31090N180AAButler Tracey D · Buckley, WABuilt 1973 · S/N 18052399N180ABFoster Bradley J · Wichita, KSBuilt 1953 · S/N 30210N180AFRegistered aircraftBuilt 1957 · S/N 32809N180AGAg Leasing LLC · Wilmington, DES/N 18052187N180AHSwiss Arctic Flyers Inc · Lewes, DEBuilt 1981 · S/N 18053192N180AKBecker Kurt G · Dexter, NMBuilt 1955 · S/N 31349N180ANJones Marvin B · Farmerville, LABuilt 1957 · S/N 50008N180APAir Plains Services Corp · Wellington, KSBuilt 1965 · S/N 18051472N180AQTracy Michael R · Santee, CABuilt 1967 · S/N 18051848N180AXNoyes Abigail · North Pole, AKBuilt 1969 · S/N 18051910N180AYPerkins Paul Fortaine · Anchorage, AKS/N 50052N180AZMohr Elizabeth G · Brandon, MSBuilt 1974 · S/N 18052433N180BADavis Robert D · Camas, WAS/N 18052419N180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18053103N180BDSanderson Bryan D · Emmett, IDBuilt 1954 · S/N 30848N180BFComunale Anthony S · Roxbury, CTBuilt 1973 · S/N 18052402N180BGCmw Aircraft LLC · Hailey, IDS/N 31372N180BHMorris Christopher H · Valparaiso, INS/N 18052132N180BKKrissman Ryan · Gallup, NMBuilt 1970 · S/N 18052120N180BRDainas Barry · Port Orange, FLBuilt 1955 · S/N 31386N180BSSerie Dennis P · Chugiak, AKBuilt 1959 · S/N 624N180BTAerobug LLC · League City, TXBuilt 1967 · S/N 18051815N180CBrown Hector M · Glenwood Springs, COBuilt 1956 · S/N 32312N180CBSmith Dennis A Trustee · Salem, ORBuilt 1955 · S/N 31489N180CDHicks P David · Heber City, UTS/N 18052310N180CETailwinds Ranch LLC · Orlando, FLBuilt 1976 · S/N 18052669N180CJWipaire Inc · South Saint Paul, MNBuilt 1975 · S/N 18052539N180CRSnow Robert J · La Mesa, CAS/N 30627N180CTPerformance Paradise LLC · Eagle Harbor, MIBuilt 1959 · S/N 50632N180CYYoung Ideas LLC · Post Falls, IDS/N 50460N180DProuty Edgar C Jr · Sebec, MES/N 31168N180DAAalgaard Raymond F · Hollister, CABuilt 1956 · S/N 32476N180DCWilson Lewis G Jr · Rock Hill, SCBuilt 1965 · S/N 18051605N180DFSale Reported · Anchorage, AKSale reportedS/N 31892N180DGHodnett Stephen T · Canadian, TXBuilt 1955 · S/N 31280N180DHMarden Aero Services LLC · Erwinna, PABuilt 1975 · S/N 18052615N180DJHuang Sophie M · Newcastle, WABuilt 1954 · S/N 31154N180DKGriffin Vaughn · Spirit Lake, IDBuilt 1974 · S/N 18052456
Back to AD 87-20-03 R2