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.

N6611UVan Koevering Dennis Jay · Hudsonville, MIBuilt 1963 · S/N 106N6611WBryant Bryce Nicholas · Crothersville, INBuilt 1965 · S/N 28-20705N6612LSwanson Thomas J · Pukwana, SDBuilt 1974 · S/N 187409111N6612RCourtney David P · Reedsport, ORBuilt 1979 · S/N 172RG0214N6612UGiem James L · Coupeville, WABuilt 1963 · S/N 107N6612VEverman Terry Jay · Vassar, MIBuilt 1980 · S/N 172RG0781N6613H6613 H Ltd · Wilmington, DEBuilt 1975 · S/N 17265510N6613RPollazzi Steven N · New Hope, PABuilt 1974 · S/N MC-312N6613WBanks Jeffrey G · Columbus, OHBuilt 1965 · S/N 28-20707N6613YAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1969 · S/N 27-4395N6614UVanderford Kenneth W · Fort Worth, TXBuilt 1963 · S/N 109N6614VThomas Anna D · Kiana, AKS/N 172RG0782N6615DCivil Air Patrol Inc · Montgomery, ALBuilt 1979 · S/N 17272902N6615JAeropenn Aviation Academy LLC · Paxinos, PAS/N 28-5079N6615NTexas Skyways Research & Development · Boerne, TXBuilt 1981 · S/N 18267845N6615UDobos Lester J · Bordentown, NJBuilt 1963 · S/N 110N6615WLoughridge Steven L · Montezuma, OHBuilt 1965 · S/N 28-20710N66168C P Aviation · Santa Paula, CABuilt 1983 · S/N 17275974N6616DMjng Investment Group LLC · Melbourne, FLBuilt 1979 · S/N 17272903N6616HBurke Anthony · Poughkeepsie, NYBuilt 1975 · S/N 17265511N6616JBrack Enterprises LLC · Indianapolis, INBuilt 1968 · S/N 28-5081N6616PMorrison Austin · Statesville, NCBuilt 1960 · S/N 24-1737N6616RVanover Kevin · Whitesburg, KYS/N MB-736N66175Stohlquist James R · Alamosa, COBuilt 2005 · S/N T18208414N66177Newman Ken · Hood River, ORBuilt 2005 · S/N T18208375N6617ELinstad Daniel Elmer · Canby, ORBuilt 1978 · S/N 17272045N6617HNorth Franklin County Flying Club · North Lawrence, NYBuilt 1975 · S/N 17265512N6617JJeffries Holdings LLC · Bargersville, INBuilt 1980 · S/N 17273900N66184Sec Fl Corp · Santa Rosa Beach, FLBuilt 2005 · S/N T20608518N66189Skynick Enterprises Inc · Tarzana, CABuilt 1983 · S/N 17275976N6618DStein Air LLC · New Ringgold, PABuilt 1979 · S/N 17272905N6618PChurchill John C · Parker, AZBuilt 1960 · S/N 24-1739N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783N6618WLe Ariya · La Crosse, WIBuilt 1965 · S/N 28-20713N6618ZRotor And Wing · Tioga, NDBuilt 1962 · S/N 25-2187N6619DBannwart Justin S · North Liberty, INBuilt 1979 · S/N 17272906N6619JBjelland Nathan D · Phoenix, AZBuilt 1968 · S/N 28-5085N6619PRatliff Byron L · Paragould, ARBuilt 1960 · S/N 24-1740N6619ULucas Jolie Candace · Pismo Beach, CABuilt 1965 · S/N 732N6619VTeton Leasing LLC · Pocatello, IDBuilt 1968 · S/N 1824-24N661ASSaldarriaga Alvaro · Ocala, FLBuilt 2025 · S/N 6093N661CCMarkey John J Jr · Aurora, ILS/N 303N661DJRadley Larry L · Universal City, TXBuilt 1991 · S/N 24661N661FLS B Enterprise LLC · Marshall, TXBuilt 1971 · S/N 28-7125581N661FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020186N661HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2000 · S/N T20608208N661JCKruse Thomas S · Mena, ARBuilt 1999 · S/N 23001N661JPEvans Craig A · Irvine, CABuilt 1980 · S/N 661N661JSStrausbaugh Joseph A · Dublin, OHBuilt 2009 · S/N 70276N661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 2890028
Back to AD 87-10-06 R1