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.

N8920JSargent Timothy E · Pickerington, OHBuilt 1965 · S/N 28-2937N8921DPetterson Jason G · Albert Lea, MNBuilt 1958 · S/N 22-6078N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8921RPotters Aviation LLC · Haskell, OKBuilt 1960 · S/N 7GCA-168N8921VN2827n LLC · Pembroke Pines, FLS/N 17264278N8922Culver Marc D · Anchorage, AKBuilt 1973 · S/N 493-73N8922DHassell Clark R · Ketchikan, AKBuilt 1958 · S/N 22-6079N8922JTowner Jeffery D · Rose Hill, KSBuilt 1965 · S/N 28-2939N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717N8922VTampa Bay Aviation Inc · Clearwater, FLBuilt 1974 · S/N 17264279N8923Brockway Troy D · Salina, KSBuilt 1973 · S/N 481-73N8923DWood Rhonda R · Livermore, CABuilt 1958 · S/N 22-6080N8923JVenture West LLC · Mesa, AZBuilt 1965 · S/N 28-2940N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718N8924DHickey Aero Services LLC · White Hills, AZS/N 22-6081N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281N8924WRiblet Jeffrey L · Portsmouth, VABuilt 1964 · S/N 28-10489N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925FAztec Aviation · Geneseo, ILBuilt 1964 · S/N 0307N8925NMackay James R · Corunna, MIS/N 32-40721N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926Johnson David H · Jasper, GABuilt 1973 · S/N 367-73N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284N8927WFiihr Travis A · Grand Junction, COBuilt 1964 · S/N 28-10492N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73N8928FDenver Aerospace Science Museum · Watkins, COBuilt 1964 · S/N 0004N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946N8928MKeyt Jeffrey D · New Providence, NJBuilt 1963 · S/N TD-555N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947N8929LPeters Nicholas J · Eagle River, AKBuilt 1974 · S/N 18-7409127N8929WSimmons Ralph R Jr · Sadler, TXBuilt 1964 · S/N 28-10494N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398N892BVGd Aviation Inc · Belleair, FLBuilt 2004 · S/N 18281329N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041N892MPlyler Aviation Lp · Sherman, TXBuilt 1993 · S/N 301-8N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029N892PTTims Duane R · Hemet, CABuilt 2012 · S/N 70567N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379N892SGCraik Evelyn June · Las Vegas, NVBuilt 1966 · S/N 1114N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111
Back to AD 87-10-06 R1