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.

N77AHPate Steven H · El Paso, TXBuilt 1977 · S/N 28R-7703223N77AJGreen Nicholas S · Lakeland, TNBuilt 1976 · S/N 32R-7680371N77DRGeodetic Associates International LLC · Pittstown, NJBuilt 1995 · S/N 3246005N77DUChaffee Merilyn D · Angwin, CABuilt 1999 · S/N 3257101N77ENEuroaviation Inc Trustee · KemtenBuilt 1982 · S/N 28R-8231030N77EQDuncan Real Estate Investments LLC · Sutherlin, ORS/N 287790101N77GMMartin Gustavo E · Cooper City, FLBuilt 1976 · S/N 28-7790218N77LZO'Quinn Debbie M · Jesup, GAS/N 28R-7737073N77PMSokrispymedia LLC · Greenville, SCS/N 28R-7703030N77RCN77rc LLC · Wilmington, DEBuilt 1972 · S/N 28R-7335092N77RHFelty Johnathon T Sr · Auburn, PABuilt 1974 · S/N 32-7440103N77SBYanta Chris J · Rockport, TXBuilt 1977 · S/N 32-7740086N77TBGlass Ralph D · Elgin, TXS/N 28-21487N77TTTurley James H · Plainwell, MIBuilt 1976 · S/N 32R-7680244N77VECullinan Robert M Jr · Woodstock, GAS/N 32-7840097N77WESteven Paul Joyner · Austin, TXBuilt 1969 · S/N 28R-35114N77YYN77yy Corp Trustee · Wilmington, DEBuilt 1999 · S/N 32-57120N77ZBIkiugu Moses · Vermillion, SDS/N 28-7790359N7801AAdams Benjamin · Arcadia, FLS/N 32-7440074N7801NGeorge Monte · Medford, ORBuilt 1968 · S/N 28-5199N7801WRegistered aircraftBuilt 1964 · S/N 28-1799N7803W3w Group Inc · Hot Springs, ARS/N 28-1807N7804NApaa Aviation Group LLC · Frisco, TXBuilt 1969 · S/N 28-5254N7805NCorrigan Air Center · Hondo, TXBuilt 1968 · S/N 28-5256N7806NTab Air Time LLC · Longmont, COBuilt 1968 · S/N 28-5257N7807NBwh Leasing LLC · Lewes, DEBuilt 1968 · S/N 28-5258N7809NUninsured Justice Enterprises LLC · Joplin, MOBuilt 1968 · S/N 28-5260N7809WHand Lawrence E · Klamath Falls, ORBuilt 1964 · S/N 28-1816N780DAFawley Dean · Newnan, GABuilt 1969 · S/N 28-5328N780FMIolaire Aviation Inc · Wilmington, DEBuilt 2002 · S/N 2844086N780LAN780la LLC · Philadelphia, PABuilt 2025 · S/N 28020222N780UOhio University · Albany, OHBuilt 2005 · S/N 2842232N780ZCornerstone Aviation LLC · Columbus, INBuilt 2005 · S/N 3232043N7812NSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28-5264N7812WSidner Jeffrey Paul · Colorado Springs, COBuilt 1964 · S/N 28-1820N7813WMnt Aviation LLC · Fairmont, WVBuilt 1964 · S/N 28-1821N7814NBynum Robert Austin II · San Antonio, TXS/N 28-5265N7815FBrammer Bryon L · Simi Valley, CABuilt 1976 · S/N 28-7790226N7815NSmall World Aero Solutions LLC · Belton, TXBuilt 1969 · S/N 28-5266N7816NMagee Michael J · Olathe, KSBuilt 1969 · S/N 28-5267N7818NFubar Flyers Inc · Port Charlotte, FLBuilt 1968 · S/N 28-5270N7819CTodorov Jassen · San Francisco, CABuilt 1975 · S/N 28-7615064N7819NNewton James L · Bella Vista, ARBuilt 1969 · S/N 28-5271N7819WCal Aerofab Flight Academy Inc · Chino, CABuilt 1964 · S/N 28-1828N781GHJohn Stuart LLC · Miramar, FLBuilt 1978 · S/N 32R-7885141N781LAN781la LLC · Philadelphia, PABuilt 2025 · S/N 28020213N781PAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010042N781SWScott Robert E · Sarasota, FLBuilt 1968 · S/N 28-4958N781WWMattson William W · Telluride, COBuilt 1977 · S/N 28R-7803090N7820CSummit Flight Academy LLC · Peculiar, MOBuilt 1975 · S/N 28-7690083
Back to AD 87-08-08 R3