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.

N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8569PPurpose Flight Inc · Wilmington, DES/N 24-4026N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N8569WColumbia Gorge Community College · The Dalles, ORBuilt 1963 · S/N 28-10081N856BCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1987 · S/N C2171N856DBRobinson Scott J · Menifee, CABuilt 2007 · S/N 81440N856DKGlobal Aircraft Solutions LLC Trustee · Newark, DES/N T18208439N856KWrong Brothers LLC · Sedgwick, KSBuilt 1997 · S/N 9608100N856KWMurphy Michael J · Mendota Heights, MNS/N 188N856LSlack Troy Trustee · New Concord, OHBuilt 1930 · S/N 117N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944N856PBToman Gregory R · Caledonia, MIBuilt 2008 · S/N 40186N856RCN856rc LLC · Bow, WABuilt 1980 · S/N 32-8024003N856RHWijma Alexander Sotiri · Cumming, GABuilt 2009 · S/N 22032N856SBWard James · Chattanooga, TNBuilt 2009 · S/N 71541N856SCWooten Patricia · Avinger, TXBuilt 1978 · S/N 32R-7985059N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N8571NSeverance Douglas E · Danville, CABuilt 1970 · S/N 28-11367N8571PBrackett William E · Capitan, NMBuilt 1964 · S/N 24-4028N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406N8572DRubbert Jan D · Upham, NDBuilt 1958 · S/N 18-6228N8572LSky Soaring Inc · Hampshire, ILBuilt 1969 · S/N 25-4996N8572PService Drug DBA · Chadron, NEBuilt 1964 · S/N 24-4029N8572WKoopmans Caleb · Bridgewater, SDBuilt 1963 · S/N 28-10084N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408N8573PMounicou Sonny M · Olive Branch, MSBuilt 1964 · S/N 24-4030N8573VSchrack Kevin · Loganton, PABuilt 1974 · S/N 796-75N8573WRenner Paul Eric · Parkville, MOBuilt 1963 · S/N 28-10085N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409N8575BMilam Michael S · Robinson, TXBuilt 2020 · S/N 3RX159N8575VMcintyre Jon D · Fairbanks, AKBuilt 1975 · S/N 142-75N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410N8576VJam Three LLC · St George, UTBuilt 1974 · S/N 498-75N8576WHaynes Edward · Snohomish, WABuilt 1963 · S/N 28-10088N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8577Burke Jeremy D · Westminster, COBuilt 1964 · S/N 2737N8577PPrice Isaac H · Flat Rock, ALBuilt 1964 · S/N 24-4034N8577VHoran Spraying LLC · Plainview, TXBuilt 1974 · S/N 309-75N8577WM97west LLC · Fargo, NDBuilt 1963 · S/N 28-10089N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412
Back to AD 87-10-06 R1