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.

N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8557HLloyd Davis Inc · Brackettville, TXBuilt 1985 · S/N 0460N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014N8557VBurton Michael B · Coweta, OKBuilt 1974 · S/N 496-75N8558LStar Ads Inc · Torrance, CABuilt 1971 · S/N 25-5418N8558PBaughman Kevin R · Avinger, TXBuilt 1964 · S/N 24-4015N8558WEmerson Scott D · Roseville, CABuilt 1963 · S/N 28-10072N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559NJohnson Arnold R · Mina, SDBuilt 1969 · S/N 28-11357N8559PMcclean Adam D · Lakeport, CABuilt 1964 · S/N 24-4016N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N8559WKelcher Colton C · Olympia, WABuilt 1963 · S/N 28-10073N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N855BDThompson Contracting Inc · Peachtree City, GABuilt 1998 · S/N 18280327N855CPVector Air LLC · Erie, COBuilt 1998 · S/N 17280461N855GKUavionix Corp · Bigfork, MTBuilt 2017 · S/N 72581N855LSAir First LLC · Kalispell, MTBuilt 1996 · S/N 0260N855PCMcalee Dennis E · Defiance, MOBuilt 2008 · S/N 70970N855REBrowne Thomas J · Grass Valley, CABuilt 1986 · S/N MOORS 0001N855SPKirschner Joel D · Clarkesville, GABuilt 1981 · S/N R18201792N855TSSteier Tim A · Blue Earth, MNBuilt 2005 · S/N 0001N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560LKnutson Wayne R · Thompson, NDS/N 25-4981N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8560WSafrit Christopher · Midlothian, TXBuilt 1963 · S/N 28-10053N8561NPorter Louisa · San Diego, CABuilt 1970 · S/N 28-11359N8561VParatus Air Inc · Auburn, INBuilt 1985 · S/N 0484N8561WMarble William R · Sparks, NVBuilt 1963 · S/N 28-10059N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8562NLorox Llp · Wishek, NDBuilt 1970 · S/N 28-11360N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019N8563WRoche Daniel · Bellefonte, PABuilt 1963 · S/N 28-10075N8564FRmi Air LLC · Ocilla, GABuilt 1976 · S/N 28-7715282N8564NEby Leo V · Clearville, PAS/N 28R-7135112N8564WBinns George E · Hackettstown, NJBuilt 1963 · S/N 28-10076N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8565PLynn Owen P · Vinemont, ALS/N 24-4021N8566NN8566n LLC · Briarwood, NYBuilt 1970 · S/N 28-11363N8566PRicciardi Brian · Dennis, MABuilt 1964 · S/N 24-4022N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8567GRally Rocket LLC · Fort Collins, COS/N 36N8567NWeekend Aviators Ltd · Herndon, VABuilt 1970 · S/N 28-11365N8567PJeewek Rita M Trustee · Parma, OHBuilt 1964 · S/N 24-4023N8567WNielsen Peter K · Bellingham, WABuilt 1963 · S/N 28-10079N8567YJohnson Randy D · Becket, MAS/N 30-1715N8568CCavanaugh Darrel N · Wasilla, AKBuilt 1953 · S/N 18-2723N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720
Back to AD 87-10-06 R1