OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N6880WRegistered aircraftBuilt 1965 · S/N 28-21036N6881WLewis Mark A · Ozark, ALBuilt 1965 · S/N 28-21037N6882JHeidebrink James M · Bloomington, ILBuilt 1976 · S/N 28-7615386N6883JRobbins John L · Crossville, TNS/N 28-7615387N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420N6885WMiller Andy D · Marana, AZS/N 28-21041N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421N6886WGregory Joshua L · Oxford, MSBuilt 1965 · S/N 28-21042N6887JBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 32R-7680379N6888FAtlanta Peach Air LLC · Oxford, GAS/N 32R-7780049N6888JMovable Air LLC · Oldsmar, FLBuilt 1976 · S/N 32R-7680380N6888WAnderson Ty M · Grenada, MSBuilt 1965 · S/N 28-21045N688AGrasky Endurance Coaching LLC · Tucson, AZS/N 32R7887184N688BGJones William E · Birmingham, ALBuilt 1969 · S/N 28R-35023N688LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881267N688TBBiggar Stephen R · Jackson, NJBuilt 1977 · S/N 28R-7803054N6890WRegistered aircraftS/N 28-21047N6892JHunter Trevor C · N Ogden, UTBuilt 1976 · S/N 28-7615389N6892WRussell Steven D · Waxhaw, NCBuilt 1965 · S/N 28-21049N6893FAligence Air LLC · Spring Hill, FLBuilt 1976 · S/N 28-7715185N6894JPiontek Theodore J · Housatonic, MABuilt 1976 · S/N 28-7690422N6894WSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 28-21053N6895WSale Reported · Brighton, COSale reportedBuilt 1965 · S/N 28-21054N6896WRegistered aircraftS/N 2821056N6897CSchumann Donald A · Naperville, ILBuilt 1978 · S/N 28-7890384N6897WMcdowell Robert D · Snohomish, WABuilt 1965 · S/N 28-21059N6899FLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7725081N689BTDoell Brad J · Elsie, NEBuilt 1977 · S/N 28-7890132N689LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881272N68AMRfa LLC · High Ridge, MOBuilt 2005 · S/N 3255026N68CNEichten Steve G · Colleyville, TXBuilt 1969 · S/N 28R-35388N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68GFJcp Equipment LLC · Brainerd, MNBuilt 1982 · S/N 28R-8331010N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68JALost Aviators LLC · Durant, OKBuilt 2001 · S/N 2844057N68JDCorman Justin W · Bridgeport, NEBuilt 1974 · S/N 32-7440130N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850N68KSeymour Robin · Woodland Hills, CABuilt 1976 · S/N 32R-7680227N68SDPro Aero LLC · Warrenton, VABuilt 1979 · S/N 32-7940126N68TYKing Ty · Rogers, ARBuilt 1968 · S/N 28-11207N68VCammack Daniel P · Colorado Springs, COBuilt 1967 · S/N 28-4552N6900JCaruso Jerry W Jr · Kingsbury, NYBuilt 1976 · S/N 28-7615393N6900WHall William Brent · Tulia, TXBuilt 1965 · S/N 28-21063N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425N6904JGlass Michael C · Maysville, KYBuilt 1976 · S/N 28-7690426N6905JDouble Delta Sierra LLC · Bristol, CTBuilt 1976 · S/N 28R-7635359N6905WPodeweltz Wayne L · Merrill, WIBuilt 1965 · S/N 28-21071N6905ZZellers And Smith Enterprises LLC · Flowood, MSBuilt 1968 · S/N 28R30649N6906JBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 32R-7680383N6906WStandard American Adjusters Inc · Alba, TXS/N 28-21072
Back to AD 87-08-08 R3