OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N30561Eisele William L · Laporte, INBuilt 1978 · S/N 28-7990096N30565Flowings LLC · Orlando, FLBuilt 1968 · S/N 17701331N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332N3056ARegistered aircraftBuilt 1953 · S/N 25700N3056DApplied Aviation LLC · Grain Valley, MOS/N 32R7987060N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598N3056SMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1979 · S/N 28R-7918058N3056ZPopson LLC · Peachtree City, GABuilt 1979 · S/N 28-7990412N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333N30571Spencer Burton D · Mchenry, ILS/N 17701334N30573Dentdel Inc · Wilmington, DEBuilt 1994 · S/N 1615N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293N3057PMcneil Michael D · Caro, MIS/N 23-969N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3058VN5237l LLC · Oswego, NYS/N 1617N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093CN30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061N305BSAllen Andra L · Gila, NMBuilt 1999 · S/N S1796N305DKWashington State Patrol · Olympia, WABuilt 1999 · S/N 20608080N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692N305KGBelisle Kenneth C · Jacksonville, FLS/N SN038N305KTAlvord Jonathan Drew · Prosser, WABuilt 2010 · S/N 40064N305MCShen Air II Inc · Mount Crawford, VABuilt 1973 · S/N 32-7340118N305MDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020255N305NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881616N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131N305RCWashington State Patrol · Olympia, WABuilt 2001 · S/N 18281001N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834N305SNMeshoppen Air LLC · Tunkhannock, PABuilt 1984 · S/N 2038N305UMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020051N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016N30602Reinert Joseph M · Ringgold, GAS/N 28-8011055N30603Registered aircraftBuilt 1969 · S/N 17701353N30608Christiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496180N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251
Back to AD 87-10-06 R1