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.

N700SEBooze Conrad C · Warner Robins, GABuilt 2012 · S/N 40851N700SNAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1986 · S/N 700N700TCTek Aire LLC · Blacklick, OHBuilt 1980 · S/N 61P07718063384N700TEAustin Bill DBA · Sparta, TNBuilt 1982 · S/N 60-8265015N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012N700WGNeuro Endovascular Services And Technology LLC · Palm Harbor, FLBuilt 1981 · S/N 62P08868165020N700WPLebus Jack G · Longview, TXBuilt 1979 · S/N 32-7940085N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007N700YMKisthard James · Roberts, MTBuilt 1979 · S/N 61P-0585-7963258N700YPDelta Delta LLC · Fargo, NDBuilt 1979 · S/N 61P06837963322N700YWHorwath Ricky N · Saint James City, FLBuilt 1979 · S/N 70029N7010BDurfee Tristan O · Duluth, MNBuilt 1956 · S/N 22-4260N7010FEconomou Michael · Falls Church, VAS/N 32R-7780051N7010GStavair LLC · Gulf Breeze, FLBuilt 1969 · S/N 17258710N7010PJuliett Tango LLC · West Rutland, VTBuilt 1960 · S/N 24-2154N7010QMosman Matthew J · Nezperce, IDS/N 17260310N7010SNass Michael F · Clinton, IABuilt 1988 · S/N 001N7010VCompass Aviation Maintenance LLC · Shelby, NCBuilt 1976 · S/N 22-1362N7010WBrown Nicholas R · Knoxville, TNS/N 28-687N7010YBrown William C Jr · Northville, MIBuilt 1963 · S/N 30-11N7011BFuller Eddy A · Madras, ORBuilt 1956 · S/N 22-4262N7011DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1957 · S/N 22-4904N7011GChase Development Aviation LLC · Oakland Park, FLBuilt 1969 · S/N 17258711N7011JSouthlake Aviation LLC · Arden, NCBuilt 2016 · S/N 2843821N7011PJapikse Bert · Pawleys Island, SCBuilt 1960 · S/N 24-2156N7011WLevine Allen D Trustee · Goshen, NYBuilt 1962 · S/N 28-688N7012DBarlow Jason P · Brighton, COBuilt 1957 · S/N 22-4905N7012RPalomo Joe · Laredo, TXBuilt 1966 · S/N 28-21706N7012YBooher Greg F · Livingston, TNBuilt 1963 · S/N 30-13N7013GSaeid Abdelmasih · Euless, TXBuilt 1969 · S/N 17258713N7013PShumock Craig A · Moss Point, MSS/N 24-2159N7013QVeil Casey J · Jamestown, NDBuilt 1971 · S/N 17260313N7013VForsman Robert J · Yelm, WABuilt 1976 · S/N 22-1365N7013YHubbard James E · Dover, OHS/N 30-14N7014PRyan John David · Fort Rucker, ALBuilt 1960 · S/N 24-2162N7014WSpi Group LLC · Georgetown, TXS/N 28-694N7014ZBarrett Jane T · Tehachapi, CABuilt 1964 · S/N 25-2768N7015Woods Donald E · Great Falls, MTBuilt 2004 · S/N 3645N7015GDaugherty William A · Horseheads, NYBuilt 1969 · S/N 17258715N7015WHunt Timothy J · Mesa, AZBuilt 1962 · S/N 28-695N7016BUnable Direct LLC · Kalispell, MTS/N 22-4267N7016FNations One For Christ · Duluth, MNS/N 32R-7780052N7016GRocky Air LLC · Cheyenne, WYBuilt 2016 · S/N 30008N7016PSgroi Eric A · Wentzville, MOS/N 24-2163N7016VHotel Charlie Aero LLC · Marshville, NCBuilt 1976 · S/N 22-1368N7016WDoorenbos Rodney J · Washburn, MOBuilt 1962 · S/N 28-696N7017PDewey J Levie P C · Chino Valley, AZBuilt 1960 · S/N 24-2164N7017QClair Michael A · Omaha, TXFirst renewal noticeBuilt 1971 · S/N 17260317N7017RRd Aire LLC · Opelika, ALBuilt 1966 · S/N 28-21712N7017VHenry R Rey Ltd · Fresh Meadows, NYS/N 22-1369
Back to AD 87-10-06 R1