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.

N5751BMacon Michael D · Sisters, ORBuilt 1956 · S/N 33751N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751JB & H Drilg · Winnsboro, LABuilt 1971 · S/N 21059451N5751RKummer Brian · Port Orange, FLBuilt 1965 · S/N 17253420N5751TGordon Robert A · North Pole, AKS/N 17251651N5752BWallace Thad Joseph · Mount Shasta, CABuilt 1956 · S/N 33752N5752CNoyes Jeffery A · Bridgeport, TXBuilt 1950 · S/N 19706N5752TStrahan Gary · Beaumont, TXBuilt 1964 · S/N 17251652N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5755ABlue Sky Flyers Inc · Joplin, MOBuilt 1956 · S/N 28355N5755GDestination Alaska Air Service LLC · Homer, AKS/N U20603758N5755JBagge John A · Independence, IABuilt 1974 · S/N 18263520N5755REshbaugh Melvin L · Topeka, KSBuilt 1965 · S/N 17253424N5755TD2 Government Solutions LLC · New Bern, NCBuilt 1964 · S/N 17251655N5756AKunz Isaac A · Texarkana, TXBuilt 1956 · S/N 28356N5756BWages Brent · Rupert, IDBuilt 1956 · S/N 33756N5756CFly48north LLC · Lynden, WABuilt 1950 · S/N 19710N5756RCm3 LLC · North Las Vegas, NVS/N 17253425N5757BWilson Chad R · Port Angeles, WAS/N 33757N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757GWill Cutter G · San Angelo, TXBuilt 1969 · S/N 15071257N5757JAdams Gary A · Alva, OKBuilt 1971 · S/N 21059457N5757TFive Seven Tango Inc · Fitchburg, WIBuilt 1964 · S/N 17251657N5758BBentley John · Bend, ORS/N 33758N5758CFour Mound LLC · Kennewick, WABuilt 1952 · S/N 19712N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5759AFlying K & Associates Inc · Hawthorne, FLBuilt 1956 · S/N 28359N5759JThree Six Golf Ltd · Cary, NCBuilt 1974 · S/N 18263522N5759RP & R Aviation LLC · Edenton, NCS/N 17253428N575AAHanson Dirk Allen · Moorhead, MNS/N 205-0322N575PMLiebfried Andrew H · Lunenburg, MABuilt 1975 · S/N 18264045N575RWWashington County · Hillsboro, ORBuilt 1978 · S/N R1722881N575TDDahl Russell · Nashua, MTBuilt 1976 · S/N 17268034N5760BAbbott Jay D · Rocky Mount, VABuilt 1956 · S/N 33760N5760CHenson Robert H Jr · Lanark, ILBuilt 1950 · S/N 19714N5760GVan De Walle Matthew W · San Antonio, TXBuilt 1969 · S/N 15071260N5761BTerry Canales Attorney At Law Pllc · Edinburg, TXBuilt 1956 · S/N 33761N5762CColescott Zachary · Cleveland, TNBuilt 1950 · S/N 19716N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462N5763EVilla Rafael O · Miami, FLBuilt 1978 · S/N 17271936N5763JLemons Brooks D · Visalia, CABuilt 1971 · S/N 21059463N5763TLumgair David R · Painter, VABuilt 1964 · S/N 17251663N5764AMorrison Benjamin F III · Godley, TXBuilt 1956 · S/N 28364N5765B5765 Bravo LLC · Three Forks, MTBuilt 1956 · S/N 33765N5765CFinnegan John J · North Fort Myers, FLBuilt 1950 · S/N 19719N5765GQuiring Jason L · Terrell, NCS/N 15071265N5765TRawareo LLC · Warsaw, MOBuilt 1964 · S/N 17251665N5766ASoma Holdings LLC · Wasilla, AKBuilt 1956 · S/N 28366N5766BClover Crest II Inc · Key Largo, FLBuilt 1956 · S/N 33766N5766CMacgregor David A Jr · Naples, FLBuilt 1950 · S/N 19720
Back to AD 87-20-03 R2