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.

N72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171N72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125N72NVCarroll Cecil Dean · Dexter, MOBuilt 2009 · S/N 70086N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PGFox William Casey Trustee · Pipe Creek, TXBuilt 1998 · S/N 631N72QTRegistered aircraftBuilt 1972 · S/N 365-72N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891N72RMSparks Brian E · Monmouth, ORBuilt 1981 · S/N 8020CN72RVHarral Blake G · Prescott Valley, AZFirst renewal noticeBuilt 1999 · S/N 2401N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969N72SDYooper Aviation LLC · Menominee, MIBuilt 1972 · S/N 32-7240099N72SFMcintosh Stephen · Fishers, INBuilt 2003 · S/N 3053N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N72TGuazzerotti Fred · Mooresville, NCBuilt 1979 · S/N AA5B1086N72TDHerzog Eric M · New Waverly, TXS/N 1076N72USUnited States Aviation Underwriters Inc · Toledo, OHBuilt 2001 · S/N 18280936N72VBVan Bladeren Ronald W · Vancouver, WABuilt 2003 · S/N 81548N72VMFreeman Monty W · Kansas City, MOBuilt 2001 · S/N 2114N72WGJaja Properties LLC · Laurinburg, NCS/N 28-7310033N72WLSingleton Colin · Walkerton, INBuilt 1994 · S/N 21063N72WNPatmor Richard D Trustee · Dayton, NVBuilt 2006 · S/N 879-320-676N72WRFratzke Nathan A · Sterling, AKS/N 18-8982N72ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608700N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7300LBarlow Tyrone J · St George, UTBuilt 1972 · S/N AA5-0230N7300SHerring Alan T · Laredo, TXBuilt 1981 · S/N R18201702N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596N7301WFry Mark · Danville, PABuilt 1977 · S/N R18200051N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302WSanders Robert E · Whitewater, MOBuilt 1977 · S/N R18200052N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478N7303YCedar River Flyers · Seattle, WABuilt 1977 · S/N R18200114N7303ZSeminole Flying Soaring Inc · Clermont, FLS/N 25-3247N73040Goulding Brian K · Roswell, GABuilt 1976 · S/N 17267247N73041Max Air Aviation LLC · Carrollton, GABuilt 1976 · S/N 17267248N73043Six Ten Ventures LLC · Cedar Hill, TXBuilt 1976 · S/N 17267250N7304FReid Brian S · Merced, CAS/N 28-25216
Back to AD 87-10-06 R1