OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N8842WMott Terry W · Hampton, IABuilt 1964 · S/N 28-10392N8843JDiorio Christopher J · Melba, IDS/N 28-2801N8843WDay Eric N · Weatherford, TXBuilt 1964 · S/N 28-10393N8843YBw Aviation LLC · Wilmington, DES/N 32R-8013061N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N8846WMosby Eric M · Tallahassee, FLBuilt 1964 · S/N 28-10397N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8847WCitro Michael A · Oakley, CABuilt 1964 · S/N 28-10398N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8848WHocken David L · Avoca, IABuilt 1964 · S/N 28-10400N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849MGuertin Jim B DBA · Lincoln, CABuilt 1969 · S/N 28-11321N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N8849WAtchison Walter L · Los Alamos, NMBuilt 1964 · S/N 28-10401N884CCRegistered aircraftBuilt 2001 · S/N 3257221N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N8852WSussex Aero Maintenance Inc · Georgetown, DEBuilt 1964 · S/N 28-10405N8853CEuropa Aero LLC · Bucyrus, OHBuilt 1976 · S/N 32R-7680141N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8853NN8853n LLC · Poplar Bluff, MOS/N 28-25707N8854WCherokee235 LLC · Kalispell, MTFirst renewal noticeBuilt 1964 · S/N 28-10408N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711N8856WSouthard Brian W · Washington, OKS/N 28-10410N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928N8858WCassidy Kirk B · La Canada, CABuilt 1964 · S/N 28-10412N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340N885ACWingsleasing LLC · Wichita, KSBuilt 2020 · S/N 2881396N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826N8860WLayth Air LLC · Martin, TNBuilt 1964 · S/N 28-10414N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410N8861WFrancavilla Charles · Fremont, CABuilt 1964 · S/N 28-10416N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717N8863WPratt William D · Cashmere, WAS/N 28-10418N8864NKnutson Wayne R · Thompson, NDS/N 28-25725
Back to AD 87-08-08 R3