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.

N7766WBair Dale Leroy · Canton, OHBuilt 1964 · S/N 28-1766N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467N7767PStock Keith A · Warrensburg, MOS/N 24-2983N7767WFinan Kevin P · Seattle, WAS/N 28-1767N7768MHoyle Charles D Jr · Eureka, CABuilt 1974 · S/N 22-0024N7768NLeap Frog Aviation LLC · Bentonville, ARBuilt 1968 · S/N 28-5215N7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAS/N 24-2984N7768VSky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 1525N7768WKilo Niner Aviation LLC · Saint Petersburg, FLBuilt 1964 · S/N 28-1769N7769Sherburne Asher J · Redlands, CABuilt 1997 · S/N SN001LRN7769MCorso Nicholas J · Stuart, FLBuilt 1974 · S/N 22-0025N7769NWoolsey Bradley W · Burleson, TXBuilt 1968 · S/N 28-5216N7769WSeverson Michael A · Nampa, IDBuilt 1964 · S/N 28-1770N7769ZCentral Air Parts Inc · Staunton, ILS/N 25-3963N776ACMonska Stephen M · Florence, MABuilt 1997 · S/N 1233-97N776AWKustatan Leasing LLC · Nikiski, AKBuilt 1964 · S/N 18-8139N776BCTyndall Darryl K DBA · Deep Run, NCBuilt 2000 · S/N 2079N776CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881764N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753N776DGArmbruster Richard G · Chardon, OHBuilt 2018 · S/N 25101N776DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N R18200556N776GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881472N776GAHinds Community College · Raymond, MSBuilt 1978 · S/N GA7-0065N776JNSchemmel Grant P · Florence, COS/N 23785N776LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2002 · S/N S1841N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078N776NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881044N776NHHylton Nathaniel Dean · Pleasant Plain, OHBuilt 1965 · S/N 567N776RMiano Steven Mitchell · Clearwater, FLBuilt 2002 · S/N 22232N776RVThams Kurt T · Soquel, CABuilt 1998 · S/N 002N776SHExplore Helicopters LLC · Lexington, ALBuilt 2004 · S/N 3552N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165N7770BDunning John L · East Hampton, NYBuilt 1974 · S/N 28-7515108N7770CMcgee Ronald S · Waco, KYBuilt 1975 · S/N 28-7625083N7770DJenkins Robert H · Kill Devil Hills, NCBuilt 1972 · S/N 28R-7235220N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470N7770NThompson Brad J · Pleasant View, TNBuilt 1969 · S/N 28-5217N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986N7770WN7770w LLC · Sheridan, WYBuilt 1964 · S/N 28-1771N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471N7771NSale Reported · Copper Center, AKSale reported, pending cancellationS/N 28-5218N7771RWeatherbee Mark B · Lincoln, MEBuilt 1995 · S/N 687N7771WWhitman Edward G · River Falls, WIBuilt 1964 · S/N 28-1773N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857N7772CCummings David P · Grayson, LABuilt 1975 · S/N 28-7625084N7772DWilliams Stephen M · Fort Walton Beach, FLBuilt 1957 · S/N 18-5958N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7772HGws Contractors Inc · Bonne Terre, MOBuilt 2004 · S/N T18208257N7772NZmq Aviation LLC · Minneapolis, MNBuilt 1968 · S/N 28-5219N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515
Back to AD 87-10-06 R1