OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943N3509W92nd West Aviation Inc · Lonoke, ARS/N TH-350N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351N350NWBas Part Sales LLC · Greeley, COBuilt 1977 · S/N CE-753N350TBStephenson Richard J Trustee · Wheeling, ILBuilt 1973 · S/N E-413N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075N3536AAirborne Resources Inc · Midlothian, TXBuilt 1970 · S/N TE-775N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485N354BWCarpenter Richard A · Hermiston, ORBuilt 1979 · S/N EA-40N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313N355SAReddy James N Trustee · Port Orange, FLBuilt 2000 · S/N E-3357N3566WGriffin Aviation LLC · Minneapolis, MNBuilt 1999 · S/N TH-1930N356HCai Tech LLC · Greenwood, DEBuilt 2004 · S/N E-3566N357JTClub Bo A36 LLC · Helena, MTBuilt 1979 · S/N EA-51N358ALlewellyn Development LLC · Charlotte, NCBuilt 1978 · S/N D-10163N358CMEathcirc 08 LLC · Tucson, AZBuilt 1989 · S/N TH-1546N358PBN358pb LLC · Amarillo, TXBuilt 1977 · S/N TJ-90N358SANelson Robert M Jr · Plano, TXBuilt 1998 · S/N E-3192N358YJuliet Air LLC · Cincinnati, OHS/N TH-1551N3594AFlying Fur Animal Rescue · Kintnersville, PABuilt 1969 · S/N D-9072N3595ALogistics Consulting LLC · Wilmington, DEBuilt 1969 · S/N TE-776N359ERJames Chad · Needville, TXBuilt 1978 · S/N D-10182N359PTilloo Aviation LLC · Pensacola, FLS/N TH-1229N35AUHat Creek Construction & Materials Inc · Burney, CABuilt 1985 · S/N EA-448N35BCjs Aviation LLC · Methuen, MABuilt 1974 · S/N D-9588N35BMBecker Lawrence D Md · Anacortes, WABuilt 1970 · S/N D-9191N35BNAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N D-9907N35BTMarconi Properties LLC · Westbrook, CTBuilt 1979 · S/N D-10255N35CGComesa Service Group · Middletown, DEFirst renewal noticeBuilt 1972 · S/N D-9373N35EKHaupt Erik · Great Barrington, MABuilt 1979 · S/N D-10238N35KAHacker Timothy J · Pangburn, ARBuilt 1979 · S/N D-10231N35KJBunn John Timothy · Winter Garden, FLBuilt 1972 · S/N D-9326N35KWCoy Walter Thomas · Titusville, FLBuilt 1975 · S/N D-9827N35LFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N D9820N35MSimmons Dennis L · Wichita, KSBuilt 1970 · S/N D-9143N35MFFlying Barefoot Ranch LLC · Wilmington, DEBuilt 1980 · S/N D-10304N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442
Back to AD 87-18-06 R1