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.

N8755MTraver Ronald D · Lantry, SDS/N M-543N8755VBoettcher Michael W · Soldotna, AKBuilt 1975 · S/N 854-75N8755WAndersen Troy L · Longmont, COBuilt 1964 · S/N 28-10295N8755YTwo Twins Aviation Inc · Wilmington, DEBuilt 1969 · S/N 30-1909N8756CDt Aviation LLC · Ontario, CABuilt 1976 · S/N 28-7615125N8756DExecutive Holdings LLC · Fairbanks, AKS/N 22-5940N8756EHowell Richard · Louisville, KYS/N 28-7690201N8756MMutschler George R · Paradise Valley, AZS/N M-544N8756PK T Graham Inc · Ephrata, PABuilt 1965 · S/N 24-4206N8756WSandidge Tate · Stearns, KYBuilt 1964 · S/N 28-10296N8756YAgri Business Aviation Inc · Sparta, ILBuilt 1969 · S/N 30-1910N8757ELa Copious LLC · Pinetop, AZFirst renewal noticeS/N 28R-7635211N8757MHolmes Charles E · South Bend, INBuilt 1963 · S/N M-545N8757N57 November LLC · Charlotte, NCBuilt 1969 · S/N 28-25576N8757PHix William W · Walsenburg, COBuilt 1965 · S/N 24-4207N87589Johanson Jason · Groveland, CAS/N UC1-R158N8758CYuknis Leonard F · Wasilla, AKBuilt 1953 · S/N 18-2842N8758EMiller Kevin · Dover, DEBuilt 1976 · S/N 28R-7635212N8758MAndrew Manuel Driscoll · South Yarmouth, MABuilt 1964 · S/N M-546N8758PMurphy Robert J · Deland, FLBuilt 1965 · S/N 24-4208N87592Sorensen Eric N · Hilo, HIS/N 160432N8759EN8759e LLC · Wilmington, DES/N 32R-7680174N8759NDisanto Rocco F · Morganton, NCBuilt 1969 · S/N 28-25580N8759PHeir Grant · Woodland, CAS/N 24-4209N8759VSmetters Jeffrey L · Crystal Lake, ILBuilt 1975 · S/N 202-75N8759WBig Sky Air LLC · Cedar Rapids, IABuilt 1964 · S/N 28-10299N875ADRegistration Pending · Independence, ORRegistration pendingBuilt 2004 · S/N 22707N875CFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020102N875GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881069N875LBeaman David · Knoxville, TNBuilt 1977 · S/N AA5B0672N875SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881744N8760CReindl Thomas A · Algonquin, ILBuilt 1976 · S/N 28-7615126N8760EArchie Airways LLC · Durant, OKBuilt 1976 · S/N 32R-7680175N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548N8760WCarlsbad Raceway Corp · Hemet, CABuilt 1964 · S/N 28-10300N87618Ready Aim Flyer LLC · New Castle, DEBuilt 1948 · S/N 866N8761HLejeune Aerial Applications LLC · Basile, LAFirst renewal noticeBuilt 1976 · S/N 1516N8761MJohnson Gregory J · Port Orange, FLS/N M-549N8761WMakeev Alexandre · Concord, CABuilt 1964 · S/N 28-10301N87621Shackelford Gary L · Parrish, FLBuilt 1949 · S/N 869N8762DEpperson James R · Sand Springs, OKBuilt 1958 · S/N 22-5946N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582N8763EBodwell Keith J · West Cornwall, CTS/N 28-7615160N8763WGoldsworthy Joe E · Buckeye, AZBuilt 1964 · S/N 28-10303N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8764J374dk Aviation LLC · Sand Springs, OKBuilt 1972 · S/N AA5-0116N8764WJohnson Walter R · Chuckey, TNBuilt 1964 · S/N 28-10304
Back to AD 87-10-06 R1