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.

N6798DBeard Roger D · Mooresville, INBuilt 1959 · S/N 19N6798HWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N 17265586N6798JDead Frog LLC · Miles City, MTBuilt 1968 · S/N 28-24529N6798UAzevedo Robert S · Socorro, NMBuilt 1963 · S/N 2510N6798WRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N 28-20932N6799PThomas Nicholas O · Cave Springs, ARS/N 24-1932N6799URegistered aircraftBuilt 1963 · S/N 2511N6799VPolgreen Andrew · Leonardtown, MDBuilt 1970 · S/N 700070N679ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010079N679BBMendez Gaston Jr · Coral Springs, FLBuilt 1980 · S/N 61P07868063399N679CMShaughness Michael · Raleigh, NCBuilt 1990 · S/N 20102N679DBDeddens R Michael · Camarillo, CABuilt 2003 · S/N 917-2003N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138N679DMColumbia Whiskey Bravo LLC · Americus, GABuilt 1979 · S/N 32-7940244N679DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280940N679HCKal Aire Flying Club Inc · Mattawan, MIBuilt 1979 · S/N 28-7990425N679JTAdventure Aviation Sales Inc · Jeffersonville, INBuilt 1976 · S/N 17702428N679LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881229N679MMcquack Aviation LLC · Belding, MIS/N 2393N679MCVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281678N679NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881150N679RBBundschuh Raymond W Jr · Mililani, HIS/N 679N679RKRwr Air Inc · Tok, AKBuilt 1956 · S/N 18-5024N679TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881879N679TSCoco Aircraft Inc · Merritt Island, FLBuilt 1998 · S/N 2842045N67ASAviation Safety LLC · Fruita, COBuilt 2002 · S/N 163N67ATBrown Bill L · Anchorage, AKBuilt 1981 · S/N 1018N67BFHigh Key Aviation LLC · Windsor, VABuilt 2002 · S/N 461-2002N67BMOswin William R Jr · Newton, NJFirst renewal noticeS/N 1251N67CEPearce William · Grants Pass, ORBuilt 1993 · S/N 3125N67CJEngineered Cub Components Inc · Chugiak, AKBuilt 2003 · S/N AF18090CJN67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566N67DStreet Mark D · Rch Palos Vrd, CABuilt 1972 · S/N 1333514N67DBD&R LLC · Emory, TXBuilt 1974 · S/N 28-7505096N67DDDietz Michael D · Big Lake, AKBuilt 1965 · S/N 2516N67DLMcarthur Narik D · Mammoth Lakes, CAS/N 28-25605N67EEShok Eric D · Tucson, AZBuilt 2005 · S/N 25422N67EXLatterell Jerry W · Foreston, MNS/N 670227N67FDDragon Leasing Corp · Naperville, ILBuilt 1984 · S/N 728N67FNNoska Frank S IV · Wasilla, AKBuilt 1966 · S/N 18-8481N67GFOld Buzzard Aviation Inc · Middleburg, FLBuilt 1967 · S/N TD-700N67GKKillam Galen · Wautoma, WIBuilt 2002 · S/N 80229N67GTTiger Partners M/A LLC · Wilmington, DEBuilt 1977 · S/N AA5B0414N67HBranholm David M · Wasilla, AKS/N 002N67HHStreng Martin K · Carson City, NVBuilt 1996 · S/N 2992N67JCSeltman Jack A · Wichita, KSBuilt 1979 · S/N 101N67JMEck Gary A · Osceola, INBuilt 1973 · S/N 17701940N67KAH2f2 LLC · Prairie Village, KSS/N 2204N67KBGarrison Clay L · Madera, CABuilt 1991 · S/N 1686N67KCBlanchard Robert E Jr · Washburn, WIBuilt 1985 · S/N 1185
Back to AD 87-10-06 R1