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.

N5963BJones Damon · Lafayette, ORBuilt 1956 · S/N 33963N5963GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071463N5963TKnight Luke O · Monroe, IAS/N 15060663N5964ABeachy Matthew · Russellville, KYBuilt 1956 · S/N 28564N5964BBailey Steven W · Puyallup, WABuilt 1956 · S/N 33964N5964TColburn Shawn M · Monroe, GABuilt 1964 · S/N 15060664N5965BMathison John M · Vancouver, WABuilt 1956 · S/N 33965N5965GCavu Pilot LLC · Powell, TNS/N 15071465N5965JI & U Aviation LLC · Lexington, SCS/N A1500265N5965TJones Robert · Gulf Breeze, FLBuilt 1964 · S/N 15060665N5966AHutchins Charles Norman · Wildomar, CAS/N 28566N5966BLemaster Roxanne · Brookville, OHBuilt 1956 · S/N 33966N5966JWydronek Joseph A · Tucson, AZBuilt 1975 · S/N 18263590N5967BKelley William P · Herron, MIBuilt 1956 · S/N 33967N5968BLawrence Jon D · Williamsburg, MIBuilt 1957 · S/N 33968N5968JAragon Cecilia R · Sequim, WABuilt 1971 · S/N A1500268N5969ANichols Patricia · Varnado, LABuilt 1956 · S/N 28569N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969N5969RFrederick Clint A · Mattoon, ILBuilt 1965 · S/N 17253638N596DLCrater Lake Leasing LLC · Las Vegas, NVBuilt 1977 · S/N 18265642N5970GOritz Benjamin Dale · Senoia, GABuilt 1969 · S/N 15071470N5970TOmlid Robert L · Watford City, NDBuilt 1964 · S/N 15060670N5971ABolton Warren S Jr · Niles, MIBuilt 1956 · S/N 28571N5971RBowers Joshua Shane · Ballston Lake, NYBuilt 1965 · S/N 17253640N5972AWillams Christopher R · Lingleville, TXBuilt 1956 · S/N 28572N5973RGrit Services LLC · Manila, ARS/N 17253642N5975ADuke Robert D · Darrouzett, TXBuilt 1956 · S/N 28575N5975RBates Kristopher M · Zanesville, OHBuilt 1965 · S/N 17253644N5976AN5976a LLC · Marathon, FLS/N 28576N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976RMeadows Robert K · Macon, GABuilt 1965 · S/N 17253645N5976TBickel Garret E · Perry, MOBuilt 1964 · S/N 15060676N5977JTemplet Eugene P · Pearl River, LABuilt 1971 · S/N A1500277N5977RWhitney Nathan B · Falkville, ALS/N 17253646N5977TBass Daniel J · Winona, MNBuilt 1964 · S/N 15060677N5978JVigil Clyde R · Chimayo, NMS/N A1500278N5979GHargrave Michael K · Gladwin, MIBuilt 1969 · S/N 15071479N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597KKriedeman Daniel Paul · Port Orange, FLBuilt 1949 · S/N 7403N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N5980AFinstad Brandon C · South Weber, UTBuilt 1956 · S/N 28580N5980GBall Albert N · Chugiak, AKBuilt 1969 · S/N 15071480N5980RPetes LLC · Pompton Plains, NJBuilt 1965 · S/N 17253649N5981RKenney Anthony G · Oviedo, FLBuilt 1965 · S/N 17253650N5981TLowe David · Sacramento, KYS/N 15060681N5982FCharles James Brown · Littlefield, TXS/N 21058982N5982TLifto Thomas W · Barronett, WIBuilt 1964 · S/N 15060682N5983BNck Consulting LLC · Scottsdale, AZBuilt 1956 · S/N 33983N5983ESweet R Kent Trustee · Reno, NVBuilt 1983 · S/N 18268341N5983JIlarraza Gilberto C · Sabana Hoyos, PRS/N 17273848
Back to AD 87-20-03 R2