OpenAirDocs.org
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.

N55818Lovejoy Aviation LLC · Cato, NYBuilt 1973 · S/N 28-7325494N55819Younger Christopher · Corona, CABuilt 1965 · S/N 28-10609N5581JKts Spar Bay LLC · Coral Gables, FLBuilt 1968 · S/N 32-1038N5581WRay Justin P · Centre, ALBuilt 1962 · S/N 28-666N55821Dildy Douglas C · Albuquerque, NMBuilt 1973 · S/N 28R-7335295N55823Steele Lawrence D · Belleair Beach, FLBuilt 1973 · S/N 28-7305436N55824Ray Foster Stephen · Stockton, CABuilt 1973 · S/N 28-7325495N55827Debonis Nicholas Michael · Woodland, CABuilt 1973 · S/N 287305477N5582PPierce Stephen C · O Fallon, MOBuilt 1958 · S/N 24-646N5582UPatterson Saralyn · Oklahoma City, OKS/N 28-26311N5582WRieger Karen M · Indianapolis, INBuilt 1962 · S/N 28-697N5582YFliege Thomas D · Peoria, ILBuilt 1980 · S/N BF-1N55830Rudd Clark David · Sheboygan Falls, WIBuilt 1973 · S/N 28R-7335296N55837Mcqueen Bill · Turlock, CAS/N 28R-7335298N55838Hintenlang David · Archer, FLBuilt 1973 · S/N 28-7305435N55839David Gill · Marietta, GAS/N 28-7310133N5583FAiken Pilot Training LLC · Johnston, SCBuilt 1968 · S/N 28-24916N5583J5150 Ventures LLC · Effingham, ILBuilt 1968 · S/N 32-1043N55840Walko Michael E · Scotch Plains, NJBuilt 1973 · S/N 28-7325551N55842Ansboro James C · Goshen, NYBuilt 1973 · S/N 28-7325502N55844Cozby Charles L · Wellsboro, PAS/N 28-7325503N5584FGuiliano Anthony · Tobyhanna, PABuilt 1968 · S/N 28-24917N5584JDelano James B · Laverne, CABuilt 1968 · S/N 32-1044N5584PPinnell Roger D · Shell Knob, MOBuilt 1959 · S/N 24-648N5584QHurst Jonathan T · Seekonk, MABuilt 1964 · S/N 256N5584WDill Mark B · Amarillo, TXBuilt 1962 · S/N 28-658N55852Ingold Terry L · Albemarle, NCBuilt 1973 · S/N 28-7305484N55855Caspersen Lars · Bloomsburg, PAS/N 28R-7335301N55856Alpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1973 · S/N 32-7340143N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918N5585JPhb Aviation Inc · Melbourne Beach, FLBuilt 1968 · S/N 32-1027N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649N5585QCoxwell James · Midlothian, TXBuilt 1965 · S/N 2981N5585WFoss Jason Steven · Cokato, MNBuilt 1962 · S/N 28-665N5586DOh Joseph K · Anaheim, CABuilt 1967 · S/N 28R-30116N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487N55871Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6409N55877N A Corp · Scappoose, ORS/N 34-7350255N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518N55884Mcgee Daniel J · Indianola, IABuilt 1973 · S/N 28-7305491N55885Massa Paul G · Windsor Locks, CTBuilt 1973 · S/N 28R-7335305N55888Wild Horse Aviation LLC · Tabor City, NCBuilt 1980 · S/N 7-0382N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921N5588PNorth Town Comanche LLC · North Las Vegas, NVBuilt 1959 · S/N 24-654N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725N5588YBrennan Thomas F · Titusville, PAS/N 27-2695
Back to AD 87-10-06 R1