OpenAirDocs.org
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.

N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804N55AJJudge Andrew L · Pinecrest, FLBuilt 1998 · S/N DMO 413N55AUWallner Chris R · Petaluma, CABuilt 2003 · S/N 60537N55AVFood Service Installations Inc · Vancouver, WAS/N 41889N55BCMcconnell Bert J · Hudson, OHBuilt 2003 · S/N 60360N55BZDead Ant Aviation LLC · Wilmington, DEBuilt 1961 · S/N 500B-1041-42N55CRUltrapure Air LLC · Setauket, NYBuilt 1997 · S/N 392N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674N55DACircle L J Aviation Inc · Plant City, FLBuilt 1951 · S/N C1-0319N55DHAcmed Consulting LLC · Bradford, RIBuilt 1997 · S/N 24-3414N55DPMagaw David N · Sacramento, CABuilt 1974 · S/N DP-3N55DYBrown Carl A · Las Cruces, NMBuilt 1992 · S/N 194N55DZHuey Christopher D · Mesa, AZS/N 9472004N55EKMengel David M · Monticello, INS/N 1568N55ELLynn Edward Wayne · Vancouver, WABuilt 2019 · S/N 25237N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55EWHanratty Brian James · Pismo Beach, CABuilt 1966 · S/N TD-681N55FFSiedschlag Paul C · Granbury, TXBuilt 1978 · S/N 24-0672N55GASaathoff Michael A · Stockton, MOS/N 541N55GBRivers Paul E · Shannon, ILBuilt 1979 · S/N 212056N55GGAll Attitude Aviation Inc · Edgewater, FLBuilt 1985 · S/N 1030N55GTTurner William Hugh Vi · Belmont, CABuilt 1979 · S/N 5N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HNNaylor John H · Conway, ARS/N ONEN55HQHerndon Colton R · Smithville, MOBuilt 1965 · S/N 743N55HRInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 27-0192N55HUKaihai Corp · Wilmington, DEBuilt 1999 · S/N 2046N55JAOberman Mark · Camarillo, CABuilt 1971 · S/N 295N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55KEMiller Charles A · Walla Walla, WABuilt 1990 · S/N 20081N55KHDietle Kurt · Valley Springs, CABuilt 1979 · S/N R18201104N55KLNewman John D · Clyo, GAS/N 968-1N55KMHeberling Michael J · Fort Worth, TXBuilt 2006 · S/N 40178N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55LDDouble R Airways LLC · Largo, FLBuilt 1998 · S/N 3246101N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55MAGodwin Gerald R · Kountze, TXBuilt 2005 · S/N 2316N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55MJBarodge Equipment Leasing Inc · Fairmount, INBuilt 1980 · S/N 32R-8013068N55MTKramp William J · Post Falls, IDBuilt 1966 · S/N 27-3575N55NDMeyer William M · Chicago, ILBuilt 1976 · S/N 606HN55NLExtra Air LLC · Port Orange, FLBuilt 2000 · S/N 112N55NPN55np LLC · Broomfield, COS/N 700010N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145N55PKGlasheen Sean T · Bethel, AKBuilt 2019 · S/N CC18-0096N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675
Back to AD 87-10-06 R1