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.

N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511N9811WAbove The Best Consulting LLC · Clarksville, TNS/N 28-23311N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261N98127Lucas James J · Rossville, TNBuilt 1969 · S/N 28-26058N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046N9812CHodgs Sidney L · Cimarron, KSBuilt 1978 · S/N 28-7890445N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920N9812WSaylor Herbert R · Dover, DEBuilt 1967 · S/N 28-23312N98131Registered aircraftBuilt 1969 · S/N 28-26059N98134Stanly Business Consultants LLC · Albermarle, NCS/N 28-26064N98135Tropical Island Aircraft LLC · Clearwater, FLBuilt 1969 · S/N 28-26065N98136Tringale Alison T · Port Saint Joe, FLBuilt 1969 · S/N 28-26066N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512N9813WAdelza Group Holdings LLC · Orlando, FLBuilt 1967 · S/N 28-23314N9814CZechlin Margaret Christine · Novato, CABuilt 1978 · S/N 28-7890446N9814DGupton Scott W · Prescott Valley, AZBuilt 1959 · S/N 22-6701N9814PBeardsley Taylor J · Miles City, MTFirst renewal noticeBuilt 1976 · S/N 18-7609033N98150Schaulin Frederick S · Fort Collins, COBuilt 1969 · S/N 28-26075N98151Margulies Isaiah · New Orleans, LABuilt 1969 · S/N 28-26076N98152Smith Austin M · Prescott, AZBuilt 1969 · S/N 28-26077N98158Weber Lawrence D · Fairfield, ILBuilt 1969 · S/N 28-26079N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618N9815PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556129N9815UHonsinger Gary · Wesley Chapel, FLBuilt 1976 · S/N AA5A-0215N98161Gentis Tyler A · Riverside, CABuilt 1969 · S/N 28-26081N98167Hileman Theodore D · Burbank, WABuilt 1969 · S/N 28-26084N98168Wankel David · Beardstown, ILS/N 28-26083N9816DWierda Evert T · Manhattan, MTBuilt 1959 · S/N 22-6703N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716N9816UCheetah Air LLC · Edinburg, NDBuilt 1976 · S/N AA5A-0216N98171Aberdeen School District · Aberdeen, MSBuilt 1969 · S/N 28-26085N98176Bluewater Airmotive Corp · Wilmington, DEBuilt 1969 · S/N 28-26088N98186Loyer Jeffrey W · Olympia, WAS/N 17276265N9818DEpperly Lloyd A · Naples, FLBuilt 2012 · S/N 82094N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718N9818UGainous David C · Port Saint Joe, FLBuilt 1976 · S/N AA5A-0218N9818W98x LLC · Caddo Mills, TXBuilt 1967 · S/N 28-23320N98190Coastal Air Inc · Groton, CTFirst renewal noticeBuilt 1969 · S/N 28-26094N98192N98192 LLC · Dunnellon, FLBuilt 1969 · S/N 28-26095N98194Christensen-Glanz Melanie · Polson, MTS/N 28-26097N98196Triplett Robert B · Uniontown, OHBuilt 1969 · S/N 28-26252N9819PHolder R William · Pittsfield, PABuilt 1975 · S/N 25-7556136N9819UFruehwirth Kevin · Spring, TXBuilt 1976 · S/N AA5A0219N981ACOtterback Nicholas L · Unionville, TNBuilt 2015 · S/N 60341N981BCSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1998 · S/N 17280464N981BTPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1998 · S/N 17280430
Back to AD 87-10-06 R1