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.

N7671YBailey Wryan T · Nashville, TNBuilt 1965 · S/N 30-749N7672JWeiner Johannes · New Paltz, NYBuilt 1969 · S/N 28R-31103N7672PSantore William F · Laguna Niguel, CABuilt 1961 · S/N 24-2885N7672SLouisville Soaring Club Inc · Lexington, KYBuilt 1976 · S/N 222-76N7672WCrossroads Aviation LLC · Leesville, LABuilt 1964 · S/N 28-1653N7672YBertrand Jason · Seattle, WABuilt 1965 · S/N 30-750N7673GSchaack Lawrence A · Woods Cross, UTBuilt 1970 · S/N 17259373N7673PR M Kraft Ag Inc · Cut Bank, MTBuilt 1961 · S/N 24-2886N7673RGiles Dwight L · Greeley, COBuilt 1969 · S/N M-1270N7673WNew Horizons Aviation Inc · Goshen, INBuilt 1964 · S/N 28-1656N7674CFiyalko Wayne · Fort Myers, FLBuilt 1975 · S/N 28R-7635111N7674FCarter Rhonda L · Columbiana, ALBuilt 1976 · S/N 28-7725101N7674HOverly Terrence L · Tok, AKS/N 12-554N7674JAerofeather Aviation Inc · Suffolk, VABuilt 1968 · S/N 28R-31074N7674PChurches Michael D · Smyrna, TNS/N 24-2887N7674SMurtagh Johhny T · Lexington, MSBuilt 1976 · S/N 932-76N7674YBooth James R · Nevada City, CABuilt 1965 · S/N 30-752N7675JDimmlich Scot A · Conyers, GABuilt 1968 · S/N 28R-31075N7675PEhrhart Jerry L · Mount Joy, PABuilt 1961 · S/N 24-2844N7675RKline John C · Wolcottville, INBuilt 1970 · S/N M-1297N7675WAltitude Aircraft Leasing LLC · Burnet, TXBuilt 1964 · S/N 28-1642N7676FNationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 28-7715234N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376N7676PHanneman Robert D · Denver City, TXBuilt 1961 · S/N 24-2845N7676WEsparza Vincent A · Friona, TXS/N 28-1662N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755N7677FWestern Robert E · Stanley, NDS/N 28-7715235N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7677RAlpha Bravo Charlie 1 Corp · Houston, TXS/N M-1288N7677VDoxtator Christopher P · Covington, INBuilt 1982 · S/N 24-1328N7677WNikolic Peter Jr · Momence, ILBuilt 1964 · S/N 28-1663N7677ZSpurlock Ricky DBA · Jensen, UTFirst renewal noticeBuilt 1966 · S/N 25-3826N7678DEldridge William D · Anchorage, AKBuilt 1957 · S/N 18-5900N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678PMunday Jeff R · Waverly, GAS/N 24-2889N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406N7678WDsr-Cherokee 180 LLC · Dallas, TXBuilt 1964 · S/N 28-1665N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N7679HSummerskyz Inc · Urbana, ILBuilt 2004 · S/N 3540N7679RSmith Melissa R · Atlanta, ILS/N MA-359N767ACWooldridge Kent L · Albany, ORBuilt 2000 · S/N 410-2000N767APHorvath Patrick L · Conyers, GABuilt 1976 · S/N 14097N767AWTooth & Go Flyers LLC · Farmington Hills, MIBuilt 1964 · S/N 413N767BRRv8r Aviation LLC · Wilmington, DEBuilt 2017 · S/N 82410N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767CEReviere Russell E · Jackson, TNBuilt 1979 · S/N 28-8011047N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234N767DCMariah Aviation Corp · Miami, FLBuilt 2000 · S/N 60034N767DDAckerman Garry A Jr · Plano, TXBuilt 1979 · S/N 351A
Back to AD 87-10-06 R1