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.

N905XCFlores-Cortes Jose Natividad · Los Angeles, CABuilt 2011 · S/N 5129N90608Hacker Henry · Mc Gregor, TXBuilt 1976 · S/N 61P-0318-087N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9060JGillis Joseph V · Tempe, AZBuilt 1966 · S/N 28-3094N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70N9060WDoyle Thomas M · New City, NYBuilt 1965 · S/N 28-10655N90618Gm Homes Inc · Campobello, SCBuilt 1966 · S/N 65-18251N9061DRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-6426N9061PLangley Preston B · Warwick, NDBuilt 1966 · S/N 24-4528N9061RCavender Matt · Howe, TXBuilt 1967 · S/N 47-0696N9061SObrien Derrick P · Lehigh Acres, FLS/N 76-0609N9061VRegistered aircraftBuilt 1968 · S/N 690007N90623Cassady Grant W · Tulsa, OKBuilt 2008 · S/N 40628N9062DKing Gary W Jr · Anchorage, AKBuilt 1958 · S/N 18-6427N9062JVernon Sharnell Tamieko · Phoenix, AZS/N 28-3096N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70N9062VJacobsen Dennis S · Reno, NVBuilt 1968 · S/N 690009N9062WBartling David Ryan · Mesa, AZBuilt 1965 · S/N 28-10659N9063DHanson Lavon T · Saint Ignatius, MTBuilt 1958 · S/N 18-6428N9063JHardison Samuel H · Mountain View, ARS/N 28-3097N9063LKnutson Flying Service Inc · Tioga, NDBuilt 1965 · S/N 1801N9063PDavis Clyde Jackson Jr Trustee · Tehachapi, CABuilt 1966 · S/N 24-4530N9064JSolomon Michael Lee · Hope Mills, NCBuilt 1966 · S/N 28-3099N9064LHendrickson Don W · Helena, MTBuilt 1970 · S/N 247-70N9064VMitchell Benjamin · Riverdale, UTBuilt 1968 · S/N 690010N9064WDerbyshire Alan C · Marathon, FLBuilt 1965 · S/N 28-10661N9065POdenbach Eric J · Eureka, SDBuilt 1966 · S/N 24-4533N9065VRussell Robert D · Aurora, COBuilt 1968 · S/N 690009N9065WJ & K Enterprises Inc · Waukesha, WIBuilt 1965 · S/N 28-10663N90669Cape Copters LLC · Scott City, MOBuilt 1981 · S/N 0119N9066EKilmer Randall W · Bellefonte, PAFirst renewal noticeBuilt 1977 · S/N 7076CN9066RForage Jean Pierre Md · Lakeway, TXBuilt 1978 · S/N R18200660N9066WKurtz Brian · Troy, ALBuilt 1965 · S/N 28-10665N90679Kansas City Aviation Center Inc · Olathe, KSBuilt 1976 · S/N 61-0357-115N9067DWing Robert E · Fairbanks, AKS/N 18-6432N9067JEvans Jennifer M · Escalante, UTS/N 28-3102N9067PMahathey Tony C · Colorado Springs, COBuilt 1966 · S/N 24-4535N9067VAdventist World Aviation · Wilson, NCS/N 690010N90687Robinson Jere L · Burnet, TXBuilt 1968 · S/N 18-8734N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928N9068JGregory Brent · Townsend, DES/N 28-3103N9068SBuehler Andrew · Eatonville, WABuilt 1981 · S/N 0172N9068VPyle Brian D · Mooresville, NCBuilt 1968 · S/N 690012N9069FWoodman Dwight C · Hudson, FLBuilt 1981 · S/N 0177N9069LCitabria Flyers LLC · North Salt Lake, UTBuilt 1970 · S/N 252-70N9069PGeer James Benjamin · Olympia, WABuilt 1966 · S/N 24-4537N9069VErban Bryce · Stillwater, MNBuilt 1968 · S/N 690011N9069WSchultz David L · Bernalillo, NMBuilt 1965 · S/N 28-10669N9069YAmi Aviation Inc · Monroe, NYBuilt 1967 · S/N 31-99
Back to AD 87-10-06 R1