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.

N981CCengiz John · Clifton, NJBuilt 1993 · S/N 247-320-15N981CMClaypool James W · Hunts Point, WABuilt 1998 · S/N 1247-98N981CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280215N981JPBull Six LLC · Edmond, OKBuilt 2009 · S/N 40674N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239N981MMMccalmont Marc W Trustee · Springfield, NHBuilt 1996 · S/N 3268N981RVOwen Scott E · Missoula, MTBuilt 2010 · S/N 90863N981SHSmith Helicopters Inc · Cotulla, TXBuilt 1998 · S/N 2791N981SLRotor Technologies Inc · Nashua, NHBuilt 1998 · S/N 2871N981SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8183N981SUHoloubek Mark R · David City, NEBuilt 1975 · S/N 28-7505252N981WSNayrmarc LLC · Linden, MIBuilt 1998 · S/N 18280328N981WUEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280555N98203Rfb Cherokee LLC · Perkinston, MSBuilt 1969 · S/N 28-26099N98205Uhlemeyer Douglas · O Fallon, MOBuilt 1969 · S/N 28-26102N98208Anderson James D · Tecumseh, MIBuilt 1969 · S/N 28-26105N9820HSeghieri Richard T · Santa Rosa, CABuilt 1981 · S/N 18268049N9820WMcgahan Merrill M · Kenai, AKS/N 28-23322N98210Hancock Ricky L · Anchorage, AKBuilt 1969 · S/N 28-26106N98212Alpha Aviation Group LLC · Clawson, MIBuilt 1969 · S/N 28-26108N98218Engleman Roy J · Mcalester, OKBuilt 1969 · S/N 28-26114N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721N9821UCoquimbo Capital Holdings LLC · Sandy, UTBuilt 1976 · S/N AA5A0221N98222Diol Ranjit S · Dowagiac, MIBuilt 1969 · S/N 28-26117N98223Lustig Keith C · Clyde, MIBuilt 1969 · S/N 28-26118N98226Whited Ronald Glenn · Tampa, FLS/N 28-26120N9822UMoyer Curtis · Bedford, INBuilt 1976 · S/N AA5A0222N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515N9822YMontana Aviation Tryst LLC · Kalispell, MTBuilt 1961 · S/N 7GCB-57N98237Pierce Teddy D · Savannah, MOBuilt 1969 · S/N 28-26125N98239Sushko Michael S · Plymouth, MNS/N 28-26126N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623N9823MKoelsch Benjamin · Nome, AKBuilt 1965 · S/N 1007CN9823UMorrow Robert C · Edgewater, FLBuilt 1976 · S/N AA5A0223N98240Petersen Amos I · Iowa City, IAS/N 28-26127N98241Lh Investments Inc · Albany, ORBuilt 1969 · S/N 28-26129N98242Husbands Klayton P · Bosque, NMBuilt 1969 · S/N 28-26130N98244Kingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26002N98249Tramper Air LLC · Rockford, MIBuilt 1969 · S/N 28-25972N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624N9824PKnutson Wayne R · Thompson, NDBuilt 1975 · S/N 25-7556142N9824UPurpose Flight International LLC · Wilmington, DEBuilt 1976 · S/N AA5A0224N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269N98257Fly High Aviation LLC · Miami, FLBuilt 1969 · S/N 28-25954N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725N9825WBunch Matthew B · Georgetown, KYBuilt 2000 · S/N 0412N98263Myers Bobby L · Brookhaven, MSBuilt 1969 · S/N 28-26132
Back to AD 87-10-06 R1