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.

N5795CHancock James T · South Saint Paul, MNBuilt 1950 · S/N 19839N5795GRhodes Tom B · Dallas, TXBuilt 1969 · S/N 15071295N5796CJohnson Terry A · Idaho Falls, IDBuilt 1950 · S/N 19750N5796JRegistered aircraftBuilt 1971 · S/N 21059496N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475N5797AEver Fast LLC · Kalispell, MTS/N 28397N5797CNorris Terry F · Rockford, ILBuilt 1950 · S/N 19751N5797FWright James J · Owens Cross Roads, ALBuilt 1973 · S/N 18261914N5797JLindsay Properties LLC · Kosciusko, MSBuilt 1975 · S/N 18263543N5797RRiggs Laura A · Middleburg, FLBuilt 1965 · S/N 17253466N5798ABowman Ronald J · Bellefonte, PABuilt 1956 · S/N 28398N5798RRatcliff Bruce A · Plain City, OHBuilt 1965 · S/N 17253467N5799AMiller Lavon S · Eureka, NVS/N 28399N5799CLewellen Donnie J · Friona, TXBuilt 1950 · S/N 19753N5799GBafa LLC · Lewes, DEBuilt 1969 · S/N 15071299N5799JBritt Demolition And Recycling Inc · Hanceville, ALBuilt 1971 · S/N 21059499N5799TGs Air LLC · Sioux Falls, SDS/N 17251699N579JDForst Kenneth D DBA · Grand Rapids, MNBuilt 1980 · S/N 18503964N579JKKopacz Thomas H · Glen Flora, WIBuilt 1973 · S/N 17261765N579KRed Plane Aviation LLC · Key West, FLBuilt 1960 · S/N 17247827N579MAJones Andrew W · Turner, MTBuilt 1967 · S/N 15068081N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564N57BMHuerta Holdings Inc · Santa Ana, CABuilt 1973 · S/N 17261980N57BRRamsey Brent C · Tulsa, OKBuilt 1979 · S/N 18267277N57CCavu Aviation LLC · Tulsa, OKBuilt 1973 · S/N P3370091N57CABlue Sky Management LLC · Stevens Point, WIBuilt 1975 · S/N 18502698N57DLGarrett Gary M · Reno, NVBuilt 1978 · S/N 18266366N57EAEwing Andrew M · Santa Rosa Beach, FLBuilt 1977 · S/N 177RG1169N57HKell Thomas G · Anchorage, AKBuilt 1958 · S/N 50286N57MJFrederick Bradley W · Corvallis, ORFirst renewal noticeBuilt 1969 · S/N 18259651N57MTYee Michael P · Missouri City, TXS/N 21058133N57MWFogal Brian K · Chambersburg, PABuilt 1957 · S/N 29688N57PHEldredge Bradley P · Highland, UTS/N 18265514N57VBKlingebiel Kurt · Leonardtown, MDBuilt 1985 · S/N 17276476N57WHMoon Richard B · Arizona City, AZBuilt 1976 · S/N 17267069N5800ACarson A Jane · Vance, ALBuilt 1956 · S/N 28400N5800CFreixas Enrique · Torrance, CABuilt 1957 · S/N 36435N5800RPomeroy Cattle Ranch LLC · Kalispell, MTS/N 17253469N5802RMiller Chris D · Collierville, TNBuilt 1965 · S/N 17253471N5803BMccole Kevin · Brookline, NHFirst renewal noticeS/N 33803N5803EIrwin Donald L · Emporia, KSBuilt 1978 · S/N 17271938N5803TD&R Aviation LLC · Calhoun, GABuilt 1964 · S/N 185-0703N5804ASandall Evan R · Bonsall, CABuilt 1956 · S/N 28404N5804BShoemaker Mark T · Springfield, ORBuilt 1956 · S/N 33804N5804GSkylands Air LLC · Port Orange, FLBuilt 1969 · S/N 15071304N5804JScott Amy · Henniker, NHS/N 18263547N5804RGriffin David Charles · Palmyra, PABuilt 1965 · S/N 17253473N5805AVictory Aero Tech Inc · Camarillo, CABuilt 1956 · S/N 28405N5805JLanni Ronald A · Fairbanks, AKBuilt 1970 · S/N 18501774N5806FJones Flying Association · Wilmington, DEBuilt 1966 · S/N 21058806
Back to AD 87-20-03 R2