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.

N68XLsk Aviation Corp · Wilmington, DEBuilt 1963 · S/N 30-238N69007Jj Kramer Aviation LLC · Vero Beach, FLS/N 2933N6900DMahoney Shane · Auburn, WABuilt 1957 · S/N 22-4827N6900JCaruso Jerry W Jr · Kingsbury, NYBuilt 1976 · S/N 28-7615393N6900NBond William E · Elk River, MNBuilt 1968 · S/N 680168N6900PMyer Charles G · Forest Lake, MNBuilt 1960 · S/N 24-2034N6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 60-8265027N6900URegistered aircraftBuilt 1964 · S/N 2695N6900WHall William Brent · Tulia, TXBuilt 1965 · S/N 28-21063N6900ZIndependence Glider Club · Independence, ORBuilt 1964 · S/N 25-2634N6901ASpence Stephen L · Anchorage, AKBuilt 1956 · S/N 29001N6901HRieser Steven E II · Baltimore, OHS/N 17265637N6901NRagsdale James W · Geneva, FLS/N 680134N6901QCbus Flight LLC · Pickerington, OHBuilt 1967 · S/N MB-265N6901ULime Lounge LLC · Des Moines, IABuilt 1964 · S/N 2696N6902DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-4829N6902NSherrill Charles H · Robert Lee, TXBuilt 1968 · S/N 680169N6902YJ L Darr & Son Inc · High Point, NCBuilt 1969 · S/N 27-4256N6903BJones Gary L · Kerrville, TXBuilt 1956 · S/N 22-4175N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425N6903NRoland Jason R · Royse City, TXBuilt 1968 · S/N 680170N6903PStack Gregory R · Aurora, COBuilt 1960 · S/N 242037N6903QSullivan Lynford M · Hernando, MSBuilt 1967 · S/N MB-267N6903RFusion Marine Inc · Stuart, FLS/N 60-8365015N6903UPray Aviation Inc · Augusta, KSBuilt 1964 · S/N 2698N6904ALesser Antilles Corp Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954076N6904DLucas Michael F · Germantown, OHS/N 22-4831N6904NSchaffhauser Daniel L · Garland, TXBuilt 1968 · S/N 680135N6904UMyers Ronnie L DBA · Appling, GABuilt 1964 · S/N 2699N6904YUnited Jet Sales Inc · Newark, DEBuilt 1969 · S/N 27-4259N6905DEvans Theresa K · Alexandria, MNBuilt 1957 · S/N 22-4832N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638N6905JDouble Delta Sierra LLC · Bristol, CTBuilt 1976 · S/N 28R-7635359N6905NZero Five November Holding Inc · Kalispell, MTBuilt 1968 · S/N 680171N6905PMampel Gregory J · New Port Richey, FLBuilt 1960 · S/N 24-2039N6905VOscar Mike Appraisal Group LLC · Greenville, SCBuilt 1975 · S/N 20-1175N6905WPodeweltz Wayne L · Merrill, WIBuilt 1965 · S/N 28-21071N6905ZZellers And Smith Enterprises LLC · Flowood, MSBuilt 1968 · S/N 28R30649N6906JBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 32R-7680383N6906PKapeller James A · Wickenburg, AZFirst renewal noticeBuilt 1960 · S/N 24-2040N6906QFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N MB-283N6906VMatthews Cheryl L · Baker City, ORS/N 20-1176N6906WStandard American Adjusters Inc · Alba, TXS/N 28-21072N6907BJordan Walter B · Chehalis, WABuilt 1956 · S/N 22-4182N6907JFisher Bradley J · Bryant, INBuilt 1976 · S/N 32R-7680384N6907NHensley Tyler · Leland, NCBuilt 1968 · S/N 680136N6907PHolbein Mark A · Freeport, PAS/N 24-2041N6907VPounds Gregory S · Sykesville, MDBuilt 1975 · S/N 20-1177N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050N6908KRegistration Pending · Dillingham, AKRegistration pendingBuilt 1950 · S/N 20-12
Back to AD 87-10-06 R1