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.

N88WHThomas Robert R · Rochester, MNBuilt 1968 · S/N 28R-30974N88WPN88wp LLC · Magnolia, TXBuilt 1978 · S/N 32R-7885041N8900WSailor Paul Andrew · Saint Augustine, FLBuilt 1964 · S/N 28-10465N8901JQuinn Andrew · Fort Worth, TXBuilt 1965 · S/N 28-2878N8901WThompson Robert E · Ramona, CAS/N 28-10466N8902JLeavitt Jason R · Barnstead, NHBuilt 1965 · S/N 28-2880N8902WVolpe David J · Winneconne, WIBuilt 1964 · S/N 28-10467N8903CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690170N8904JHenderson John · Kirksville, MOBuilt 1965 · S/N 28-2882N8905NHigh Noon Leasing LLC · Anchorage, AKS/N 32-40690N8905WN8905w LLC · New Orleans, LABuilt 1964 · S/N 28-10471N8907FHughes Michael Anthony · Meridian, IDBuilt 1977 · S/N 28R-7703007N8907NCrain Roan · Cookeville, TNS/N 32-40693N8908NH & H Aviation LLC · Provo, UTBuilt 1969 · S/N 32-40695N8908WVancamp William · Queen Creek, AZBuilt 1964 · S/N 28-10475N8909Registration Pending · Stockton, CARegistration pendingBuilt 1967 · S/N 2823008N8909JJenson Adam D · Duluth, MNBuilt 1965 · S/N 28-2890N8909NKrull Doug · Hendersonville, TNS/N 32-40696N890BVJefferies James A Trustee · Peck, KSBuilt 1973 · S/N 28-7305215N890DFMarine Investments Llp · Morganton, NCBuilt 1978 · S/N 32-7840121N890GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881070N890MAIcarus Flying Academy LLC · Farmingdale, NYBuilt 1974 · S/N 28-7415492N890SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881800N890UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020196N8910KCoulter Ts LLC · Midway, UTBuilt 1977 · S/N 32-7840046N8910NRam Aeronautics LLC · Wichita Falls, TXBuilt 1969 · S/N 32-40698N8910WAnderson Jeffrey D · Camarillo, CABuilt 1964 · S/N 28-10478N8911WMonson Horizons Inc · Reynolds, ILBuilt 1964 · S/N 28-10479N8912FHaddock Richard R · Aiken, SCBuilt 1977 · S/N 32R7780119N8912JSoar With Sophia LLC · South Lyon, MIBuilt 1965 · S/N 28-2894N8912WHastings David · Lake Havasu City, AZS/N 28-10481N8913WMra Aviation Inc · Springfield, VAS/N 28-10482N8914JVesper Aviation LLC · Las Vegas, NVBuilt 1965 · S/N 28-2929N8914NTreetop Flyers LLC · Vashon, WABuilt 1969 · S/N 32-40704N8914WDines Stephen R · Monument, COBuilt 1964 · S/N 28-10483N8915WChandler Forrest J · Cabot, ARBuilt 1964 · S/N 28-10485N8916NBundy Richard · Little Egg Harbor, NJBuilt 1969 · S/N 32-40707N8917JI Was Inverted LLC · Fort Myers, FLS/N 28-2932N8918NStratton Erin B · Baton Rouge, LABuilt 1969 · S/N 32-40711N8919JKelly Kevin R · Ormond Beach, FLBuilt 1965 · S/N 28-2935N891GPHancock Aircraft Sales LLC · Baton Rouge, LABuilt 1967 · S/N 28-23847N8920JSargent Timothy E · Pickerington, OHBuilt 1965 · S/N 28-2937N8922JTowner Jeffery D · Rose Hill, KSBuilt 1965 · S/N 28-2939N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717N8923JVenture West LLC · Mesa, AZBuilt 1965 · S/N 28-2940N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720N8924WRiblet Jeffrey L · Portsmouth, VABuilt 1964 · S/N 28-10489N8925NMackay James R · Corunna, MIS/N 32-40721N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944
Back to AD 87-08-08 R3