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.

N8885JWeise David D · Marion, TXBuilt 1965 · S/N 28-2859N8885WBarker Theo G T · Loveland, COBuilt 1964 · S/N 28-10445N8885YWilson Cecil · Lithonia, GABuilt 1970 · S/N 39-43N8886WTuggle Rodney J · Kansas City, MOBuilt 1964 · S/N 28-10446N8887FNiec Steven M · Clio, MIBuilt 1963 · S/N 73-0263N8887JWeskap LLC · West Grove, PABuilt 1965 · S/N 28-2862N8888EFieseler Ronald G · Blanco, TXS/N FI 189N8888JSnapp Steve J · Los Alamos, NMS/N 28-2863N8888NGibson Edward J · Marmora, NJBuilt 1967 · S/N 7KCAB-58N8888SStrizki Brian J · Flemington, NJBuilt 2002 · S/N 80624N8888WHoffman Jackie R · Friend, NEBuilt 1964 · S/N 28-10449N8888X82 Saratoga LLC · Bryant, ARBuilt 1989 · S/N 4622078N8888YPriebe Rodney M · Wasilla, AKBuilt 1973 · S/N 18-7409028N8889EWestern New York Flying Club Inc · Bowmansville, NYBuilt 1976 · S/N 28-7690214N8889VGarcia Hector A · Caguas, PRBuilt 1974 · S/N 17264247N8889WNedoba John · Stevensville, MIBuilt 1964 · S/N 28-10450N888ADAlirio Land Services · Miami Gardens, FLBuilt 1968 · S/N 28R-30913N888AGKlingensmith John R · Santa Maria, CABuilt 1998 · S/N 1042N888APAnderson Scott · Edgartown, MABuilt 1976 · S/N 28-7715105N888AWCag International Inc DBA · Longmont, COBuilt 1973 · S/N 28-7305386N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282N888BWAero Elite Inc · Wilmington, DEBuilt 1970 · S/N 28-5856N888CBBenz James E · Pittsford, NYBuilt 1974 · S/N 17264417N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324N888CFJph Aviation LLC · Pittsburgh, PABuilt 1965 · S/N 457N888CKRadel James C · Sunbury, PABuilt 1989 · S/N 888PMN888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424N888DLCsc Enterprises Inc · Atlanta, GABuilt 1999 · S/N 2980N888EBCharcoals Smokehouse LLC · Katy, TXBuilt 1977 · S/N 32R-7780194N888EGMooney N888eg LLC · Granbury, TXBuilt 1989 · S/N 27-0021N888EJInternational Air Services Inc Trustee · Carson City, NVS/N 2816082N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087N888EZRabideau Jacob N · Tehachapi, CABuilt 1983 · S/N 564N888FF2826 LLC · Inola, OKBuilt 2007 · S/N 40218N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857N888GHCardinal Gregory Joseph · Minneapolis, MNBuilt 1992 · S/N 52N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264N888GRGraves George L · Brownville, MEBuilt 1996 · S/N 3882N888HACm3 LLC · North Las Vegas, NVBuilt 2006 · S/N 11032N888HUPeoples Michael L Jr · Rockwall, TXBuilt 1998 · S/N 1397N888JDThille Nicholas M · San Luis Obispo, CABuilt 1968 · S/N TD-720N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078N888KHFranklin Vernon L · Aguila, AZBuilt 2005 · S/N 25478N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272N888LHReece Connor I · Green Cove Springs, FLBuilt 1997 · S/N 21045N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066N888QCShipley Ryan Paul · Keller, TXBuilt 1977 · S/N 28-7716175N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139
Back to AD 87-10-06 R1