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.

N5107VEckert Robert E · Edgewood, TXBuilt 1959 · S/N FP-7N5107YBrown Peter B · Salem, VABuilt 2001 · S/N T18208099N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705N5108VDavis John K · Texarkana, ARBuilt 1959 · S/N FP-8N5108WJennings Todd R · Hawthorne, FLBuilt 1961 · S/N 28-125N5109GSnamiska Kyle · Cypress, TXBuilt 1967 · S/N 28-23174N5109SBucek James A · Baytown, TXBuilt 1971 · S/N 28-7105129N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044N510BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881852N510CCAwmr LLC · Conroe, TXBuilt 1978 · S/N 31-7812127N510DYoungs Water Conditioning Of Logansport LLC · Logansport, INS/N 27-7654024N510DDSchardt Donovan D · Juniata, NEBuilt 2011 · S/N 40099N510DFDunkle Steven P · Newnan, GABuilt 2022 · S/N 42271N510DSTrussler Leslie Henley · Manchester, TNBuilt 2002 · S/N 40.210N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470N510FHCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841179N510GN510g LLC · Venice, FLS/N 660-320-404FBN510HRBrian Investments LLC · Elizabethtown, NCBuilt 1998 · S/N 4223-4N510KCProcoff LLC · Shreveport, LABuilt 1993 · S/N 4622151N510LSRegistration Pending · Nashville, TNRegistration pendingBuilt 2002 · S/N 899-2002N510MARegistered aircraftBuilt 2005 · S/N 2322N510PCPaton Jamie D · Clearwater, FLS/N 1488N510RGGrubbs Randall D · Heber Springs, ARBuilt 2025 · S/N VANSRV10L54040791N510RKKnapp Russell · Groveland, FLBuilt 2024 · S/N 41162N510RVDeering Casey T · San Angelo, TXBuilt 2008 · S/N 40326N510SFGibson William V II · Aberdeen, MSBuilt 2008 · S/N 001N510THRegistration Pending · Oxford, CTRegistration pendingBuilt 1975 · S/N 28R-7535221N510TRAltamira Flying Club Inc · Round Rock, TXBuilt 2003 · S/N 18281200N51101Sweitz-Air Iinc · Stewartstown, PAS/N 23985N5110GN5110g LLC · Orlando, FLS/N 28-23211N5110HBuxton S · Mount Pleasant, SCBuilt 1948 · S/N 14-115N5110PGray William · Broken Arrow, OKBuilt 1958 · S/N 24-120N5110XT & M Aerial Spraying · Garland, NCBuilt 1969 · S/N 192N5111BWhittaker Darrel S · Chapmansboro, TNBuilt 1998 · S/N 4003N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645N5111SC And A Aviation Inc · Baltimore, MDBuilt 1971 · S/N 28-7105130N5112HDefendorf Nelson W · Anchorage, AKS/N 14-118N5112LRyan Lowe Aviation · Costa Mesa, CABuilt 1967 · S/N 28-4394N5112VMertz Harry Z · Castle Rock, COBuilt 1961 · S/N SP-12N5112WShulman Scott · Hillsborough, NHS/N 28-128N5113LTessos Air Service Inc · Wilmington, DEBuilt 1968 · S/N 28-5083N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647N5114HReints Rydell J · Wasilla, AKBuilt 1948 · S/N 14-120N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974N5114LHenry Lawrence D · Lohman, MOBuilt 1967 · S/N 28-4397N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126N5114RHayden Steven E · Westminster, COBuilt 1974 · S/N MB-648N5114SConner W Larry · Los Lunas, NMBuilt 1971 · S/N 28R-7135148N5114THarlan Robert J · Kaycee, WYS/N 71
Back to AD 87-10-06 R1