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.

N916JGGriffin Aerospace Solutions LLC · Bridgeport, WVBuilt 1996 · S/N 0041N916JTRugg Ranches LLC · Pilot Rock, ORBuilt 2021 · S/N CCK-2000-0064N916KSmith Brandon D · Laguna Beach, CABuilt 2005 · S/N 001N916LTTillman Tracy S · Webberville, MIBuilt 2002 · S/N 25088CN916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265N916MCJanicke Kenneth O · Wichita, KSBuilt 2009 · S/N T18208914N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177N916MRReyes Michael L · Kansas City, MOBuilt 2007 · S/N 70760N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159N916RDUssery Donald R · Blytheville, ARS/N 23-1743N916RKGrant Aviation Inc · Anchorage, AKBuilt 2012 · S/N GA8-12-176N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640N916SLWiseman Susan · Sacramento, CABuilt 2012 · S/N 40015N916STHorizon Aviation LLC · Kalispell, MTBuilt 2019 · S/N CCK-1865-1056N916TMMo Properties & Investments LLC · Lakewood, COBuilt 1994 · S/N 1809101N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146N916WGGammell Bernard W · Nampa, IDBuilt 2022 · S/N 122-231/232-1281N916YEggimann William W Trustee · Anchorage, AKBuilt 1973 · S/N 18-7309023N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224N9170HWeight Steven A · Fairview Park, OHBuilt 1993 · S/N 27-0175N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659N9170RPage David L · Bermuda Dunes, CABuilt 1994 · S/N 27-0177N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783N9170VMitchell Kevin L · Glen Saint Mary, FLBuilt 1969 · S/N 690032N9170WWyatt Jeffrey Ron · Lubbock, TXBuilt 1966 · S/N 28-10825N9170XVb Inc · Show Low, AZBuilt 1989 · S/N 4622018N9171CCartright Eugene · Pelham, NHBuilt 1978 · S/N R18200435N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226N9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232N9171LBrolan Aviation LLC · Kansas City, MOBuilt 1970 · S/N 258-71N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660N9171VMau Allen D · Stockton, CABuilt 1969 · S/N 690044N9171YAirelibre Aviation Inc · Wilmington, DEBuilt 1987 · S/N 1N91727Qualitair LLC Trustee · MichelstadtBuilt 1999 · S/N 27-0267N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661N9172SShuffield Brian D · Oregon House, CAS/N M-1793N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034N91734Lejeune Walter R III · Clarksville, TNS/N 4622040N9173CBettendorf Nicholas L · Mchenry, ILBuilt 1978 · S/N R18200436N9173HSmitty 172 LLC · Rockford, MIBuilt 1975 · S/N 17265992N9173XLinzel Jesse G Jr · Southern Pines, NCBuilt 1996 · S/N 11-176N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035N9174NPool Aaron · Houston, TXBuilt 1989 · S/N 4622054N9174TPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009013N9174VFrink Jeff · Chandler, AZBuilt 1969 · S/N 690033N9174WKwan Andrew W · Lynnwood, WABuilt 1966 · S/N 28-10829N91751Aviators Cooperative LLC · Colorado Springs, COBuilt 1973 · S/N 17261509N9175GRepelatron Skyway LLC · Wilmington, DEBuilt 1989 · S/N 3206051
Back to AD 87-10-06 R1