OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N5670UNelson Bros Farms · Hector, MNS/N 28-26467N56713Vaillancourt Marc H · Milford, MABuilt 1973 · S/N 28-7425023N56714Richman Martin S Trustee · Leawood, KSBuilt 1973 · S/N 28-7425024N56717Hp Flight Service LLC · San Antonio, TXBuilt 1973 · S/N 28-7405028N56720Precision Flight Training Inc · Newberg, ORBuilt 1973 · S/N 28R-7435034N56723Sewell David J · Largo, FLBuilt 1973 · S/N 28-7425025N56724Marianas Air Transfer Inc · Tinian, MPBuilt 1973 · S/N 28-7425026N56728Morris Air LLC · Tillar, ARBuilt 1973 · S/N 32-7440021N5672UWatson Phillip J · Jackson, TNBuilt 1969 · S/N 28-26469N56734Hales Michael G · Farwell, MIBuilt 1973 · S/N 28-7425028N56735Kilo Mike Aviation LLC · Hilliard, OHBuilt 1973 · S/N 28-7415008N56736N56736 LLC · Fort Smith, ARBuilt 1973 · S/N 28-7405029N56748Cutler Matthew · Santa Clarita, CAS/N 28-7425029N5674WJimenez Marcos A · Little Ferry, NJBuilt 1962 · S/N 28-868N56750Williams Nicholas E K · Stacy, MNFirst renewal noticeBuilt 1973 · S/N 28-7425030N56751Torroija Matias · Miami, FLBuilt 1973 · S/N 28-7415009N56753Gwartney Bobby L Jr · Hammon, OKBuilt 1973 · S/N 28-7410029N56756Morley Thomas O · Riverside, CAS/N 28-7425031N5675WAmmons Benjamin W Jr · Jacksonville, FLBuilt 1962 · S/N 28-898N56765Morgan Diskin G III · Douglas, GABuilt 1973 · S/N 28-7410030N56766Elliott Scott · Holmes, NYBuilt 1973 · S/N 32-7400008N5676UMg Aviation · Oshkosh, WIBuilt 1969 · S/N 28-26473N5676VDave Simpson Aviation Inc · Escondido, CABuilt 1977 · S/N 28-7790494N5676XArmstrong Kyle John · Eugene, ORBuilt 1973 · S/N 28R-7435039N56771Haight Robert A · East Haven, CTBuilt 1973 · S/N 28-7425032N56777Jac Aero LLC · Springfield, ORBuilt 1973 · S/N 28-7415011N5677UGolden Age Aviation LLC · Naperville, ILBuilt 1969 · S/N 28-26474N5677VAnnies Aviation LLC · Bloomington, INBuilt 1977 · S/N 32R-7780359N5677WLangel Brandon · Saint Charles, MOS/N 28-909N56780Stewart Donald Kent · Denver, NCBuilt 1973 · S/N 28R-7435041N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035N56786Janda Robert J · Grafton, OHBuilt 1973 · S/N 28-7415012N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913N56790Bradfield Breyson · Mandaree, NDBuilt 1973 · S/N 28R-7435042N56791Brosher Melvin G · Decaturville, TNS/N 28R-7435043N56793Dodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 32-7400009N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476N5679VAir Nautica LLC · Dublin, GAS/N 28-7716197N567DSJones Dean F · Long Beach, CABuilt 1977 · S/N 28R-7703414N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046N56822Tanner Timothy S · Norton, KSBuilt 1973 · S/N 28R-7435047N56823Fly Tu9 LLC · Vancouver, WABuilt 1973 · S/N 28R-7435048N56824Roberts Jeremy · Draper, UTBuilt 1973 · S/N 32-7440029
Back to AD 87-08-08 R3