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.

N926AJWalter Michael A · Middleburg, PAS/N 475RN926ASHanson William L · Auburn, CAS/N 1N926BBBb Air · Stuart, FLBuilt 1978 · S/N 32-7840085N926BJUrban Gary E · Charlotte, NCBuilt 2001 · S/N 20381N926BWTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1974 · S/N 770-74N926CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 2881040N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327N926CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8914N926DGPerkins James W · Georgetown, TXBuilt 2000 · S/N 20473N926DKSuthar Jay P · Danville, VABuilt 2002 · S/N 22867N926EZEcho Zulu LLC · Middletown, DES/N HSLE 2-95N926GG2 Aviation LLC · Franklin, WIBuilt 2017 · S/N 41141N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007N926JGGutwein Jan · Venice, FLBuilt 2005 · S/N 024-39/40-680N926JPJl Aviation LLC · Crestwood, KYBuilt 2004 · S/N 490-2004N926MKToothman John C · Fairmont, WVBuilt 1971 · S/N 28-7125138N926MMGurewitz Alan · Thousand Oaks, CABuilt 2003 · S/N EP-01-80809N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N926NLRemington Robert J · Sheboygan Falls, WIS/N 172S8812N926PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843289N926RUPottratz Dwane L · Beaverton, ORBuilt 1998 · S/N 23327N926TCTango Charlie LLC · Gig Harbor, WABuilt 1997 · S/N 18280052N926TEAnderson & Associates Inc · Little Rock, ARBuilt 2002 · S/N 10205N926TMSwanson Richard E · Livermore, COBuilt 2008 · S/N 72184N926WBBender Walter F Jr · Virginia Beach, VABuilt 2000 · S/N 18280819N926WTArmadillo Aviation LLC · Scottsdale, AZBuilt 2002 · S/N 60587N92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605N9270DDowns Dennis D · Sterling, AKS/N 18-6569N9270KSlc Service Leasing Company LLC · Tipton, IAFirst renewal noticeBuilt 1974 · S/N 28-7410027N9270MMcmanus Nicholas A · Versailles, KYBuilt 1966 · S/N 1211N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770N9270SVinson Raymond R III · Mckinney, TXBuilt 1975 · S/N MC-392N9270VPhilippi Harrold Mark · Metairie, LABuilt 1969 · S/N 690073N92714Registered aircraftBuilt 1996 · S/N 4636042N92717Hold Fast Property LLC · Alto, NMBuilt 1996 · S/N 4636043N92719Mood Glen M · Ward Cove, AKBuilt 1946 · S/N 12-155N9271DGrasser Edward K · Palmer, AKBuilt 1958 · S/N 18-6572N9271MCantelmi Richard L · Bethlehem, PABuilt 1966 · S/N 3459N9271RUpwind Aviation LLC · Mitchell, SDBuilt 1978 · S/N R18200676N9271SLife Is A Beech LLC · Commerce City, COBuilt 1976 · S/N M-1757N9271WMcelwee Jerilyn · South Riding, VABuilt 1967 · S/N 28-10944N92720Registration Pending · Champaign, ILRegistration pendingS/N 17261608N92722Bryant David A · Walhalla, SCBuilt 1973 · S/N 17261609N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050N9272DMummy Mountain Med LLC · Paradise Valley, AZBuilt 1958 · S/N 18-6573N9272HBlackbird 71 LLC · Rockford, ILBuilt 1975 · S/N 17266060N9272JEast Fork Flyers LLC · Lu Verne, IABuilt 1966 · S/N 28-3350N9272LValira Aviation II LLC · Oakland, CABuilt 1997 · S/N 2843077N9272MSearle Jacob · Kuna, IDBuilt 1966 · S/N 3460N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772
Back to AD 87-10-06 R1