OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148N5977ZBrown Michael S · Kenai, AKBuilt 1965 · S/N 18-8234N5978DWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 18-5441N5978PMealey Patrick James Jude · Menlo Park, CABuilt 1959 · S/N 24-1071N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208N5979DVeal Tim S · Egegik, AKBuilt 1956 · S/N 18-5442N5979QBlount Aviation LLC · Metairie, LABuilt 1965 · S/N 849N5979SJohnson Jay W · Wichita, KSBuilt 1966 · S/N MA-60N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867N5979ZSchuster Timothy A · Carrington, NDBuilt 1965 · S/N 18-8237N597AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881756N597CBBrandon Air LLC · Valley Stream, NYBuilt 1989 · S/N 3213029N597DCClark James D · Godley, TXBuilt 2021 · S/N 2021DCN597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262N597JGKnoxville Flyers Inc · Knoxville, TNBuilt 1997 · S/N 2843087N597LDewitt Troy C · Lake Elmo, MNS/N 30-575N597LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 1986 · S/N 597N597NDNicholas James Esch · Cedar Rapids, IABuilt 1967 · S/N 670041N597RARedtail Aviation LLC · Brookville, PABuilt 2004 · S/N 40.444N597RVBeckley Jeff A · Windsor Heights, IAFirst renewal noticeBuilt 2007 · S/N 70936N597SMoore Charles W · Lees Summit, MOBuilt 1999 · S/N 23995N597SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881410N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525N597TJJt Airshows · Slidell, TXBuilt 1995 · S/N 5325N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N597WBaccas Christopher · Sun City Center, FLBuilt 1971 · S/N 28-7125465N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037N5980UT A Aviation LLC · Tucson, AZBuilt 1970 · S/N 28-26870N5980WCooke Carole J Trustee · Aguila, AZBuilt 1967 · S/N 28-4260N5980ZOyster Flite Investments Inc · Wilmington, DEFirst renewal noticeBuilt 1965 · S/N 18-8238N5981DPrecision Ag LLC · Kenmare, NDBuilt 1957 · S/N 18-5446N5981STucker Mark R · Williamsburg, VABuilt 1966 · S/N MB-72N5981UEast Sun Corp · Greensboro, NCS/N 28-26759N5981WLudwing Jonathan · Tompkinsville, KYBuilt 1967 · S/N 28-4322N5981ZFell Donald M Trustee · Homer, AKBuilt 1965 · S/N 18-8239N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081N5982SPercy Gary A · Wedderburn, ORBuilt 1966 · S/N MB-73N5982UCapital Aviation LLC · Fuquay Varina, NCBuilt 1970 · S/N 28-26757N5982WHarris Chad A · Hamilton, ALBuilt 1967 · S/N 28-4342N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155N5983DGoodell Rebecca S · Sedro Woolley, WABuilt 1956 · S/N 18-5448N5983MPhilipp Michael W · Thief River Falls, MNS/N 17260945N5983USale Reported · Adelanto, CASale reportedBuilt 1970 · S/N 28-26825N5983WAnderson Kerri · Frazier Park, CABuilt 1968 · S/N 28-24783N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052N5984QSlow Walkin Barnstormers LLC · Frostproof, FLBuilt 1965 · S/N 3211N5984SBoswell Kurt R · Renton, WABuilt 1966 · S/N MB-76
Back to AD 87-10-06 R1