OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N8319AWhitney Bill · Anacortes, WABuilt 1952 · S/N 25171N8319BLobue Andrew N · Gresham, ORBuilt 1957 · S/N 36119N8319LLaudon Piper C · Anchorage, AKS/N 17256519N831CBSummersell Steven K · Pensacola, FLBuilt 1966 · S/N 18257454N831DC831 Aviators LLC · Monterey, CABuilt 1969 · S/N 18259896N831DTR & R Plane LLC · Lewiston, IDBuilt 1979 · S/N 18267186N831HNChambers Jack · Sonoma, CAS/N R18200885N831LLState Of Illinois · Springfield, ILS/N 18266533N831NCCole Curtis J · Loveland, COBuilt 1958 · S/N 55432N831PRThomas Bruce A · Mount Juliet, TNS/N U20603452N831PZHildebrant Thomas M · Ringling, OKBuilt 1974 · S/N 18263091N831RRFresh Farms Inc · King City, CABuilt 1986 · S/N 21064994N831SMSkowhegan Leasing Inc · Skowhegan, MEBuilt 1968 · S/N 18051980N831VZMelbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276416N8320MBoyce Dale M · Southport, NCBuilt 1976 · S/N 18264592N8320TMoeller Channing T · Huntsville, ALBuilt 1961 · S/N 17557020N8320XHagovsky Thomas C · Attica, INBuilt 1961 · S/N 17248820N8320ZDeel John Tate · Hico, WVS/N 2050320N8321BSkyhawk18 LLC · Opa Locka, FLBuilt 1957 · S/N 36121N8321GSilveria Clifford J · Humble, TXBuilt 1965 · S/N 15062421N8321UBoss Bradley J · Clarksville, TNBuilt 1964 · S/N 17252221N8321ZOverholt Air LLC · Wilmington, DEBuilt 1963 · S/N 205-0321N8322AFlack James R Trustee · Loudonville, OHBuilt 1952 · S/N 25174N8322JMiller Patrick · Riverside, CABuilt 1967 · S/N 15066222N8322UBurkett Kevin H · Portland, TXBuilt 1964 · S/N 17252222N8323EBrod Norman B Trustee · Napa, CABuilt 1984 · S/N 18268391N8323GRusso Dobye G · Clinton, OKBuilt 1965 · S/N 15062423N8323JKc Eagles Soaring Club · Gardner, KSBuilt 1967 · S/N 15066223N8323MBean Danny O · Mulkeytown, ILBuilt 1969 · S/N A1500023N8323UFortman Steven W · Minneapolis, MNBuilt 1964 · S/N 17252223N8323XHumpage Jason H · Eugene, ORBuilt 1961 · S/N 17248823N8324BVitt Steven · Lecanto, FLBuilt 1957 · S/N 36124N8324EGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 17272189N8324GDexter Brady R · Chambers, NES/N 15062424N8324MKnox John D · Broken Arrow, OKBuilt 1969 · S/N A1500024N8324SWhat Next? LLC · Fallon, NVBuilt 1965 · S/N 18256424N8324XJohnson Scott A · Missoula, MTBuilt 1961 · S/N 17248824N8325ASutton Aircraft Salvage LLC · Palmer, AKS/N 25177N8325BDeckard Leroy Jr · Waller, TXS/N 36125N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225N8326ARacoon Aviation LLC · San Antonio, TXBuilt 1952 · S/N 25178N8326UHill John R · Seattle, WABuilt 1976 · S/N 15077920N8326XFlores Thomas E · Balch Springs, TXS/N 17248826N8327JSaunders Grant J · Sebring, FLBuilt 1967 · S/N 15066227N8327MArch Frederick W Jr · Lake Placid, FLBuilt 1969 · S/N A1500027N8327TMatson Donald Jr · Lake Stevens, WABuilt 1961 · S/N 17557027N8327XTwo Seven Xray LLC · Paradise Valley, AZS/N 17248827N8328BMontpelier Gary L · W Chazy, NYBuilt 1957 · S/N 36128N8328JTreat James · Batesville, ARBuilt 1967 · S/N 15066228N8328MLuker Victor R Jr · Terrell, TXS/N A15000028
Back to AD 87-20-03 R2