OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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.

N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022N4329XS&S Aircraft Inc · Bennington, VTBuilt 1975 · S/N 28R-7635011N432DPZarick Edward T III · Fort Myers, FLBuilt 1978 · S/N 32R-7887092N432DRJazz Air LLC · Melbourne, FLBuilt 1997 · S/N 3246084N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547N432KCKjomo Aviation LLC · Ocean Springs, MSBuilt 2004 · S/N 3246225N432LLBuckingham Aero LLC · Buckingham, VABuilt 2006 · S/N 3257432N432NCHerbert Jason Brian · Saginaw, MIBuilt 1978 · S/N 32R-7885090N432WWMiller Kris K · Cary, NCFirst renewal noticeBuilt 1982 · S/N 28-8390009N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026N4330FKnighton Donna L · Lancaster, CABuilt 1976 · S/N 32R-7680437N4330RBellinger Joshua · Monterey, CABuilt 1983 · S/N 28-8411005N4330TBc 180 LLC · Chouteau, OKBuilt 1971 · S/N 28-7205142N43311Myers James · Coolidge, AZBuilt 1974 · S/N 28-7425355N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029N43316Double M Aviation LLC · Lakeland, FLBuilt 1974 · S/N 28-7415468N4331BParker Charles B · Fort Myers, FLBuilt 1983 · S/N 32-8406003N4331CLance Air Inc · Taylorsville, KYBuilt 1983 · S/N 32R-8413004N4331DAlvarado John · Brownsville, TXBuilt 1983 · S/N 28-8411004N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029N4331XS E D Air LLC · Kimball, SDBuilt 1975 · S/N 28-7625013N43321Alexander Terry · Stamps, ARFirst renewal noticeBuilt 1974 · S/N 28-7425357N43325Air Ventures Flying School LLC · Smithfield, RIBuilt 1974 · S/N 28-7425358N43326Draco Flight School DBA · Chino, CABuilt 1974 · S/N 28-7415471N4332LRubman Tracy L · Shelburne, VTBuilt 1983 · S/N 28-8416031N4332NThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8416034N4332TOld Fart Aviation LLC · Carroll, OHBuilt 1972 · S/N 32-7240065N4332XRotor Spec Aviation LLC · Star, IDBuilt 1975 · S/N 28-7515444N43335Coleman James M · Aiken, SCBuilt 1974 · S/N 28-7415472N43337Monadnock Aviation Inc · Keene, NHBuilt 1974 · S/N 28-7415473N4333AAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1983 · S/N 28-8416037N4333BLand & Leave LLC · Helena, MTBuilt 1983 · S/N 28-8416038N4333CSmart 02 LLC · Kissimmee, FLBuilt 1983 · S/N 28-8416039N4333JHaengel Marci M · Canton, MIBuilt 1967 · S/N 28-22708N4333TBluebird Airventures LLC · Bosque Farms, NMBuilt 1971 · S/N 28-7205143N4333XKoglmeier Matthew D · Mesa, AZBuilt 1975 · S/N 28R-7635012N43348A Bit Extra LLC · River Ridge, LABuilt 1974 · S/N 28-7425362N4334BRed Five Air LLC · Stuart, FLBuilt 1984 · S/N 28-8490036N4334JBest Equipment Leasing LLC · Bakersfield, CABuilt 1967 · S/N 28-22709N4334TMacphail Douglas J · East Longmeadow, MABuilt 1971 · S/N 32-7240054N4334V305 Aviation Group Inc · Miami, FLBuilt 1984 · S/N 28-8490039N4334XOxford Flying Club Inc · Oxford, CTBuilt 1984 · S/N 28-8490040N43352Lucas Jonah R · Beattyville, KYBuilt 1974 · S/N 28-7415476N43353Venture North Aviation LLC · Cloquet, MNBuilt 1974 · S/N 28-7415477N43355Calloway Enterprises LLC · Johnson City, TNBuilt 1983 · S/N 32-8406004N4335DSparrowhawk Aviation LLC · Hollister, CABuilt 1984 · S/N 28-8490043N4335JByas Victor Jr · Cleveland, MSBuilt 1967 · S/N 28-22710N4335KDodge Colleen Marie · Lake Geneva, WIBuilt 1984 · S/N 28-8490044N4335MCondor Aero Club Inc · Zelienople, PABuilt 1983 · S/N 28-8411006
Back to AD 87-08-08 R3