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.

N98308Morse Robert M · Mayetta, KSBuilt 1969 · S/N 28-26162N98319Restin Air LLC · Kalispell, MTBuilt 1969 · S/N 28-26167N9831WMeyer Dale K · Altamont, NYS/N 28-23335N98320Flyg5 LLC · New London, WIBuilt 1969 · S/N 28-26168N9832WMcmillin Joey D · Edmond, OKBuilt 1967 · S/N 28-23337N98335Wiggs Billy L Jr · Fayetteville, NCBuilt 1969 · S/N 28-26174N98345Fly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26178N98348Industrial Transportation & Distr Consulting LLC · Franklin, OHBuilt 1969 · S/N 28-26179N9834WExceptional Construction LLC · Greenacres, WABuilt 1967 · S/N 28-23340N98351Carufel Elizabeth R · Mesa, AZBuilt 1969 · S/N 28-26180N98357Mook Jerry L · Merritt Island, FLS/N 28-26185N98360Jts Aircraft LLC · Rock Hill, SCS/N 28-26184N98363Fala Lee A · Glendale, AZS/N 28-26187N98365Woolery Timothy A · Maryville, MOBuilt 1969 · S/N 28-26190N98371Buhrow Chris Alan · Humble, TXBuilt 1969 · S/N 28-26195N98372Harlow James Patrick · Liberty Hill, TXBuilt 1969 · S/N 28-26196N98377Sloan Allen Lee · North Augusta, SCBuilt 1969 · S/N 28-26198N98378Basta Scott C · Hayes, VABuilt 1969 · S/N 28-26199N9837WSpeare Clifford W · Saint Charles, ILBuilt 1967 · S/N 28-23344N98380Reese Trenton · Post Falls, IDBuilt 1969 · S/N 28-26128N98383Dunn Karl L · Hazel Green, ALBuilt 1969 · S/N 28-26202N98384Macmillan Alfred R Jr · Salisbury, MDBuilt 1969 · S/N 28-26203N98388Salzwedel Timothy F · New Lisbon, WIBuilt 1969 · S/N 28-26155N98389Sale Reported · Rosenberg, TXSale reportedBuilt 1969 · S/N 28-26207N9838WDutton Margaret Stephanie Executor · Mooresville, NCBuilt 1967 · S/N 28-23345N9839KP P I Consulting LLC · Gladstone, ORBuilt 1977 · S/N 28-7816198N9839WLoiselle Matthew J · Birch Run, MIBuilt 1967 · S/N 28-23346N983SRSnyder James E · Butler, NJBuilt 1979 · S/N 32R-7985094N9840WWings Of Grace Ministries Inc · Melbourne, FLBuilt 1967 · S/N 28-23347N9841WDubois Aviation Inc · Chino, CABuilt 1967 · S/N 28-23349N9842WIreys Charles G · Tok, AKBuilt 1967 · S/N 28-23350N9843KN9843k LLC · Melbourne, FLBuilt 1977 · S/N 28-7890187N9843WBeeson Jeffrey K · Crowley, TXBuilt 1967 · S/N 28-23351N9844SSpace Coast Aircraft Co · Merritt Island, FLBuilt 2002 · S/N 2842148N9844WBarson Nicholas J · Fort Pierce, FLBuilt 1967 · S/N 28-23355N9845KRaleigh Flying Club LLC · Chapel Hill, NCBuilt 1977 · S/N 28-7890188N9845WLipskoch Anthony P · Buhl, IDS/N 28-23356N9846WVladimir Martyanov · Chandler, AZBuilt 1967 · S/N 28-23357N9847WLukas Craig S · Omaha, NEBuilt 1967 · S/N 28-23359N9849WKauenhofen Jacobo DBA · Boley, OKBuilt 1967 · S/N 28-23361N984SWWaits Paul C · Blanchard, OKBuilt 1969 · S/N 28-5415N9850WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23362N9853WReynolds Stuart N II · Sutherland, VABuilt 1967 · S/N 28-23366N9854WPerry Michael · Wilmer, ALBuilt 1967 · S/N 28-23367N9855SAri Ben Aviatior Inc · Fort Pierce, FLBuilt 2002 · S/N 2842151N9855WWilliamson Flying Club Inc · Williamson, NYBuilt 1967 · S/N 28-23369N9858WPearce Ronald M · Madison Heights, MIBuilt 1967 · S/N 28-23372N9859WBerry Meredith W III · Covington, LABuilt 1967 · S/N 28-23374N985NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881903N9860WCalkins Ray · Socorro, NMS/N 28-23375
Back to AD 87-08-08 R3