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.

N5107EMixon Dennis E · Topsham, MEBuilt 1958 · S/N 50407N5107FFly Idaho LLC · Meridian, IDBuilt 1966 · S/N 17255107N5107HFlyit LLC · Camas, WABuilt 1975 · S/N 17265342N5107WRugger Investment Group LLC · Sheridan, WYBuilt 1981 · S/N P21000640N51081N51081 LLC · Palm City, FLS/N 17274264N51082Fremont Aviation Inc · Fremont, NES/N 15069750N51088Otterson Val Stanford · Willows, CABuilt 1968 · S/N 15069756N5108DTeam Gateway LLC · Lewes, DES/N 51208N5108FCooper Gerald W · Kennewick, WABuilt 1965 · S/N 17252727N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705N5108LHellix LLC · Charlotte, NCS/N 15284266N5108NBerry Lisa A · Yuba City, CAS/N 18267520N5108QPardue William C Jr · Leesville, LABuilt 1975 · S/N U20603060N5108TMarks Daniel A · Portersville, PABuilt 1977 · S/N 18503274N51092Sylvania Airport LLC · Sturtevant, WIS/N 17274265N5109APace Glen M · Columbia, MSS/N 15069450N5109BOverlander Aviation LLC · Palo Alto, CABuilt 1979 · S/N 15283750N5109DCaine Jennifer M · Rigby, IDBuilt 1958 · S/N 51209N5109QRmcb LLC · Kalispell, MTBuilt 1972 · S/N 21059609N510AASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064699N510ARBrudigam Norman · Lafayette, CABuilt 1981 · S/N 18267733N510ECState Of Tennessee Department Of Transportation · Nashville, TNBuilt 1984 · S/N 18268421N510FMckeen Charles Dale · Howard Lake, MNBuilt 1956 · S/N 32451N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470N510SUOhio State University · Columbus, OHBuilt 1973 · S/N 15074297N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140N51102Tidwell Brian D · Portland, ORBuilt 1968 · S/N 15069766N51103Malachi Israel P · Superior, WIBuilt 1968 · S/N 15069767N51105Du Bois Aviation Inc · Chino, CAS/N 15069769N51106Iron Horse Leasing LLC · Platteville, WIBuilt 1968 · S/N 15069770N51108Jstream Lc · Sheridan, WYBuilt 1968 · S/N 15069772N51109Dickhaut Olivia N · North Palm Beach, FLS/N 17274268N5110ADickens Dennis D · Noble, OKBuilt 1955 · S/N 28110N5110DBlaine Wright Inc · Polson, MTBuilt 1958 · S/N 51210N5110EHartley Kirk R · Palmer, AKBuilt 1958 · S/N 50410N5110UGiese Shari L · Wasilla, AKBuilt 1964 · S/N 2060110N51113Wander Robert P · Faribault, MNBuilt 1968 · S/N 15069775N51115Bernhardt Michael J · North Branch, MNS/N 15069777N51116Koehn Mark W · Elkader, IAS/N 15069778N5111GHammond Jason · Nevada City, CABuilt 1971 · S/N 18260746N51124Kd Farms Inc · Cosmos, MNBuilt 1968 · S/N 15069781N51126Ostrander William P · Millerton, PABuilt 1968 · S/N 15069782N5112DScootair LLC · Alburgh, VTBuilt 1958 · S/N 51212N5112ETail Wheel Excursion LLC · Redmond, ORBuilt 1958 · S/N 50412N5112GCrawford Law Pllc · Selah, WABuilt 1967 · S/N 18258496N5112JDenslow Carl W · Barto, PABuilt 1952 · S/N 20356N5112NRcr Aviation LLC · Cave Creek, AZBuilt 1980 · S/N 18267524N51133Riegle Shannon D · Muncie, INBuilt 1968 · S/N 15069784N51134Jstream Lc · Sheridan, WYBuilt 1968 · S/N 15069785N51135Liberty Belle Aviation LLC · Vista, CABuilt 1968 · S/N 15069786
Back to AD 87-20-03 R2