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.

N87PMMona LLC · Kalispell, MTBuilt 1983 · S/N 24-1386N87PRTango Flight LLC · Thibodaux, LABuilt 2020 · S/N 91593N87RCTime To Fly Meseum · Burleson, TXBuilt 1994 · S/N 526-HN87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N87RVRoberts-Lethaby Jeremy P · Isanti, MNS/N 619N87SVMontgomery Vaughn L · Washington, UTBuilt 2020 · S/N 25070N87TSRwr Air Inc · Tok, AKBuilt 1973 · S/N 31-7300969N87WAltitude Aviation LLC · Lenoir, NCBuilt 1999 · S/N 2843296N87WAMann Ronald L · Pound Ridge, NYS/N 754-95N87WBWild Bitch LLC · Oklahoma City, OKS/N SN-483RN87WHPerry Larry B · Montross, VABuilt 1987 · S/N 1672N87WJKrueger Kenneth L · Newberg, ORS/N 553N87WTAnd We'Re Off Aviation LLC · Orlando, FLBuilt 2004 · S/N T20608452N87WYCarter Mark E · Salem, VABuilt 1986 · S/N 5111N87XPSutherland Brian · Nolensville, TNBuilt 2019 · S/N 087N88002Heiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1980 · S/N DW-1-0005-80N8800JRobinson Jacob · Lewistown, MTS/N 28-2745N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253N8800VLong Jon M · Santee, CABuilt 1973 · S/N 74-31085N8800WEagle LLC · Sleepy Eye, MNBuilt 1980 · S/N DW-1-0004-80N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8801EBlades Paul A · Newman, CABuilt 1980 · S/N DW-1-0007-80N8801MStein Bruce A · Punta Gorda, FLBuilt 1964 · S/N TD-569N8801WAfrican Research Foundation Inc · New York, NYRevoked, canceledBuilt 1964 · S/N 28-10213N8801XPiercy Ronald S · Moses Lake, WABuilt 1980 · S/N DW-1-0010-80N8802Osterberg Douglas · Neenah, WIBuilt 1973 · S/N 492-73N88024Madsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0021-81N8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledBuilt 1962 · S/N 0133N8802JShivers James C II · Columbus, OHBuilt 1965 · S/N 28-2750N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257N8802RPacific Kota LLC · Beresford, SDBuilt 1981 · S/N DW-1-0018-81N8802WRegistration Pending · San Juan, PRRegistration pendingBuilt 1964 · S/N 28-10248N8802YMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0019-81N8802ZMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-1002081N8803Lindsay Lori K · Kenai, AKBuilt 1973 · S/N 472-73N8803DWhite Jacob · Soldotna, AKBuilt 1958 · S/N 22-5971N8803FAg Helicopters Inc · Ft Collins, CORegistration revokedBuilt 1962 · S/N 0134N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258N8803RMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0024-81N8804Hail Jerry D · Keatchie, LABuilt 1973 · S/N 74-73N8804MKruse Paul L DBA · Colfax, ILBuilt 1981 · S/N DW-1-0030-81N8804NCarbon Regional Aero Club · Lehighton, PABuilt 1969 · S/N 28-25649N8804PJohnsen Christian · Lake Havasu City, AZBuilt 1975 · S/N BH-120-338N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N88055Lake Air Academy LLC · Richland, MIBuilt 1974 · S/N 715-74N88057Registered aircraftBuilt 1974 · S/N 716-74N88059Tidewater Soaring Society · Windsor, VAS/N 72-74N8805CSandifer Steve R · Barnwell, SCBuilt 1953 · S/N 22-1419N8805J8805 Partners LLC · Oklahoma City, OKBuilt 1965 · S/N 28-2755N8806Loyd Robert Oliver Parke · Wallingford, KYBuilt 1973 · S/N 364-73
Back to AD 87-10-06 R1