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.

N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584N61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065CN6133AReinders Monte M · Port Townsend, WABuilt 1990 · S/N 14001CN6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611N6133HCbc Aviation LLC · Hayden, IDBuilt 1979 · S/N 1085-79N6133JArbello Danny · Sterling, VAS/N 28-7615310N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6134SPatten Jeffery D · Rapid City, SDBuilt 1965 · S/N 18-41N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151N6135BOlds Todd · Huntersville, NCBuilt 1978 · S/N 45N6135DHowe Bryan · Edgewater, FLBuilt 1956 · S/N 22-4779N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301N6136KAll On Black LLC · Mount Nebo, WVBuilt 1994 · S/N S1672N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236N6137DPhelps Joe · Princeton, KYBuilt 1957 · S/N 22-4781N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309N6137SPiasecki Aircraft Corp · Coatesville, PABuilt 1965 · S/N 18-45N6137TDurnin Timothy K · Lansing, ILS/N R18201917N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134N61385Grady Will M · Gallatin, MOBuilt 1992 · S/N 4107CN6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310N6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988N6139AN6139a Corp Trustee · Wilmington, DEBuilt 1990 · S/N 10079CN6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757N613APThomas Lucas G · Beebe, ARBuilt 1976 · S/N 190-76N613BKMaxwell Roy J · Kenai, AKBuilt 1948 · S/N 1084795N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492N613KBPrecision Aero LLC · Wilmington, DEBuilt 1999 · S/N 835-99N613LCostigan George J · Nashua, NHBuilt 2016 · S/N 40434N613PCPrivitt Bret J · Forest Hill, TXBuilt 1999 · S/N 1255-98N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347N613RBFly Amphibious Aircraft LLC · Tampa, FLS/N 22N613RVFlege Jordan T · Morrow, OHBuilt 2000 · S/N 80266N613SCMorgan John P · Atlanta, GABuilt 1994 · S/N 1N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034N613SPAirmart Inc · Lexington, KYBuilt 2000 · S/N 172S8597N613VTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1986 · S/N VERMONT 0001N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344N613XEMalinchak Louis · Bristow, OKBuilt 2007 · S/N 270N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240N6140JWeldy Mark L · Etna Green, INBuilt 1976 · S/N 28-7615311
Back to AD 87-10-06 R1