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.

N40ARBock Owen · Grand Rapids, MIBuilt 1984 · S/N 28R-8431032N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953N40NCJones Edward B · Valdese, NCBuilt 1980 · S/N 32-8006014N40NZGround Effect LLC · Atascadero, CABuilt 1974 · S/N 32-7440171N40SASemper Fi Aviation LLC · Brooksville, FLS/N 32-111N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377N40SYTouchandgo LLC · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680271N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100QTailwinds Flying Club · Hudson, WIS/N 28-7790472N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101RMclean David L · Nashville, TNBuilt 1968 · S/N 32-40489N4102RDudzinski James · Reno, NVBuilt 1968 · S/N 32-40418N4102WSkirzynski Eric N · Meridian, IDBuilt 1967 · S/N 32-40165N4103WBean Sheila L · San Antonio, TXBuilt 1967 · S/N 32-40166N4105RWertz Travis F · Richland Center, WIBuilt 1968 · S/N 32-40424N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106QDairy Air Inc · Wyoming, PAS/N 28R-7737061N4107RSatnews Publishers Inc · Carson City, NVBuilt 1967 · S/N 32-40426N4108JMetoyer Eric D · Yukon, OKBuilt 1966 · S/N 28-22421N4108WArrow Ventures Inc · Lake Preston, SDS/N 32-40171N410CPNomad Flight One Inc · Clearwater, FLBuilt 2003 · S/N 3255010N410ETAndervick · Dalton, GABuilt 1976 · S/N 28-7690391N410SFKoehler Gregory S · Burlington, NCBuilt 1965 · S/N 28-21000N410TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881088N41108Winney Andrew J · Gothenburg, NES/N 28-7505195N4110PSkyway LLC · Bronx, NYBuilt 1998 · S/N 2843143N4110WRaschio Ernesto G · Doral, FLBuilt 1967 · S/N 32-40173N4111JWarmuth Richard J · West Harrison, INBuilt 1966 · S/N 28-22426N4112RLangenegger Glenn · Burns, KSBuilt 1968 · S/N 32-40431N4112WLian Ian · Beaumont, TXBuilt 1967 · S/N 32-40175N4113JParnell Jerry L Jr · Panama City, FLBuilt 1966 · S/N 28-22429N4114JCrader Air LLC · Jackson, MOBuilt 1966 · S/N 28-22430N4114QAerofeather Aviation Inc · Suffolk, VABuilt 1977 · S/N 28R-7703122N4114WWilliams Frank J · Mendon, MABuilt 1967 · S/N 32-40177N4116JKerns Brothers LLC · Boardman, ORS/N 28-22433N41177Chigusa Sean S · Rch Palos Vrd, CABuilt 1974 · S/N 28-7415129N4117FMade U Look Promotions LLC · Glastonbury, CTBuilt 1976 · S/N 28-7790004N4117JKeeven Thomas R · Elsberry, MOS/N 28-22434N41180Calladine Matthew · Wellsville, NYBuilt 1974 · S/N 28-7405081N4118JSale Reported · Dallas, TXSale reportedBuilt 1966 · S/N 28-22435N4118RHampsch Jeremy · Hauser, IDBuilt 1968 · S/N 32-40437N4118WWisniewski Travis J · Porter, TXBuilt 1967 · S/N 32-40181N41193Stephen Air LLC · Woodsfield, OHBuilt 1974 · S/N 28-7425203N41194Fisher Samuel K · Narvon, PABuilt 1974 · S/N 28-7415132N41195Flaus Deborah L · Washington, PABuilt 1974 · S/N 28-7415133N41197Fancher Ronald Albert · Linden, TNBuilt 1974 · S/N 28-7405082N4119JStowers Monique J · Los Lunas, NMBuilt 1966 · S/N 28-22436N4119KLe Doux Aviation LLC · Hollis, NHBuilt 1997 · S/N 3257020N4119RMott Patrick T · Ballston Spa, NYBuilt 1967 · S/N 32-40188
Back to AD 87-08-08 R3